PDOI - Import Standard Purchase Order Program or Import Price Catalog Failed Fdpsql Cannot Read the File

(Doc ID 1632117.1)

Last updated on OCTOBER 23, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

How to resolve POXPOPDOI failed with error message is "Routine fdpsql cannot read the file /u16/oracle/OEDSBX2/apps/apps_st/appl/po/12.0.0/sql/PO_PDOI_GRP.start_process."

Also seeing the following error:

APP-FND-00806: The default value SELECT MEANING FROM
FND_LOOKUPS WHERE LOOKUP_TYPE='YES_NO' AND LOOKUP_CODE ='N'
is invalid for the p_clm_flag segment. Your default value
will be ignored. Please inform your system administrator
that:

Add the value SELECT MEANING FROM FND_LOOKUPS WHERE
LOOKUP_TYPE='YES_NO' AND LOOKUP_CODE ='N' to the value set
for segment p_clm_flag, or choose another default value in
the Key Flexfield Segments form or Descriptive Flexfield
Segments form. Use the Edit Concurrent Program or Define
Report Set form for Standard Report Submission report
defaults.

Solution

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