Cannot use the same PO number as a Purged PO ....

ynandi Jul 29, 2010 3:23 AM

Hello:

The users want to use the same PO number as a PO that has been cancelled and purged from the system.

But when they enter the PO number, it gives them an error that the PO number must be unique.

What is the reason for this functionality ?

Yesh

1. Re: Cannot use the same PO number as a Purged PO ....

Hussein Sawwan-Oracle Jul 29, 2010 3:35 AM (in response to ynandi)

Hi,

Please mention the application release along with the complete error message you get.

Also, please post the steps you follow to reproduce the issue.

Thanks,
Hussein
Like Show 0 Likes(0)

Actions
2. Re: Cannot use the same PO number as a Purged PO ....

SachinAhuja Jul 29, 2010 5:57 AM (in response to ynandi)

Also can you check in Purchasing Archive Table if PO number for that OU is there & as being asked Steps you are following when you are getting the error.
Like Show 0 Likes(0)

Actions
3. Re: Cannot use the same PO number as a Purged PO ....

ynandi Jul 30, 2010 12:32 AM (in response to SachinAhuja)

Hello:

We are on Release 12.0.6 using Buyer Work Center.

When I purge a PO it removes all the records from PO_HEADER, PO_LINES, etc and puts it in a PO_HISTORY_POS_ALL table .....I do not see the PO in the PO_HEADER_ARCHIVE tables.

The question is that once a PO is purged, why can't I go and use the purged PO number for another new PO..... since the user is using manual PO numbering scheme, they want to control the PO numbers and they feel that a purged PO number should be available to them for new PO.

Yesh
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.