AR Reconciliation – Internal (Within AR) and External (GL) in R12
Ref: Oracle Webcast – Oracle receivables posting & Reconciliation in R12
Receivables
Receivables Important Concurrent Programs For Posting in R12
Receivables Important Concurrent Programs for Posting in R12 •Create Accounting •Submit Accounting •Transfer Journal Entries to General Ledger •Unposted Items Report •Revenue Recognition •Subledger Period Close Exception Report Create Accounting a) Invoice distribution lines not […]
Geography Name Referencing Process — TCA in R12
Geography Name Referencing Process – TCA in R12 1. What is the purpose of Geography Name Referencing Process? The purpose of Geography Name Referencing process is to validate address elements in location tables, such as […]
How to Setup the New Manage Accounting Exception Program (Sweep) in Receivables?
Goal: How can I setup the new Consolidated Review and Manage Accounting Exception Program in Receivables? Also referred to as the Sweep program. Solution: Please perform the following: For Release 12.1, in order to enable […]
AR Autoinvoice vs AR Invoice API vs AR Credit Memo API R12
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 […]
How To Find AR Transaction Sequence or AR Transaction Sequence By Source
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 […]
How to Alter Database Sequence or How to increment or decrements sequence.
How to Alter Database Sequence or How to increment or decrements sequence. select * from all_sequences where sequence_name like ‘RA_TRX_NUMBER%’; SELECT last_number FROM all_sequences WHERE sequence_name = ‘RA_TRX_NUMBER_N1_81_S’; SELECT last_number FROM all_sequences WHERE sequence_name = […]
Enterprise Resource Planning and Integrations BlogSpot 