OEXOEIOD: Order/Invoice Detail Report ORA-01722:invalid Number

(Doc ID 2169456.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Order Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the Order/Invoice Detail Report (OEXOEIOD) ,
the following error occurs:

ERROR

Enter Password:
ORA-01722: invalid number
 SELECT trx . trx_number Invoice_Number , trx . trx_date Invoice_Date , trxl . line_number Line , l . item_identifier_type , SI.SEGMENT1 item_flex , l . inventory_item_id , l . ordered_item_id , l . ordered_item , trxl . uom_code UOM , DECODE ( NVL
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: invalid number
 SELECT trx . trx_number Invoice_Number , trx . trx_date Invoice_Date , trxl . line_number Line , l . item_identifier_type , SI.SEGMENT1 item_flex , l . inventory_item_id , l . ordered_item_id , l . ordered_item , trxl . uom_code UOM , DECODE ( NVL



STEPS TO REPRODUCE
 
The issue can be reproduced at will with the following steps:
1. Order Management Responsibility
2. Reports, Requests > Run Reports
3. Select 'Order/Invoice Detail Report'
4. Run with the following parameters:
Arguments
------------
P_SOB_ID='1001'
P_ITEM_FLEX_CODE='MSTK'
P_ORDER_BY='CUSTOMER'
P_OPEN_ORDERS_ONLY='Y'
P_PRINT_DESCRIPTION='D'
P_ORDER_NUM_LOW='459029699'
P_ORDER_NUM_HIGH='459029699'
P_INVOICE_LINE_CONTEXT='ORDER ENTRY'
P_ORDER_CATEGORY='SALES'
P_LINE_CATEGORY='SALES'
P_USE_FUNCTIONAL_CURRENCY='Y'



Changes

 

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