GL Transactions for AR Adjustments

Introduction

This Post illustrates the steps required to GL Transactions for AR Adjustments in Oracle EBS R12.

 

Script to 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,

NULL ponum_inv_linenum, art.description line_desc,

NULL requestor_qty_inv, NULL appr_date_unitprice, NULL doc_seq_revamt,

NULL acct_class, NULL PERCENT,

(  DECODE (ada.amount_dr, NULL, 0, ada.amount_dr)

– DECODE (ada.amount_cr, NULL, 0, ada.amount_cr)

) amount,

(  DECODE (ada.acctd_amount_dr, NULL, 0, ada.acctd_amount_dr)

– DECODE (ada.acctd_amount_cr, NULL, 0, ada.acctd_amount_cr)

) dist_amt

FROM xla_ae_headers aeh,

xla_ae_lines ael,

xla_events xle,

xla.xla_transaction_entities ent,

xla_distribution_links xdl,

ar_distributions_all ada,

ar_payment_schedules_all aps,

ar_adjustments_all aaa,

ar_receivables_trx_all art

WHERE 1 = 1

AND ael.application_id = aeh.application_id

AND ael.ae_header_id = aeh.ae_header_id

AND xle.application_id = aeh.application_id

AND xle.event_id = aeh.event_id

AND ent.application_id = xle.application_id

AND ent.entity_id = xle.entity_id

AND xdl.ae_header_id = aeh.ae_header_id

AND xdl.ae_line_num = ael.ae_line_num

AND aaa.payment_schedule_id = aps.payment_schedule_id

AND aaa.receivables_trx_id = art.receivables_trx_id

AND xdl.source_distribution_id_num_1 = ada.line_id

AND ent.source_id_int_1 = aaa.adjustment_id

AND ael.ae_header_id = p_hdrid

AND ael.ae_line_num = p_linenum;

 

What we expect in the script.

This script helps us to comprehend how GL Transactions for AR Adjustments. Couple of tables which is being used in the query are

xla_ae_headers aeh,

xla_ae_lines ael,

xla_events xle,

xla.xla_transaction_entities ent,

xla_distribution_links xdl,

ar_distributions_all ada,

ar_payment_schedules_all aps,

ar_adjustments_all aaa,

ar_receivables_trx_all art

Summary

This Post described the script for GL Transactions for AR Adjustments in Oracle EBS R12.

 

Got any queries?

Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.