Receiving Transactions Register Error With ORA-01722 When Entering Receipt Number (Doc ID 2200475.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Inventory Management - Version 12.2 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Receiving Functions

When attempting to run Receiving Transaction Register
the following error occurs.

ERROR
-----------------------
RCVTXRTR: Receiving Transactions Register
+---------------------------------------------------------------------------+

Current system time is 12-SEP-2016 07:21:22

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
P_org_id='340'
P_trx_date_from='2016/09/11 00:00:00'
P_trx_date_to='2016/09/13 00:00:00'
P_receipt_num_from='1207200311583'
P_receipt_num_to='1207200311583'
P_STRUCT_NUM='201'
P_detail_summary='Y'
P_inc_lot_and_serial='N'
------------

 APPLLCSP Environment Variable set to :

 Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8

'.,'

Enter Password:
MSG-01003: The from ship No is
MSG-01004: The To ship Num is
ORA-01722: invalid number
'||MSL.SEGMENT4 C_FLEX_LOCATOR , MTR . REASON_NAME TX_REASON , RSL . ITEM_ID LS_ITEM_ID , RCT . TRANSACTION_ID LS_TRANSACTION_ID , RCT . SHIPMENT_LINE_ID LS_SHIPMENT_LINE_ID , RCT . ORGANIZATION_ID LS_ORGANIZATION_ID , WLPN1 . LICENSE_PLATE_NUMBER LI
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: MSG-01003: The from ship No is
MSG-01004: The To ship Num is
ORA-01722: invalid number
'||MSL.SEGMENT4 C_FLEX_LOCATOR , MTR . REASON_NAME TX_REASON , RSL . ITEM_ID LS_ITEM_ID , RCT . TRANSACTION_ID LS_TRANSACTION_ID , RCT . SHIPMENT_LINE_ID LS_SHIPMENT_LINE_ID , RCT . ORGANIZATION_ID LS_ORGANIZATION_ID , WLPN1 . LICENSE_PLATE_NUMBER LI


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run Receiving Transaction Register.

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