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 […]
Execute Following action plan to disable GL Account and all associated GL code combinations. Query GL Account Value Set through Flexfield à Validation à Values Then uncheck “Enabled” check box and save the changes Then […]
It may not always be the case that Account codes will be created by user from the front end. There may be scenarios sometimes where we need to have programs that will be creating the code combinations. […]
1) Key Assumption is “Allow Dynamic Inserts” should have been enabled for GL Accounting Flexfield Structure One May have to use apps initialize, but mostly not required if called from concurrent program. fnd_global.apps_initialize(resp_appl_id => 101, […]
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 […]
Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc. select aipa.check_number, aipa.check_id, aia.payment_method_code, aia.payment_status_flag, aipa.status_lookup_code, aipa.reversal_flag, aia.wfapproval_status, haout.name, asup.vendor_name, asup.vendor_id, aia.invoice_num, aia.invoice_id, […]
–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 […]
Use following query to find the accounting package is being used select * from all_objects where object_name in (select ‘XLA_’||LPAD(application_id ,5 ,0) || ‘_AAD_’||product_rule_type_code || ‘_’||LPAD(product_rule_hash_id,6 ,0) || ‘_PKG’ from xla.XLA_PRODUCT_RULES_B where (application_id, product_rule_type_code, product_rule_code, […]
Issue: Payment is not getting accounted or payment is not posting to GL. Analysis: Query the Payment, then navigate to Tools à View Accounting Events à Check the status of Event_Status on accounting event page, […]
Requirement: Requirement is to identify Fixed Asset and Payables transaction related Asset Clearing Account coming into GL. This is to make the reconciliation of asset clearing account easy. Solution: Build BI Publisher report using following script […]
