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
oracle sample schema
Oracle sample schema, step by step how to install it, Everything you need to know!

If you are willing to learn SQL and run some test scripts, you will need to install oracle sample schemas. On this post we are going to install oracle database…

Continue reading
how to install oracle 19c on windows
How to install Oracle Database 19c on windows 11? All you need to know.

https://www.youtube.com/watch?v=2bcsdu-BVEA&t=3s     #Step 1: Search for downloadable file. Open your browser and search for Oracle Database download, most likely it will be the first result. #Step 2: select Oracle…

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
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
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