Monday, December 03, 2007

Receiving transaction status Pending

When receiving goods in Oracle Inventory INV the lines will be stored in the RCV_TRANSACTIONS_INTERFACE table so a concurrent process can act upon the data in the table and make the needed changes to for example the current availability. In some cases it might happen that the transaction status stays on “Pending” when the Processing Mode is “Immediate”.

In those cases you can “forward” those records by doing the following steps:

Update rcv_transactions_interface rti
set processing_mode_code ='BATCH' ,
processing_status_code = 'PENDING' ,
transaction_status_code = 'PENDING',
processing_request_id = NULL,
validation_flag = NULL
where rti.interface_transaction_id in (17583, 17584);

After you committed this update statement you have to run the “Receiving Transaction Processor” concurrent request. The reason for the lines to be stuck can be for example that rvctp was not invoked because the concurrent manager was down.


Anonymous said...

How I can solve following problem : in Transaction Statuse Window I have transaction that has Processing Mode Batch and Transaction Status Pending? After this transaction, I have many transaction in same status.


Anonymous said...

thanks it solved my problem, u are great

Anonymous said...

thanks. it solved my problem u are simply great