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 […]
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 […]
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 […]
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 = […]
