Receiving Transaction Processor Completing In Error "Exception occurred in generate_rcv_tax: lv_process_message = Exception occurred in copy_adjust_taxes_from_oi, lv_process_message: ORA-01403: no data found" While Inspect/Deliver for Unordered Receipts (Doc ID 2830399.1)

Last updated on DECEMBER 24, 2021

Applies to:

Symptoms

PROBLEM STATEMENT

When attempting to inspect/deliver the unordered receipt
the following error occurs.

ERROR
-----------------------
Exception occurred in generate_rcv_tax: lv_process_message = Exception occurred in copy_adjust_taxes_from_oi, lv_process_message: ORA-01403: no data found


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
a) Create a Purchase Order with taxes ((N)> Oracle Purchasing > Purchase Orders)
b) (N)> Oracle Purchasing > Receipts > Unordered > Provide the Supplier in Header
c) In lines provide the item,Quantity,UOM(Unit Of Measure),Location ,Destination type as Receiving
d) Tools > India Tax details > Provide the Assessable value
e) Input the taxes
f) Save the same . No issue observed
g) Receiving > Match unordered receipts
h) Provide the Receipt number and click on find
i) Provide the PO Number and Save
k) Receiving Transactions and find the receipt number and Deliver the same
l) RTP(Receiving Transaction Processor) completes in error

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.