R12: AP: The Invoice Register (APXINRIR) Errors With MSG-00011: P_flexdata = GC.SEGMENT1 (Doc ID 2282298.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When attempting to run APXINRIR: Invoice Register, the log file shows following errors.

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 = <BATCH_ID_#)
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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.