Blog / Category
GL transactions
7 articles in this category
How to Manage/Correct Daily Rates through ADFDI
How to Manage/Correct Daily Rates through ADFDI Introduction:- Oracle Fusion Cloud Applications 23B (11.13.23.04.0) Information in this document applies…
Auto Reversal Journal Setup
Auto reversal in oracle means , We will create some rules and setups for some GL journal source which will automatically reverses the GL journals for that Sourc…
Drill Down Query From GL into Project Accounting subledger
The below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Project Accounting sub-ledger m…
GL Transactions for Payments
SELECT DISTINCT aca.payment_method_lookup_code trans_type, TO_CHAR (aca.check_number) invoice_num,  …
GL Transactions for AR
SELECT rctt.description trans_type, TO_CHAR (rct.trx_number) invoice_num, TO_CHAR (rct.trx_date) invoice_date, &…
GL Transactions for AR Adjustments
SELECT NULL trans_type, ent.transaction_number invoice_num, (SELECT TO_CHAR (trx_date) FROM ra_cus…
GL Transactions for AP
SELECT /*+ leading (ael aeh) */ aia.invoice_type_lookup_code trans_type, ent.transaction_number invoice_nu…