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***
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:
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:
src_doc_type REQ, curr_code USD, currency_conv_type 1000, curr_date
[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
declare begin fnd_message.set_name(:1,:2); end;
END OF STMT
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
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.
. 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms