Error In The Purchase Plan Creation - ORA-01400: LINE_NUMBER

(Doc ID 2332646.1)

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.

Symptoms

On : 12.2.5 version, Endeca Relate Pages

When attempting to he purchase plan creation the following error occurs.

ERROR
-----------------------
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 ;


STEPS
-----------------------
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

Cause

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