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
Reasons why to upgrade from EBS to Oracle Fusion Cloud now.

Many organizations have been using Oracle E-Business Suite (EBS) for over a decade without encountering significant issues. This has led some of them to question the necessity of upgrading to…

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