Error In The Purchase Plan Creation - ORA-01400: LINE_NUMBER
Last updated on NOVEMBER 27, 2017
Applies to:Oracle Project Procurement - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version, Endeca Relate Pages
When attempting to he purchase plan creation the following error occurs.
An error occurred while processing the uploaded excel sheet. This may have been caused by any of the following errors: 1. Certain required attributes have been left blank. 2. A character value has been entered in a numeric field. Please refer to the instructions in the README file, correct all data in the excel sheet and try again.Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PO"."PO_PROC_PLAN_LINE_INTERFACE"."LINE_NUMBER") ORA-06512: at "APPS.PO_PROC_PLAN_PUB", line 7092 ORA-06512: at line 1 ;
The issue can be reproduced at will with the following steps:
1. From project super user responsibility
2. Search the project, click on project
3. Select Procurement tab. Click on 'Procurement Plan' inner tab.
4. Click on Create Procurement plan button
5. Pick xml file <my file name>.xml
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