Supply Chain Management - PSFT (MOSC)

MOSC Banner

PO_RECV_ACCRUAL process fails with unique constraint error:how is CURRENCY_CD_BASE in po_hdr and po_

edited May 19, 2017 5:03AM in Supply Chain Management - PSFT (MOSC) 9 commentsAnswered

Hello Team,

We are having a problem:

The process po_recv_accrual is failing due to unique constraint error.

Let BU  = A and GLBU = B.

A BU currency = INR

B BU Currency = AUD.

Therefore when we have a PO in this combination, sometimes in PO_LINE DISTRIB the Currency CD and Currency CD BASE are populating both INR And INR respectively. But sometimes it is populating As INR and AUD respectively. When this currencies are populated the process recv accrual process is failing with unique constraint error.

So I was trying to understand how this Currency CD Base is getting populated like that differently.

Tagged:

Howdy, Stranger!

Log In

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

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center