when run APXINRIR: Invoice Register the log shows error MSG-00011: P_flexdata = GC.SEGMENT1||' (Doc ID 2282298.1)

Last updated on AUGUST 06, 2017

Applies to:

Oracle Payables - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Invoice Issues & MassAdd

When attempting to run APXINRIR: Invoice Register the log shows error
the following error occurs.

ERROR
-----------------------
the log files shows error
MSG-00000: MY REPORT
MSG-00001: After SRWINIT
MSG-00002: After Get_Company_Name
MSG-00003: After Get_NLS_Strings
MSG-00004: After Get_Supplier_Invoice_Info
MSG-00005: After Get_Base_Curr_Data
MSG-00006: After Custom_Init
MSG-00007: After get_flexdata
MSG-00008: After set_p_where
MSG-00009: P_DYNAMIC_BATCH_ORDERBY = NULL
MSG-00010: P_invoice_amount = decode(inv.cancelled_date, null, inv.invoice_amount, inv.cancelled_amount)
MSG-00011: P_flexdata = GC.SEGMENT1||'
'||GC.SEGMENT3||'
'||GC.SEGMENT2||'
'||GC.SEGMENT4||'
'||GC.SEGMENT5||'
'||GC.SEGMENT6
MSG-00012: P_flexdata1 = GC2.SEGMENT1||'
'||GC2.SEGMENT3||'
'||GC2.SEGMENT2||'
'||GC2.SEGMENT4||'
'||GC2.SEGMENT5||'
'||GC2.SEGMENT6
MSG-00013: P_gl_code_combinations2 = gl_code_combinations GC2,
MSG-00014: c_invoice_id_predicate = AND inv.invoice_id = lines.invoice_id(+) AND lines.invoice_id = dist.invoice_id(+) AND lines.line_number = dist.invoice_line_number(+)
MSG-00015: c_batch_predicate = and inv.batch_id = 221067
MSG-00016: c_match_status_predicate =
MSG-00017: c_inv_type_pred =
MSG-00018: c_accounting_date_predicate =
MSG-00019: c_invoice_cancelled_predicate = AND 1 = DECODE('N', 'N', 1, 'Y', DECODE(INV.cancelled_date, NULL, 0, 1))
MSG-00020: c_created_by_predicate =
MSG-00021: c_start_date_predicate =
MSG-00022: c_end_date_predicate =
MSG-00023: c_gl_ccid2_predicate = and GC2.code_combination_id(+) = dist.accts_pay_code_combination_id
MSG-00024: c_orderby_batch_id =
MSG-00025: After pop_param_pholder
MSG-00026: After pop_param_pholder : :SORT_BY_ALTERNATEN
MSG-00027: Before return

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run the report

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot on prod run the report

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