Last updated on AUGUST 07, 2015
Applies to:PeopleSoft Enterprise FIN Billing Argentina - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
When Load Invoices to AP process (BIGNAP01 - SQR) - Path: Billing > Generate Invoices > Non-Consolidated > Load Invoices to AP - ends in error:
"dynamic where: HDR.BUSINESS_UNIT = 'ARBI1' AND HDR.INVOICE >= '0000678499' AND HDR.INVOICE <= '0000678499' AND HDR.CONSOL_INVOICE = ' ' AND HDR.ADD_DTTM >= '01-JAN-0001'
c:\bld\g\n910\ora\n910gxau\sqr\bignap01.sqr: BIGNAP01 - SQL Statement =
SQL Status = 1400, SQL Error = ORA-01400: cannot insert NULL into ("EMDBO"."PS_VCHR_HDR_STG"."AP_VCHR_CAT")
Error on line 71:
(SQR 3301) Program stopped by user request.
SQR for PeopleSoft: Program Aborting.
The issue can be reproduced at will with the following steps:
- Create Bill.
- Enter with Bill information and save.
- Change Status to RDY and save.
- Run Single Action Invoice.
- Run Load Invoice to AP.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms