My Oracle Support Banner

FSG: ORA-01008 Error During Column Set Account Assignments (Doc ID 1303425.1)

Last updated on AUGUST 19, 2019

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

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


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


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