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 user responsibilities in oracle apps
Query to get user responsibilities in oracle apps EBS R12. Run it now

Query to show all changes on responsibilities and roles on oracle apps EBS R12, It show all added or removed responsibilities for all users within range of date. This query…

Continue reading
ap_supplier_sites_all
How to get all supplier sites and contacts on oracle EBS R12. easy and fast.

Use this EBS R12 query for the following requirements: - Find all supplier sites and contact details for for vendors. - Extract all site details for fusion data migration purpose.…

Continue reading
Query to get AR invoice details on Oracle E-business EBS R12, Easy and Fast.

/*get AR invoice Lines Detailes */ SELECT DISTINCT rl.customer_trx_line_id, DECODE (RCTT.TYPE, 'CB', 'Chargeback', 'CM', 'Credit Memo', 'DM', 'Debit Memo', 'DEP', 'Deposit', 'GUAR', 'Guarantee', 'INV', 'Invoice', 'PMT', 'Receipt', 'Invoice') INVOICE_CLASS, --…

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
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 AP invoices in Oracle EBS r12 for Oracle Fusion Data migration FBDI, Simple Query

The following is query to find all AP open invoices in Oracle ebs R12, run it, export the result on excel sheet, and move it to Oracle template FBDI for…

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