HEADER_INTERFACE_ID NUMBER 18 Unique identifier for the receipt header interface record for which this transaction interface record is created. Maps to RCV_HEADERS_INTERFACE.HEADER_INTERFACE_ID. VENDOR_CUM_SHIPPED_QTY NUMBER Supplier's CUM quantity shipped specified on the Advance Shipment Notice (ASN...
Successfully creating ASN through ROI, Receiving Transaction Processor (RTP) still leaves column RCV_HEADERS_INTERFACE.PROCESSING_STATUS_CODE as "ERROR" instead of "SUCCESS"Steps to reproduce:===1. Create a standard PO. Approve PO.2. Create ASN in RHI/RTI with shipment#ASN123-43. Run RTP...
6. Get the dumps of rcv_headers_interface & rcv_Transactions_interface transaction after RTP run. Please give the output in .xls format, say rti_after_rtp.xls & rhi_after_rtp.xls 7. Sql trace file will get generated under udump folder. ...
Receipt的后台逻辑,实际上是插入一条记录到rcv_transactions_interface里,然后调用Receiving Transaction Processor来处理RTI里的数据,如果报错,错误信息会写po_interface_errors表中。 Receipt成功运行之后,可以看到RTI的数据被删除,RCV的相关数据也会生成在rcv_shipment_headers,rcv_shipment_lines,rcv_transactions,rcv_suppl...
选添加至接收时，让用户选一下最近的接收号呗，或者默认上次最后一个。。
CMR_ACCR_RECONC_HEADERS CMR_ACCT_OPTIONS_GT CMR_ALL_PERIOD_VALERR_TXNS CMR_AP_ERRORS_GT CMR_AP_FINANCIAL_OPTIONS_GT CMR_AP_INTERFACE_ERRORS CMR_AP_INVOICE_DTLS CMR_AUTO_ACCRUAL_CLR_DTLS CMR_BILL_TO_BU_INV_ORGS CMR_BU_AP_INVOICES_GT ...
6. Get the dumps of rcv_headers_interface & rcv_Transactions_interface transaction after RTP run. Please give the output in .xls format, say rti_after_rtp.xls & rhi_after_rtp.xls 7. Sql trace file will get generated under udump folder. Use the following sql to get the udump path. ...
How to populate only RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES tables for RMA Hi, We need to populate RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES tables in case of RMA through RCV interface. However, it should not create record in RCV_TRANSACTIONS table. Please help....
from RCV_SHIPMENT_HEADERS rsh, rcv_shipment_lines rsl where rsh.shipment_header_id=rsl.shipment_header_id and rsh.creation_date>=trunc(sysdate) and rsh.receipt_num='185631' select * from rcv_transactions rt wherert.transaction_id=870339 ...
Alternatively, you can run the Tabulator using the command-line interface by including the flag--cliand then supplying a path to an existing config file, e.g.: $ rcv --cli path/to/config Or, if you're compiling and running using Gradle: ...