Home » Applications » Oracle Fusion Apps & E-Business Suite » R12 Value set Error
R12 Value set Error [message #408230] Mon, 15 June 2009 07:02 Go to next message
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.
Re: R12 Value set Error [message #408300 is a reply to message #408230] Mon, 15 June 2009 12:03 Go to previous messageGo to next message
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
Re: R12 Value set Error [message #408374 is a reply to message #408300] Tue, 16 June 2009 00:06 Go to previous messageGo to next message
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??
Re: R12 Value set Error [message #408485 is a reply to message #408374] Tue, 16 June 2009 07:11 Go to previous messageGo to next message
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
Re: R12 Value set Error [message #408502 is a reply to message #408485] Tue, 16 June 2009 07:54 Go to previous message
Nshan
Messages: 62
Registered: February 2009
Member
K thanks a lot...
Previous Topic: AP_FINAP_NOT_DEFINED
Next Topic: PM Scheduling in Enterprise Asset Management using API
Goto Forum:
  


Current Time: Tue Dec 24 07:51:25 CST 2024