OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » R12 Value set Error

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

R12 Value set Error [message #408230]

Mon, 15 June 2009 07:02

Nshan
Messages: 62
Registered: February 2009

Member

Hi..

I am using Oracle apps R12...
When i am trying to submit my concurrent program its is asking for parameter which i mentioned in the program. It s using standard value set called "JEIL_SRS_AP_YEAR".
While running my CC program its asking parameter value.
When i tried to enter 2009 its throwing following error.

APP-FND-01564: ORACLE error 1422 in FDFGVD

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

Any answers on this will be helpful.
Thanks in advance.

Report message to a moderator

Re: R12 Value set Error [message #408300 is a reply to message #408230]

Mon, 15 June 2009 12:03

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Even though JEIL_SRS_AP_YEAR is a seeded value set, I don't see any seeded concurrent program is using this value set.
Also by looking at the value set definition, it looks like a bug.
As it is just getting the values from gl_period_statuses where application_id = 200, there may be multiple rows for same period_year.

You may log a bug against Oracle.

By
Vamsi

Report message to a moderator

Re: R12 Value set Error [message #408374 is a reply to message #408300]

Tue, 16 June 2009 00:06

Nshan
Messages: 62
Registered: February 2009

Member

Hi..
For my purpose i have restricted rownum<2;
I am not supposed to do like that right??
Any idea??

Report message to a moderator

Re: R12 Value set Error [message #408485 is a reply to message #408374]

Tue, 16 June 2009 07:11

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

No, you shouldn't.
If you put rownum filter the entire query will give only one year.
You can't enter any other period than that one.

Either you log a bug on Oracle and correct the value set or search for another value set, which suits to your requirement.

I don't have any other value set in my mind.
I think it is better to pass the year directly rather attaching an lov to that field.

By
Vamsi

Report message to a moderator

Re: R12 Value set Error [message #408502 is a reply to message #408485]

Tue, 16 June 2009 07:54

Nshan
Messages: 62
Registered: February 2009

Member

K thanks a lot...

Report message to a moderator

Previous Topic:	AP_FINAP_NOT_DEFINED
Next Topic:	PM Scheduling in Enterprise Asset Management using API

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 23 15:02:03 CDT 2024