Receiving Transaction Processor Error: derive_vendor_rcv_line_qty-098: 1 Cause: A SQL error has occurred in derive_vendor_rcv_line_qty. (Doc ID 2461186.1)

Last updated on MARCH 04, 2024

Applies to:

Symptoms

Problem Statement
Receiving Transaction Processor completed with below error.

Error
po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.5689: Match Option:RProfile value ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE:N
po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.5715: No of Distributions:1:: Rate and Rate_date in po distributions###.##::DD-MON-YY
po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.5779: Exception 1 ::User-Defined Exception:: occurred while deriving the rate for currency_conversion_date : DD-MON-YY for the rate type : XXXX
po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.5781: The rate returned is :
po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.6013: Exception in derive_vendor_rcv_line_qty
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.74: 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
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.39: error stack from call to po_interface_call

Steps to Reproduce

1. Run Receiving Transaction Processor

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.