{Period Close} Resolving Pending Receiving Transactions @ Oracle eBS經驗分享

資料來源：Oracle Pending Transactions Guide page 21 of 32.

In resolving Pending Receiving Transactions the status and quantity received of the actual purchase order of the receiving transaction should be reviewed. If after reviewing the Purchase Order if the status is closed or complete and the purchase order quantity is equal to the quantity received then most likely the Pending Receiving transaction is a duplicate. Duplicate transactions can be deleted through the ‘Transaction Status Summary’ screen by clicking on the transaction line and then clicking on the delete icon.

如果資料已經存在RCV_Transactions , 代表資料重複了，所以可以從Pending receiving 畫面上的Delete鍵直接刪除。

Receiving transactions are processed through RCV_TRANSACTiON_INTERFACE table by submitting the ‘Receiving Transaction Processor’ (short name RVCTP).

== How to reprocess?==

SELECT request_id,
       GROUP_ID,
       processing_request_id,
       validation_flag,
       processing_status_code,
       transaction_status_code,
       processing_mode_code
FROM rcv_transactions_interface
WHERE interface_transaction_id = 27108655;

SELECT header_interface_id,
       GROUP_ID,
       processing_request_id,
       processing_status_code,
       validation_flag
FROM rcv_headers_interface
WHERE GROUP_ID = 5298734;

-- Update script --

UPDATE rcv_transactions_interface
   SET request_id = NULL,
       processing_request_id = NULL,
       validation_flag = 'Y',
       processing_status_code = 'PENDING',
       transaction_status_code = 'PENDING',
       processing_mode_code = 'BATCH'
WHERE interface_transaction_id = 27108655
/* Formatted on 2012/8/28 上午 11:23:55 (QP5 v5.163.1008.3004) */
UPDATE rcv_headers_interface
   SET processing_status_code = 'PENDING',
       processing_request_id = NULL,
       validation_flag = 'Y'
WHERE GROUP_ID = 5298734;

commit;