You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PO Receiving via VB template - one error should fail the full receipt

Summary:

Hi,

We are receiving against a PO via Oracle supplied VB template.

This first loads the receipt and receipt lines into the RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE tables and then the ESS job 'Manage Receiving Transactions' validates and processes the rows into Oracle.

Issue:

Assume there is 1 receipt header and 3 receipt lines. If one of the receipt lines has an error in the Manage Receive Transactions (say, quantity to be received takes it over the over-receipt tolerance with 'Reject' option turned on), the receipt still gets created with the 2 successful lines.

Question:

Is there a way to error out the creation of the receipt header unless all lines pass validation?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!