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
Oracle fusion modules list
What is the oracle fusion list of modules now?

What is the main tracks of ERP system Oracle Fusion Cloud ? There are three basic tracks on oracle fusion cloud Finance track: this includes all finance modules like GL,…

Continue reading
What is Microsoft dynamics 365? Is it good for your business? All you need to know!

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications developed and marketed by Microsoft. It encompasses a suite of integrated business management…

Continue reading
How to become oracle expert – developer? steps to start your career, All you need to know!

Oracle has a wide range of specializations and careers for its products, which means you must select which specific path you need to follow. Most of the time this specialization…

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
What is P2T and T2P refresh in Oracle fusion cloud? All you need to know!

P2T Refresh: P2T refers to production to test cloning, which allow you to copy all your production transactions and configurations to your test Environment. This process usually takes around three…

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
What is Odoo systems? All you need to know! helpful and Easy.

What is Odoo? Odoo is an open-source applications for business management and ERP systems, It includes a a wide range of applications and modules to help organizations manage their various…

Continue reading