Query to get bank account details in Oracle E-business R12 CM, quick results.

/*Query to get All bank accounts in Oracle EBS R12 */ SELECT A10.HOME_COUNTRY "Country", a10.bank_name "Bank Name", CBA.BANK_ACCOUNT_NAME "Account Name", A10.BANK_PARTY_ID "Bank Code", BB.BANK_BRANCH_NAME "Branch Name", BB.BANK_BRANCH_ID "Bank Brach Code",…

Continue reading
Query to get AR unearned revenue in Oracle EBS R12 & Invoice distributions: Easy!

/* AR Invoice Distribution */ SELECT rl.line_number, SUM (APS.AMOUNT_DUE_ORIGINAL) "Invoice Orignal Amount", TO_CHAR (RCTA.TRX_DATE, 'YYYY/MM/DD') "TRANSACTION DATE", TO_CHAR (gld.gl_date, 'DD/MM/YYYY') "GL Date", RL.ACCOUNTING_RULE_DURATION, TO_CHAR (RL.RULE_START_DATE, 'DD/MM/YYYY') RULE_START_DATE, TO_CHAR (RL.RULE_END_DATE, 'DD/MM/YYYY')…

Continue reading
Top ERP systems
What is the Top 5 ERP systems?

1 -Oracle Fusion Cloud: Oracle Fusion Cloud: Oracle ERP Cloud is a cloud-based ERP solution that provides a suite of integrated applications to manage financials, procurement, project management, supply chain,…

Continue reading
AR_TRANSACTIONS
How to get All AR open transactions on EBS R12.

Check out our query to get All AR transaction in Oracle EBS R12. Use this query EBS R12 for the following requirements: 1 - Extract All open Transactions on oracle…

Continue reading
How to get open receipts for EBS to Fusion data migration.

You can use the below open receipts query for the following purpose: Oracle EBS to Fusion data migration - for preparing FBDI sheets. if user ask you for the open…

Continue reading
EBS R12 Query to find GL transactions
Query to find all GL transactions on oracle EBS R12, Easy and fast!

This GL Query can used for the following requirements: Extract EBS GL Transactions for fusion migration. Extract all GL transactions for Auditing purpose. Extract all GL Journal Entries Transactions based…

Continue reading