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