OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Error In Report: Unknown structure ID 0 for flexfield code GL# with application ID 101

Home » Applications » Oracle Fusion Apps & E-Business Suite » Error In Report: Unknown structure ID 0 for flexfield code GL# with application ID 101

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error In Report: Unknown structure ID 0 for flexfield code GL# with application ID 101 [message #523838]

Tue, 20 September 2011 09:36

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.

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Application Security
Next Topic:	Error in Form Personalization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 14:03:39 CST 2024