学步园

1,发运行的接收应计(PO_LINE_LOCATIONS_ALL.ACCRUE_ON_RECEIPT_FLAG)控制接收时是否产生分录.
2,分配行的接收应计(PO_DISTRIBUTION_ALL.ACCRUE_ON_RECEIPT_FLAG)控制发票匹配PO时,分配行的科目取PO charge account,还是取暂估科目.
3,强制接收时产生分录:
  3.1,update PO_LINE_LOCATIONS_ALL set ACCRUE_ON_RECEIPT_FLAG='Y' where ...
  3.2,update PO_DISTRIBUTION_ALL set ACCRUE_ON_RECEIPT_FLAG='Y' where ...
  3.3,删除delete from RCV_ACCOUNTING_EVENTS WHERE rcv_transaction_id = 9430(一般情况是RCV_ACCOUNTING_EVENTS有, RCV_RECEIVING_SUB_LEDGER 没有)
  3.4,调用产生分录的API,传入transaction id
    RCV_AccEvents_PVT.Create_DeliverEvents(p_api_version => 1.0,
                                           p_commit             => FND_API.G_TRUE,
                                           x_return_status      => l_return_status,
                                           x_msg_count          => l_msg_count,
                                           x_msg_data           => l_msg_data,
                                           p_rcv_transaction_id => 9430)
      1.RCV_AccEvents_PVT.Create_DeliverEvents-->
        RCV_SeedEvents_PVT.Seed_RAEEvent
        --2. insert RCV_ACCOUNTING_EVENTS
        2.RCV_SeedEvents_PVT.Insert_RAEEvents-->
          -- Call Account generation API to create accounting entries
           -- insert RCV_RECEIVING_SUB_LEDGER
          3.RCV_CreateAccounting_PVT.Create_AccountingEntry-->
              4.CST_XLA_PVT.Create_RCVXLAEvent-->
                XLA_EVENTS_PUB_PKG.create_event
                PSA_BC_XLA_PUB.Budgetary_Control
                5.xla_accounting_pub_pkg.accounting_program_events
                          (p_application_id       => 707
                           ,p_accounting_mode      => 'FINAL'
                           ,p_gl_posting_flag      => 'Y'
                            ...
                    -->6.xla_accounting_pkg.accounting_program_events-->
                         events_processor
                         xla_balances_pkg.massive_update
                         xla_transfer_pkg.gl_transfer_main
                         xla_accounting_pub_pkg.accounting_program_document-->
                         fnd_request.submit_request(application     => 'XLA'
                                                 ,program         => 'XLAACCPB'
                         ...
                        7.xla_accounting_pkg.accounting_program_document-->
                          xla_accounting_pkg.accounting_program_events
  3.5,查看错误信息:xla_accounting_err_pkg.insert_errors;
    select * from xla_accounting_errors;

------------------------------
Select aeh.ae_header_id,
       ael.ae_line_num,
       ael.accounting_class_code,
       ael.accounted_dr,
       ael.accounted_cr,
       rt.transaction_id,
       rt.shipment_header_id
  from xla_ae_headers           aeh,
       xla_ae_lines             ael,
       rcv_transactions         rt,
       XLA_DISTRIBUTION_LINKS   xdl,
       rcv_receiving_sub_ledger rrsl
 where aeh.ae_header_id = xdl.ae_header_id
   and aeh.ae_header_id = ael.ae_header_id
   and ael.ae_header_id = xdl.ae_header_id
   and ael.ae_line_num = xdl.ae_line_num
   and xdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'
   and xdl.SOURCE_DISTRIBUTION_ID_NUM_1 = rrsl.RCV_SUB_LEDGER_ID
   and rrsl.rcv_transaction_id = rt.transaction_id
   and rrsl.set_of_books_id = 2045
   and rt.transaction_id = 14449
/*  and rt.shipment_header_id IN
(SELECT shipment_header_id
   FROM rcv_shipment_headers
  WHERE receipt_num = '&RECEIPT_NUM')*/
 order by rt.transaction_id, ael.ae_header_id, ael.ae_line_num;

 

 

http://skyz.blog.35.cn/?paged=2