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 […]
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? […]
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 […]
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? 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 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 […]
APPLIES TO: BI Publisher (formerly XML Publisher) – Version 12.0 to 12.1 [Release 12.0 to 12.1] GOAL The goal of this document is to indicate the patch that needs to be applied to support FTP/SFTP […]
Following joins will helps to understand exact relation between iExpenses and AP invoices. 1 2 3 4 5 6 SELECT aerh.vouchno, aerh.report_header_id FROM ap_expense_report_headers_all aerh, ap_invoices_all ap WHERE aerh.expense_status_code = 'INVOICED' AND ap.invoice_id= aerh.vouchno; then […]
A) AutoInvoice requires a batch of type Imported. Batch sources define default information such as transaction type and automatic numbering. There are two types available: Manual and Imported. AutoInvoice requires a batch of type Imported. Autoinvoice […]
Use the following query to find AR Transaction Sequence By Source. SELECT * FROM all_sequences WHERE sequence_name LIKE ‘RA_TRX_NUMBER%’; Some Tips Example 1) Sequence RA_TRX_NUMBER_N1_81_S is a standard and manual source, this means N1 represents manual source. Example […]
Enterprise Resource Planning and Integrations BlogSpot 