GL Daily FX Rate Upload
Following are 3 key programs that can be used to upload GL Daily Conversion Rates. A) XXCB FX Rates Data Load Program B) XXCB FX Rates Validation Procedure Program C) Program – Daily Rates Import […]
Author: Yogesh Pachpute
Query to find all responsibilities of a user
——————————————————————————- — Query to find all responsibilities of a user ——————————————————————————- SELECT fu.user_name “User Name”, frt.responsibility_name “Responsibility Name”, fu.start_date “User Access Start Date”, fu.end_date “User Access End Date”, furg.start_date “Resp Access Start Date”, furg.end_date “Resp […]
Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc.
Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc. 1 2 3 4 5 6 7 8 9 10 11 12 13 […]
Drilldown from GL to AP for Liability and Prepayment and Expense account
–Query to get GL Batches, Journal and Lines for Liability Account for a single GL period for source Payables and Category Purchase Invoices if you want include payment category then comment out category equals Purchase […]
How To View Expense Report Export Results in R12
In R12, the Export Results are viewed via the Application. Follow steps: 1. Login to the System Administrator responsibility a. -Navigate to: Security -> Responsibility -> Define -Query the name of the Payables Manager Responsibility […]
How to handle a single quote in Oracle SQL
Problem: I have a column containing certain expressions stored as a text string which include single quotations, such as ‘missed transaction’ (INCLUDING the quotations) How can I use a where clause with such an occurrence? […]
How to Analyze Long Running or Pending Concurrent Requests jobs
a) 1.Run the script for any concurrent request which is going into pending/running status and upload the output to SR. Note 134033.1 ANALYZEPENDING.sql Script for Analyzing all Pending Requests or Note 134035.1 ANALYZEREQ.SQL – Detailed […]
Amex KR1022 and KR1025 File and Oracle R12
1025 is daily Amex feed and supported by Oracle to upload Amex feed 1022 is Monthly file and equivalent to electronic copy of statement that is coming in. We can either choose to upload daily […]
What Are The Supported Credit Card Data File Formats?
What are the supported Credit Card Data File Formats? 1. American Express KR-1025 format (file name is Card Daily Data Feed) 2. Diner’s Club Standard Data File Format (file name is trans.dat) 3. US Bank […]
Implementing Accounting Client Extensions for Oracle Internet Expenses
Implementing Accounting Client Extensions for Oracle Internet Expenses Table of Contents This white paper contains the following information. Overview Standard Accounting Generation Non-Project Expenses Expense Allocations Enabled with Online Validation Expense Allocations Enabled without […]
Enterprise Resource Planning and Integrations BlogSpot 