PO接收產生分錄

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_EVENTS2.RCV_SeedEvents_PVT.Insert_RAEEvents-->-- Call Account generation API to create accounting entries-- insert RCV_RECEIVING_SUB_LEDGER3.RCV_CreateAccounting_PVT.Create_AccountingEntry-->4.CST_XLA_PVT.Create_RCVXLAEvent-->XLA_EVENTS_PUB_PKG.create_eventPSA_BC_XLA_PUB.Budgetary_Control5.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;