ROI Errors For ASN Ship Transaction Derive_vendor_rcv_line_qty-098: 1 (Doc ID 1385031.1)

Last updated on MARCH 24, 2017

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

logging 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.
on column INTERFACE_TRANSACTION_ID



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


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms