My Oracle Support Banner

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:

Oracle Financials for India - Version 12.2.7 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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