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
Last updated on JANUARY 16, 2017
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
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.
REP-0069 and REP-57054
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
The issue has the following business impact:
Due to this issue, users cannot import invoices
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