Financial Management - PSFT (MOSC)

MOSC Banner

AR_PAYLOAD failing due to unique constraint error

edited Jul 17, 2020 5:06AM in Financial Management - PSFT (MOSC) 1 commentAnswered

Hi All, I am facing this issue . Please let me know if any of you have faced this issue ?

  1. Load a EDI file having multiple Payments.
  2. Some Payments have item references , and all the payments have customer references.
  3. For one payment add manually item references . Payment is Applied.
  4. But other payments where payment/customer references were not there has payment/item references with no values.
  5. Load remittances only for a payment.
  6. Run Process Payment interface with Payment ID and Amount matching.
  7. AR_PAYLOAD process goes to NoSuccess with unique constraint error.

PeopleTools 8.55.25 - Application Engine Server

Copyright (c) 1988-2020 Oracle and/or its affiliates.

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