Error In The Purchase Plan Creation - ORA-01400: LINE_NUMBER
(Doc ID 2332646.1)
Last updated on FEBRUARY 14, 2019
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document