How to Change Accounting Class Code

 If XLA Lookup of XLA_ACCOUNTING_CLASS is changed, Accounting Class Code is changed.

Example for "Write Off" :

Responsibility: Application Developer Responsibility
Navigation: Application > Lookups > XLA Lookups

1.  Search type "XLA_ACCOUNTING_CLASS".
2.  Search "WRITE_OFF" code.
3.  Update "Meaning" from "Write Off" to value which you use.
4.  Save it.

Responsibility:  Receivables Responsibility

1.  Create "Receipt Write-off" application.
2.  Run Create Accounting with "Draft" mode.
3.  Accounting Class is changed.
   
   
   

SLA : Account Derivation Rule Script

 /* account derivation rule  */

SELECT xsr.user_sequence Priority,xsr.VALUE_TYPE_CODE,xsr.VALUE_CODE_COMBINATION_ID,xc.user_sequence seq
,xc.SOURCE_TYPE_CODE,xc.SOURCE_CODE,xc.LINE_OPERATOR_CODE,xc.VALUE_TYPE_CODE VLAUE_TYPE,xc.VALUE_CONSTANT
  FROM xla_seg_rule_details xsr,
       xla_conditions xc
 WHERE segment_rule_code = 'XX_RCA_COMBINATION1'
   AND xsr.SEGMENT_RULE_DETAIL_ID = xc.SEGMENT_RULE_DETAIL_ID
   AND xsr.application_id = xc.application_id
   
--   AND xsr.user_sequence > 600
--   AND xsr.user_sequence <= 1020

Oracle Subledgers to AP Drill Down Query

Subledgers(SLA) to AP Invoice Drill Down Script

Select ap.* FROM ap.ap_invoices_all ap

          WHERE  AP_INVOICES_PKG.GET_POSTING_STATUS(ap.INVOICE_ID)='Y' 

          AND ap_invoices_pkg.get_approval_status(ap.invoice_id, ap.invoice_amount,ap.payment_status_flag,ap.invoice_type_lookup_code )<>'CANCELLED'

          AND ap.gl_date >= :p_start_date

          AND ap.gl_date <= :p_to_date

          AND NOT EXISTS (Select 1--upg.source_id_int_1,upg.security_id_int_1,sum(NVL(xal.accounted_dr,0) - NVL (xal.accounted_cr,0) ) net_balance

                          FROM 

                               xla_ae_lines xal,

                               xla_ae_headers xah,

                               xla_transaction_entities_upg upg

                         WHERE 1=1 

                           AND xal.ae_header_id = xah.ae_header_id

                           AND xah.entity_id = upg.entity_id

                           AND upg.entity_code = 'AP_INVOICES'   

          AND upg.source_id_int_1 = ap.invoice_id 

          AND upg.security_id_int_1 = ap.org_id);

Pocket Hanuman Chalisa (Hindi)