My Oracle Support Banner

Projects G-Invoicing ECC Data Load and Other Projects ECC Related Programs are Missing Program Parameter List of Values (LOV), the Lookup Value Sets Are Missing (Doc ID 2918666.1)

Last updated on DECEMBER 30, 2022

Applies to:

Oracle Project Billing - Version 12.2.8 and later
Oracle Project Costing - Version 12.2.8 and later
Oracle Applications Framework - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

When trying to submit the 'Projects G-Invoicing ECC Data Load' the following value sets are missing their Lookups.

The Enterprise Command Center (ECC) related programs are missing program parameter List of Values (LOV), the lookup value sets are missing.
'Projects G-Invoicing ECC Data Load'
'Projects Costing Budgetary Control ECC Data Load'
'Projects Costing and Billing ECC Data Load'

Submitting any of the ECC related programs results in the form error: 'APP-FND-00806: The default value ERROR is invalid for the p_log_level segment. Your default value will be ignored.'

Click on Details... of the error to see the following detailed error message:

APP-FND-00806: The default value ERROR is invalid for the p_log_level segment. Your default value will be ignored. Please inform your system administrator that:

Add the value ERROR to the value set for segment p_log_level, 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.
--------------------------------------------------------------
Value ERROR for the flexfield segment Log Level does not exist in the value set ECC_LOG_LEVEL.

After clicking on OK and attempting to enter a value in either of the following program parameters results in the form error: No entries found for List of Values

Load Type, Log Level, SQL Trace

Click on Details... of the error to see the following detailed error message:

No entries found for List of Values
--------------------------------------------------------------
APP-FND-01436: List of Values cannot find any values for you to choose

Cause: The List of Values execution failed to find any values.

Cause: The SQL statement specified to fdlfch() failed to return any values.

Action: Check the message stack for any SQL statement failure messages. Check to make sure your SQL statement works in SQL*Plus. (ROUTINE=fdlfch)
--------------------------------------------------------------
No entries found for List of Values


The following Lookups are missing the values sets

Missing Lookup Value Sets
Parameters Lookups Value Set
Load Type ECC_LOAD_TYPE_LKUP ECC_LOAD_TYPE
Log Level ECC_LOG_LEVEL ECC_LOG_LEVEL
SQL Trace ECC_TRACE_LKP ECC_TRACE_VALUE_SET

The following query also returns 0 rows:

Steps to Reproduce
----------------------

  1. Log into a Projects responsibility
  2. Navigate to Other > Requests > Run
  3. Submit 'Projects G-Invoicing ECC Data Load'
  4. Encounter form error APP-FND-00806
  5. Click OK
  6. Enter value in parameter 'Load Type'
  7. Encounter form error 'No entries found for List of Values'

Changes

Installed the ECC Foundation patches

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.