My Oracle Support Banner

R12 Generic Data Fix (GDF) Payment Accounting Failing Due to AWT Distributions Created by Prepayment Application (Doc ID 1264239.1)

Last updated on MAY 16, 2024

Applies to:

Oracle Payables - Version 12.2.11 to 12.2.11 [Release 12.2]
Oracle Payables - Version 12.2.9 to 12.2.9 [Release 12.2]
Oracle Payables - Version 12.2.10 to 12.2.10 [Release 12.2]
Oracle Payables - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting account for payment transaction with AWT, and prepayment applied, the following error occurs:

0 This line cannot be accounted until the accounting event for the application Payables that it references has been fully accounted.


The issue can be reproduced with the following steps:

  1. Created withholding(WHT) tax, then create tax group.
  2. Complete the payment options setup and supplier setup (Payment time WHT setup).
    1. Steps
      Payables responsibility -> Setup->Payables Option->withholding tax->Apply Withholding tax ->Choose Payment time.
      Payables responsibility -> Suppliers-> Query the supplier ->assign the withholding tax to the supplier.
  3. Create prepayment invoice.
    1. Create the prepayment invoice.
    2. Validate and account the invoice.
    3. Pay the prepayment invoice. The withholding should get applied.
    4. Account the payment.
  4. Create the standard invoice and apply the prepayment.
    1. Create the standard invoice.
    2. Apply prepayment.
    3. Validate and account the invoice.
    4. Pay the invoice.
  5. Run Create Accounting for the payment and the output will show the above error message.
  6. Make payment for the standard invoice and account the payment, payment accounting fails.

Changes

 

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
Changes
Cause
Solution
 DATA-FIX
 CODE-FIX
References

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