The Invoice Register (APXINRIR) errors with MSG-00011: P_flexdata = GC.SEGMENT1

(Doc ID 2282298.1)

Last updated on JANUARY 10, 2018

Applies to:

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


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

the log files shows error
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-00010: P_invoice_amount = decode(inv.cancelled_date, null, inv.invoice_amount, inv.cancelled_amount)
MSG-00011: P_flexdata = GC.SEGMENT1||'
MSG-00012: P_flexdata1 = GC2.SEGMENT1||'
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


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