OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Closing old purchase orders (Oracle Financials 11.5.10.2, Windows XP)

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

Closing old purchase orders [message #417948]

Wed, 12 August 2009 04:37

dreamkatcha
Messages: 11
Registered: July 2006

Junior Member

Hi,

I'm in the middle of a major house-keeping exercise and therefore have to close down thousands of redundant purchase orders. I've managed to do this automatically using a script for the majority of them, but several hundred unapproved, incomplete or in process ones won't budge for various reasons.

Some of the error messages I've received include...

- Line #1 Shipment #1 Distribution #1 This Accounting Flexfield does not allow detail posting
- Line #1 Shipment #1 Distribution #1 This Accounting Flexfield is disabled or out-of-date
- Error: Line # 1 Shipment # 1 Distribution # 1 The accounting date is not in an open encumbrance period. (when trying to approve and unapproved PO)
- Line #4 Shipment #1 You cannot cancel a fully received purchase order.

Any suggestions as to how to 'finally close' these would be much appreciated, thanks.

[Updated on: Wed, 12 August 2009 04:58]

Report message to a moderator

Re: Closing old purchase orders [message #425575 is a reply to message #417948]

Fri, 09 October 2009 12:56

rklemm
Messages: 9
Registered: October 2009

Junior Member

In process need to be rejected. This will make them, the incomplete and unapproved(?) able to be simply deleted via the delete icon or a SQL.

Report message to a moderator

Re: Closing old purchase orders [message #468061 is a reply to message #425575]

Wed, 28 July 2010 13:52

jdevoresapientcom
Messages: 1
Registered: July 2010

Junior Member

Would you be able to share the script as my group closes large numbers of PO lines and we are currently doing that process manually. I have not been able to figure out a dataloader script or excell macro because "close" is not always the second option (depending on status)

Report message to a moderator

Re: Closing old purchase orders [message #468065 is a reply to message #468061]

Wed, 28 July 2010 14:08

dreamkatcha
Messages: 11
Registered: July 2006

Junior Member

Thanks for the suggestion, rklemm. I never did get to try it out though because I'd already left the company by then. For the same reason I can't share the script unfortunately. I wouldn't know where to start either; the one I was using was put together by one of our IT tech support staff sorry.

Report message to a moderator

Previous Topic:	ERROR CODE:1072896760
Next Topic:	submit concurrent request from oracle report 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 13:45:22 CDT 2025