| PO and REQUITION Approval [message #211042] |
Mon, 25 December 2006 15:46  |
Arjunn
Messages: 64
Registered: December 2006
Location: Hyderabad/Gurgaon
|
Member |
|
|
Hi im practising oracle 11i financials thru solutionbeacon
after approving PO, all the PO's are showing the status as incomplete, I hav done all the setups which are required.
When Iam going for the approval of requisition it is giving the error: 'oracle error 1422 in FDFGCD
Cause: FDFGCD failed due to ORA-01422: exact fetch returns more than requisted number of rows'
The SQL statement being executed at the time of the error was: SELECT ENABLED_FLAG, SUMMARY_FLAG, NVL(TO_CHAR(START_DATE_ACTIVE, 'J'), 0),NVL(TO_CHAR(END_DATE_ACTIVE, 'J'), 0),SEGMENT1, CATEGORY_ID FROM MTL_CATEGORIES_VL WHERE STRUCTURE_ID = :num AND SEGMENT1 = :SEGMENT1 AND ( ( NVL(DISABLE_DATE, SYSDATE + 1) > SYSDATE AND category_id in (select category_id from mtl_category_set_valid_cats where category_set_id= :FND_FLEX_WHERE_BIND_0) ) ) and was executed from the file &ERRFILE.
can any one plz help me to over come these error
In advance thanks to all reply's
Regards,
Arjun
[Updated on: Mon, 25 December 2006 21:33] Report message to a moderator |
|
|
|
|
|
| Re: PO and REQUITION Approval [message #211191 is a reply to message #211042] |
Wed, 27 December 2006 02:10  |
Arjunn
Messages: 64
Registered: December 2006
Location: Hyderabad/Gurgaon
|
Member |
|
|
Hi Ananth,
I am unable to find category code, I tried alot but Im still getting the same problem.
my requition is not saving n PO status is Incomplete.
Plz help me out
Regards,
Arjun.
|
|
|
|
|
|
| Re: PO and REQUITION Approval [message #211262 is a reply to message #211224] |
Wed, 27 December 2006 11:59 |
Arjunn
Messages: 64
Registered: December 2006
Location: Hyderabad/Gurgaon
|
Member |
|
|
Hi Ananth,
I have created my own responsibilities in Solutionbeacon, purchasing responsibility name is Pardhu PO in tht PO no. are 1,2,3,4,5,6.
Regards,
Arjun.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
