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

erp common issues
What is the most common issues in implementing ERP systems, & How to avoid it? All you need to know!

Common issues in implementing ERP systems: 1. Resistance / Subtle resistance. Subtle resistance means that someone will claim he or she is interesting in the project and willing to do…

ERPScope Knowledge base
What is the meaning of ERP system? Easy to understand.

ERP referees to Enterprise resource planning, it is a software which companies and organization manage their resources and daily operations. This may includes group of integrated applications like general ledger,…

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…

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…

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…

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

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')…

Oracle NetSuite
What is oracle Netsuite? All you need to know.

Oracle NetSuite is a cloud-based enterprise resource planning (ERP) software suite designed to help businesses manage their core processes, such as financial management, inventory management, customer relationship management (CRM), e-commerce,…