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. 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, […]

How to find SubLedger accounting package being used for custom or standard subledger accounting engine

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