Home » Applications » Oracle Fusion Apps & E-Business Suite » Error In Report: Unknown structure ID 0 for flexfield code GL# with application ID 101
Error In Report: Unknown structure ID 0 for flexfield code GL# with application ID 101 [message #523838] Tue, 20 September 2011 09:36 Go to next message
goparaju
Messages: 54
Registered: June 2011
Member
Hi Experts,

I am working on Report builder 6i, EBS 11i, and data base 9i. I have standard report, when i am running it, it's giving below error.

ERROR: APP-FND-01016: Routine FDFRKS: Unknown structure ID 0 for flexfield code GL# with application ID 101.

It's calling below thing in Before Report Trigger.

begin
SRW.USER_EXIT('FND FLEXSQL CODE="GL#" NUM=":P_ACCT_STRUCT_NUM"
APPL_SHORT_NAME="SQLGL" OUTPUT="P_acct_flex"
MODE="SELECT" DISPLAY="ALL" TABLEALIAS="GCC"');
exception when srw.user_exit_failure then
srw.message(3,'Failed in GL#/Select');
raise;
end;

Could somebody help me what could be the reason for this error.

Thanks.
Re: Error In Report: Unknown structure ID 0 for flexfield code GL# with application ID 101 [message #524222 is a reply to message #523838] Thu, 22 September 2011 04:52 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
What is the value you are passing to the variable P_ACCT_STRUCT_NUM?
If it is 0 (zero), I don't think it is a valid Chart of Accounts ID.
Valid ones are available at
SELECT * FROM fnd_id_flex_structures
WHERE application_id = 101
AND id_flex_code = 'GL#';
By
Vamsi
Previous Topic: Application Security
Next Topic: Error in Form Personalization
Goto Forum:
  


Current Time: Thu Mar 28 05:58:59 CDT 2024