My Oracle Support Banner

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 DECEMBER 03, 2019

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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