PDOI Errors with 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.

(Doc ID 1962269.1)

Last updated on AUGUST 10, 2015

Applies to:

Oracle Purchasing - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to submit the request 'Import Standard Purchase Order' OR 'Import Price Catalogs' the following error occurs.

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 confirm your system administrator that.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Purchasing > View > Request > Import Standard Purchase Orders OR Import Price Catalogs
2. Attempt to submit the report->error occurs

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