FSG: ORA-01008 Error During Column Set Account Assignments
(Doc ID 1303425.1)
Last updated on JULY 07, 2020
Applies to:
Oracle General Ledger - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]Information in this document applies to any platform.
Program: RGRARG - Financial Statement Generator (FSG)
Symptoms
This error occurs in an 11.5.10.2 version environment.STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into general ledger responsibility
2. Navigate to Report-Define-Columnset
3. Select Account Assignment
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into general ledger responsibility
2. Navigate to Report-Define-Columnset
3. Select Account Assignment
When attempting to add assignments for a column set the following error occurs.
ERROR
-----------------------
SELECT/*
$Header: fdfrfu.lc 115.29 2006/09/27 20:17:22 golgun ship $ */
FLEX_VALUE_SET_ID FROM FND_FLEX_VALUESSETS WHERE FLEX_VALUE_SET_NAME = :vsname and was executed from the file &ERRFILE
The flexfield was recompiled and the following new error occurs.
APP-FND-01564: ORACLE error 1008 in FDFGVD
Cause: FDFGVD failed due to ORA-01008: not all variables bound
The SQL statement being executed at the time of the error was : SELECT
Select FND_FLEX_VALUES_VL.FLEX_VALUE,FND_FLEX_VALUES_VL.FLEX_VALUE VALUE, FND_FLEX_VALUES_VL.DESCRIPTION DESCRIPTION, etc......
APP-FND-01388: Cannot read value for profile option FND_INDICATOR_COLORS in routine &ROUTINE
Previous error was in FDFSTS, error after recompile is in FDFGVD
-----------------------
SELECT/*
$Header: fdfrfu.lc 115.29 2006/09/27 20:17:22 golgun ship $ */
FLEX_VALUE_SET_ID FROM FND_FLEX_VALUESSETS WHERE FLEX_VALUE_SET_NAME = :vsname and was executed from the file &ERRFILE
The flexfield was recompiled and the following new error occurs.
APP-FND-01564: ORACLE error 1008 in FDFGVD
Cause: FDFGVD failed due to ORA-01008: not all variables bound
The SQL statement being executed at the time of the error was : SELECT
Select FND_FLEX_VALUES_VL.FLEX_VALUE,FND_FLEX_VALUES_VL.FLEX_VALUE VALUE, FND_FLEX_VALUES_VL.DESCRIPTION DESCRIPTION, etc......
APP-FND-01388: Cannot read value for profile option FND_INDICATOR_COLORS in routine &ROUTINE
Previous error was in FDFSTS, error after recompile is in FDFGVD
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 |
| Cause |
| Solution |
| Still Have Questions? |
| References |