Home » Applications » Oracle Fusion Apps & E-Business Suite » PO and REQUITION Approval
PO and REQUITION Approval [message #211042] Mon, 25 December 2006 15:46 Go to next message
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 #211154 is a reply to message #211042] Tue, 26 December 2006 21:50 Go to previous messageGo to next message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

Hi Arjun,

For the above mentioned error because of the catogory code which was assigned to that particular item is inactive(end date is given) make as active and do the procurement process. or check for the item all item attributes

Regards,
B.T.S.Ananth

Re: PO and REQUITION Approval [message #211191 is a reply to message #211042] Wed, 27 December 2006 02:10 Go to previous messageGo to next message
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 #211224 is a reply to message #211191] Wed, 27 December 2006 06:27 Go to previous messageGo to next message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

give me the po number in solutionbeacon
i'll try to find the solution
Re: PO and REQUITION Approval [message #211262 is a reply to message #211224] Wed, 27 December 2006 11:59 Go to previous message
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.
Previous Topic: AR Questions/Answers
Next Topic: Switch to APPS
Goto Forum:
  


Current Time: Wed Dec 07 03:12:16 CST 2016

Total time taken to generate the page: 0.15593 seconds