Intragovernmental Performance Integration to Payables Program Failed with "The Prepayment Balance Is below the Invoice Value, so It Cannot Be Applied to the Invoice. Review Adjustment, Prepayment Balance and Try" Error (Doc ID 3011298.1)

Last updated on MAY 03, 2024

Applies to:

Symptoms

'Intragovernmental Performance Integration to Payables Program' failed to create records in AP (Payables) Interface Tables and has below error captured in concurrent log file

"The prepayment balance is below the invoice value, so it cannot be applied to the invoice. Review adjustment, prepayment balance and try."

The issue can be reproduced at will with the following steps:

1. Create IGT Order with 1 line and 2 schedules in G-Invoicing
2. Create Advance Performance for both schedules in G-Invoicing
3. Create Delivery Performance for both schedules in G-Invoicing
4. Pull the Advanced Performance and Delivery Performance into EBS (E-Business Suits)
5. Ran 'Intragovernmental Performance Integration to Payables Program' but failed with "The prepayment balance is below the invoice value, so it cannot be applied to the invoice. Review adjustment, prepayment balance and try." error being captured in concurrent log file.

Changes

Issue occur after upgraded source file PO_IGT_PERF_INV_INTG_PKG.plb to version 120.0.12020000.22

Cause

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