-
Ahmed Hassan
- April 10, 2024
- Oracle Fusion Cloud
- (0)
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,…
-
- May 29, 2023
- Oracle Ebusiness suite R12
- (0)
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')…
