GL transactions

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 to any oracle fusion platform. Cause of the issue:- In…

Read More

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 Source as per the Auto Reversal Setup. here below we will…

Read More

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 modules. SELECT      GLCC.concatenated_segments segments      …

Read More

GL Transactions for Payments

SELECT DISTINCT aca.payment_method_lookup_code trans_type,                 TO_CHAR (aca.check_number) invoice_num,                 TO_CHAR (aca.check_date) invoice_date,        …

Read More

GL Transactions for AR

SELECT rctt.description trans_type, TO_CHAR (rct.trx_number) invoice_num,        TO_CHAR (rct.trx_date) invoice_date,        TO_CHAR (rcl.line_number) ponum_inv_linenum, rcl.description line_desc,        TO_CHAR (rcl.quantity_invoiced) requestor_qty_inv,        TO_CHAR…

Read More

GL Transactions for AR Adjustments

SELECT NULL trans_type, ent.transaction_number invoice_num,        (SELECT TO_CHAR (trx_date)           FROM ra_customer_trx_all          WHERE customer_trx_id = aaa.customer_trx_id) invoice_date,      …

Read More

GL Transactions for AP

SELECT /*+ leading (ael aeh) */        aia.invoice_type_lookup_code trans_type,        ent.transaction_number invoice_num,        TO_CHAR (aia.invoice_date) invoice_date,        TO_CHAR (pod.po_number) ponum_inv_linenum,    …

Read More