Unable To Receive Internal Req / ISO RVTII-060 Interclass Conversion Between USD And IS Not Defined (Doc ID 1442703.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 03-March-2016***

Symptoms

When attempting to receive an Internal Requisition (Req) / Internal Sales Order from one organization to another organization
(for example: organization P01 to organization P16) the following error occurs in Manager P16 (DP_US) custom Responsibility:

RVTII-060: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned
error
Cause: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned
an internal error.
Interclass conversion between USD and is not defined
Use define interclass conversions form to define interclass conversions


When debugging further per <Note 299497.1> the invdebug.log shows:

[20-MAR-12 06:31:35] po.src.rvtp.rvtii.RVTII.C.5697: RVTII:999:
src_doc_type REQ, curr_code USD, currency_conv_type 1000, curr_date
20-03-12 06:31:35
...
[20-MAR-12 06:31:41] INV_TRX_MGR: Currency Code=USDXfr CurrencyCode=
[20-MAR-12 06:31:41] INV_TRX_MGR: sobId=2021Xfr sobId=0
...
[20-MAR-12 06:31:42] INV_TRX_MGR: error expl :Exception in
calculateRate:oracle.jdbc.driver.OracleSQLException: ORA-6510: PL/SQL:
unhandled user-defined exception
ORA-6512: at "APPS.GL_CURRENCY_API", line 58
ORA-1403: no data found
ORA-6512: at "APPS.GL_CURRENCY_API", line 925
ORA-6512: at "APPS.GL_CURRENCY_API", line 1044
ORA-6512: at line 1
[20-MAR-12 06:31:42] INV_TRX_MGR: TrxUtil: stacked message - Interclass
conversion between USD and is not defined
Use Define Interclass Conversions form to define interclass conversions


The raw trace shows:


SELECT DECODE( DERIVE_TYPE, 'EURO', 'EURO', 'EMU', DECODE( SIGN( TRUNC(:B2 ) - TRUNC(DERIVE_EFFECTIVE)), -1, 'OTHER', 'EMU'), 'OTHER' ), DECODE( DERIVE_TYPE, 'EURO', 1, 'EMU', DERIVE_FACTOR, 'OTHER', -1 ), NVL( MINIMUM_ACCOUNTABLE_UNIT, POWER( 10, (-1 * PRECISION))) FROM FND_CURRENCIES WHERE CURRENCY_CODE = :B1
END OF STMT
PARSE #69:c=0,e=479,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,plh=0,tim=1053010257501
BINDS #69:
Bind#0
value="3/20/2012 6:30:12"
Bind#1

declare begin fnd_message.set_name(:1,:2); end;
END OF STMT
PARSE #70:c=0,e=1126,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=1053010471927
BINDS #70:
Bind#0
value="INV"
Bind#1
value="INV_INVALID_INTERCLASS_CONV


Steps
The issue can be reproduced at will with the following steps:
1. From the Responsibility Manager P16 (DP_US)
2. Navigate to Inventory > Transactions > Receipt
3. Query the requisition
4. Choose the Find button
5. Mark the box next to the line
6. Assign a Sub-inventory and Locator
7. Save

What has been checked
. This is NOT an intercompany Internal Requisition, the sending and destination organization belong to the same Operating unit and have same set of books and functional currency.  In the org_organization_definitions table they have the same OPERATING_UNIT and same SET_OF_BOOKS_ID.  So this is not an issue of missing currency conversions between different currencies.

. This is NOT a Unit of Measure (UOM) conversions issue as the UOM and primary UOM are the same;
UNIT_OF_MEASURE and PRIMARY_UNIT_OF_MEASURE are EACH in the Rcv_Transactions_Interface table.

. Profile INV: Inter-Organization Currency Conversion is set at the site level.
(<Note 782714.1>)

. When receiving the same Internal Requisition in the PO Super User (DP_US) Responsibility RVCTP completes successfully!

. Following <Note 397362.1> Multi Org Access Control (MOAC) in Oracle Purchasing
the following profile options have been checked:
MO: Security Profile 
MO: Default Operating Unit
MO: Operating Unit
In both responsibilities they have the same values.

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