Financial Management - PSFT (MOSC)

MOSC Banner

ARUPDATE aborted by duplicate key error at AR_PGG_SERV.CC_ROUN3 on 2 scenarios

edited Jan 30, 2013 11:51PM in Financial Management - PSFT (MOSC) 2 commentsAnswered
Summary:

ARUPDATE aborted by the error of "Cannot insert duplicate key row in object 'dbo.PS_PG_PENDST_TAO4' with unique index 'PS_PG_PENDST_TAO4'" at the step AR_PGG_SERV.CC_ROUN3.

This issue will occur on the following conditions;

- All records (items and payments) are entered with foreign currencies.
- This issue can be replicated when exchanged base amounts are different between items and payments.
  (For example, 1 payment base amount is 3 USD and the totals of 3 item amounts are 3 USD.
  But those amounts are exchanged to JPY by the rate 88.45, payment base amount will be 265 JPY, and the totals of 3 item base amounts are 264 JPY.

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