My Oracle Support Banner

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
Gives error


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.