11i - Error APP-FND-00806 When Submitting PRC: Submit Interface Streamline Process (Doc ID 1518825.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Costing - Version 11.5.10.2 and later
Information in this document applies to any platform.
*** Checked for relevance 17-Oct-2014 ***

Symptoms

Submitting the PRC: Submit Interface Streamline Processes with Streamline Option: DXU: Distribute/Interface Usage and Misc. Costs to GL from the primary book responsibility (CN_SVCS_CNY), the user encoutners:

APP-FND-00806: The default value CNY is invalid for the Set of Books Id segment. Your default value will be ignored. Please inform your system administrator that:

Add the value CNY to the value set for segment Set of Books Id, 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.
--------------------------------------------------------------
FLEX-VALUE NOT UNIQUE
--------------------------------------------------------------
APP-FND-01564: ORACLE error 1422 in FDFGVD

Cause: FDFGVD failed due to ORA-01422: exact fetch returns more than requested number of rows.

The SQL statement being executed at the time of the error was: SELECT SET_OF_BOOKS_ID,CURRENCY VALUE, SET_OF_BOOKS_NAME DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y'), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), SET_OF_BOOKS_TYPE "Set Of Books Type" FROM PA_GL_SET_OF_BOOKS_V WHERE ( (:b1 IN ('CCBL-CCGLB-EZC-CCTI', 'CCGL-EZC-CCTI', 'DBC-TFB-EZB-TBB', 'LAB-LGL-EZL-GLL', 'LGL-EZL-GLL', 'RGL-EZLR-GLR', 'TFB-EZB-TBB', 'UGL-EZU-GLU', 'USG-UGL-EZU-GLU')) OR (SET_OF_BOOKS_TYPE_CODE = 'P') ) AND CURRENCY = :X and was executed from the file &ERRFILE.

The The Set of Books Currency LOV shows for CNY%:

CN_SVCS_CNY
CN_SVCS_CNY_MRC

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