Interface Trip Stop Failed Inventory Interface Which Contained Inter-company Orders Due to Error INV_TXN_MANAGER_PUB: SQL error ORA-01403: no data found
Last updated on MARCH 05, 2018
Applies to:Oracle Advanced Pricing - Version 12.1 and later
Oracle Inventory Management - Version 12.1.1 and later
Information in this document applies to any platform.
INCIAR - Intercompany Invoice
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
When attempting to run the inventory interface the following error occurs.
INV_TXN_MANAGER_PUB: *** SQL error ORA-01403: no data found
Interface Trip Stop Log file may also show error:
INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: EXCEP UNEXP OTHERS - ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Shipping > Interfaces > Run
3. Select Name = Inventory Interface SRS
4, Select the appropriate trip stop
5. Click OK
6. Submit request.
7. Review the concurrent request log file.
1. Set the following profile options:
INV: Debug Trace = Yes
INV:Debug Level = 11
INV: Debug File = One of the rwx directories using the following SQL with filename at end like trx_mgr.log
select value from v$parameter where name = 'utl_file_dir';
OM: Debug Level = 5
OM: Debug Log Directory = set to appropriate directory per <Note 1334948.1>
2. Run the Inventory interface for the order line with this issue.
Responsibility: Order Management Super User (or equivalent)
Navigate to: Shipping > Interfaces > Run
Select Name = Inventory Interface SRS
Select the appropriate trip stop
Once completed, View Output to review the log file.
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