R12: Invoice Register (APXINRIR): P_DYNAMIC_BATCH_ORDERBY error message displayed (Doc ID 1149018.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

OA release 12:
When attempting to run Invoice Register (APXINRIR), the following error occurs.

ERROR
-----------------------
REP-0300: ORACLE error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: MSG-00001: After SRWINIT
MSG-00001: i am here 21
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 = bat.batch_id
MSG-00010: P_invoice_amount = decode(inv.cancelled_date, null, inv.invoice_amount,
...
Program exited with status 1

Steps to reproduce
---------------------
The issue can be reproduced at will with the following steps:
   1. From a Payables responsibility
   2. Run the Invoice Register 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