ROI Errors For ASN Ship Transaction Derive_vendor_rcv_line_qty-098: 1
(Doc ID 1385031.1)
Last updated on JANUARY 29, 2025
Applies to:
Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]Oracle Landed Cost Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Executable:RVCTP - Receiving Transaction Processor
Symptoms
When attempting to create ASN via ROI for document in foreign currency
the following error occurs:
Error
Steps
The issue can be reproduced at will with the following steps:
1. Load data in RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE tables for a Purchase Order in foreign currency.
RCV_TRANSACTIONS_INTERFACE:
TRANSACTION_TYPE SHIP
PROCESSING_MODE_CODE BATCH
AUTO_TRANSACT_CODE SHIP
2. Run Receiving Transaction Processor.
3. See in PO_INTERFACE_ERRORS table a record with
Column_Name INTERFACE_TRANSACTION_ID
Error_Message Error: derive_vendor_rcv_line_qty-098: 1 Cause: A SQL error has occurred in derive_vendor_rcv_line_qty. The SQL error is User-Defined Exception. Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.
Error_Message_Name PO_ALL_SQL_ERROR
Table_Name RCV_TRANSACTIONS_INTERFACE
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 |