My Oracle Support Banner

Claim Settlement Fetcher Error "You Have Paid The Same Invoice Twice" Cannot Close Claim (Doc ID 1161383.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Trade Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

Oracle Trade Management Claim Settlement Fetcher concurrent request log shows errors for several Claims which remain in 'Pending Close Status'.

Error

(1) You have paid the same invoice twice. Please correct. An error occurred when applying application on receipt through AR Receipt API.
(2) An error occurred when applying application on receipt through AR Receipt API.

Steps to Reproduce:

Scenario 1: Settle two Deductions on a Receipt with Credit memo On-Account

  • Create an invoice 13387 for 1000 USD and complete it.
  • Create a receipt R-13387-1 for 100 USD and apply invoice 13386 to it, This creates deduction DED21023 for 900 USD.
  • Move to the next line of the receipt, Create a Claim investigation line for -100 USD and save, this creates a Deduction DED21024 for 100 USD
  • Query the deductions, Select Settlement method as Credit Memo On-Account, and approve. Both the claims are moved to Pending Close.
  • Run concurrent request Autoinvoice Master Program from Receivables.
  • Run concurrent request Claims Settlement Fetcher from Trade Management.
  • Receive error in log file

 

Scenario 2:

  • Responsibility: Receivables
    • Receipt #1234 created via Auto Lock Box for 17,281.79 USD.
    • This receipt had multiple Non Invoice Related deductions- claim investigations as.
      • DED17314 FOR 68.36 USD
      • DED17319 FOR 104.60 USD
  • Responsibility: Oracle Trade Management
    • Settle all the above DED's using Credit Memo On Account. They used the same Invoice for Crediting in Claim Lines.
    • These lines are Interfaced to AR throughout the day.
  • Responsibility: Receivables
    • When the Auto Invoice program is run for Trade management source at the end of the day- This created a single credit-10122008154 (Credit memo Number) for -172.96 USD for all the claims.
    • You do not use a grouping rule to split the AR Credit Memo by claim Number.
  • Responsibility: Trade Management Administrator
    • When the Fetcher Program run after the AR Credit is created.
    • It closed the First Claim DED17314 Correctly.
    • The second Claim-DED17319 is stuck in Pending Close & below is message from the fetcher log file.
      • (1) You have paid the same invoice twice. Please correct.
      • (2) An error happened when applying application on receipt through AR Receipt API.
      • To Complicate the matters the sers have created OPM Claim (OPM324970) for -104.60 because the Credit memo created has open balance.

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.