Shulou(Shulou.com)06/01 Report--

Look at Transaction status summary.

If you find a receipt unit account at the time of receipt, but cannot find it when printing, you can first confirm that there is no receipt in receiveing transaction summary. It is best to confirm that there is no receipt in the list, and then check it in transaction status summary. If the previous receipt is confirmed that there is no receipt, it is found in transaction status summary that the record is deleted in transaction status summary, and then you will get a new receipt (original receipt receipt account).

If Receiving Transaction has any common symptoms in the processing process, it will import the data.

In RCV_TRANSACTIONS_INTERFACE table and shown in Transaction Status Summary Form

The conditions are as follows:

(a). The reason for Status = 'PENDING': is unknown. It may be that the system is busy during the collection transaction, and this part of Oracle is unable to propose a clear Problem Define. When it occurs, you can first confirm whether this data has been successfully executed (until Receiving Transaction Summary queries whether its transaction is successful). If so, please handle it in the following ways:

01. Modify the processing mode under SQL:

EX:update rcv_transactions_interface

Set PROCESSING_MODE_CODE = 'BATCH'

Where PROCESSING_MODE_CODE = 'IMMEDIATE'

And PROCESSING_STATUS_CODE = 'PENDING'

02. Run Receiving Transaction Processor program (Report Run) in the PO module

(B). Status = 'ERROR': check error code, and processed according to Error Code-- > whether it has been done

Deliver-- > whether there is an increase in on-hand qty

-- > if not, you can use this subscription Recorde to Delete on Transaction Status Summary Form, and then do the subscription transaction again. -- > if the database data has been completed successfully, EX: Transaction type = Delivery, query Receiving Transaction Summary, query data has been completed, and the collection data is also loaded on PO Shipment (the number of inbound data should be checked on PO Distribution), and the query Material Transaction in Inventory also has this data, which means that the database data is successful, so you only need to Delete on the Transaction Status Summary Form (the cause of this part is unknown, but the occurrence rate is high).

In general, when you encounter such an event, you must first confirm that the data stuck in the RCV_TRANSACTIONS_INTERFACE is really stuck (whether the data has been processed).

If it is done, you only need Delete subscription data

If not, you need update PROCESSING_MODE_CODE = 'BATCH' and PROCESSING_STATUS_CODE =' PENDING', and then run the program: Receiving Transaction Processor [@ more@] thank you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.