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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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: Thu Dec 08 08:50:58 CST 2016

Total time taken to generate the page: 0.10323 seconds