Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Procurement - EBS (MOSC)

Is it possible to null out the req_distribution_id value in PO_DISTRIBUTIONS_ALL table

Feb 2, 2015 4:06AM edited Feb 10, 2015 10:08AM in Procurement - EBS (MOSC) 3 commentsAnswered

Hi,

Issue:

User have loaded the PO interface tables using some custom program where req_distribution_id is passed.

Then using PDOI base tables are populated. Where the same req_distribution_id is populated into PO_DISTRIBUTIONS_ALL table.

But the req_distribution_id populated is wrong, which is causing the issue that PO cannot be found from iProcurement to receive.

But removing the req_distribution_ID from PO_DISTRIBUTIONS_ALL table, will resolve the issue.

Now the question is whether it is feasible to null out this field? Is yes, does it have any other impact?

What is the best way to do this?

Tagged:

EBS_PROC_Purchasing

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month