R12_AP: Payables Open Interface Import Ends With Error REP-0069 and REP-57054 - Bug 25314596 - Rejected Invoice Line Number With More Than 10 Digits Causing No Output (Doc ID 2221339.1)

Last updated on JANUARY 16, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Open Interface and Inv Import

Payables Open Interface Import (APXIIMPT) finishes in error status. REP-0069 and REP-57054 errors displayed

It ends with error in specific cases when line number is longer than 10 chars e.g. 123456789876.

Log file shows error:

REP-2103: Column 'C_line_level' : PL/SQL formula returned invalid value or no value.
MSG-00883: After Repport Trigger: Setting the Org Context to Multiple
MSG-00003: (After report 3) Delete record in ap_interface_controls
MSG-00004: (After Report Trigger 4) Commit.
MSG-00005: (After Report Trigger 5) After SRWEXIT
REP-0069: Internal error
In-process job terminated:Terminated with error:
REP-2103: MSG-00001: (Before Report) After SRWINIT

This error happens in case when there is a rejection.
For testing I used invoice with line number greater then 10 chars and with some invalid PO header id and PO number to achieve rejection.


ERROR
-----------------------
REP-0069 and REP-57054


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. With Payables responsibility, navigate to Other->Concurrent
2. Run the Payables Open Interface program


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import invoices

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