Case 00034752 – AP Invoices Stuck in Selected State After PPR Termination

AP Invoices Stuck in Selected State After PPR Termination

Case Number	00034752
Oracle Module	Accounts Payable (AP) / Oracle Payments (IBY)
EBS Version	R12
Functional Area	Payment Processing / Payment Process Request (PPR)
Related Patches	Oracle GDF ap_Rel_Inv_frm_TermPPR_fix.sql

Symptoms

AP invoices remain in "Selected for Payment" state even though the associated Payment Process Request (PPR) was terminated, failed validation, or completed without generating payments.
Invoices cannot be selected for a new payment run because they appear locked by the old PPR.
Attempts to manually release invoices from the payment batch fail or are not available.
The PPR shows a status of Terminated, Validation Failed, or Completed but the invoice payment status has not been reset.

Root Cause

When a Payment Process Request (PPR) terminates, fails, or completes without fully processing, the associated invoices should be released back to "Available for Payment" status. Due to a timing or processing error, the invoice selection records remain linked to the defunct PPR, preventing re-selection. This fix releases the invoices by clearing their PPR association.

Resolution

This fix uses the Oracle Generic Data Fix (GDF) framework.

Step 1 – Run identification script

Run the companion selection script (ap_Rel_Inv_frm_TermPPR_sel.sql) to identify PPRs in Terminated/Validation_Failed/Completed state whose associated invoices remain in "selected" status.

Step 2 – Execute the fix script

Run data_fix.sql via SQL*Plus. The script prompts for:

DETAILS_FLAG — Y/N to print invoice details in the log
P_User_Name — valid Oracle EBS username (uppercase)
P_Responsibility_Name — Payables responsibility name (case-sensitive)
Email_id — optional email for log delivery

sqlplus <user>/<password>@<database> @data_fix.sql

Step 3 – Script processing

The script:

Verifies the PPR concurrent program is in Completed status.
Creates backup tables for affected payment schedule records.
Clears the PPR assignment from invoice payment schedules, releasing them back to "Available" state.
Handles the case where the PPR was terminated before the Build Payments step was executed.
Commits and writes a log report of released invoices.

Step 4 – Validate

Confirm the affected invoices now show "Available" status in the AP Payment Manager and can be selected for a new payment run.

Note: This GDF handles PPRs that were terminated before or after the Build Payments step. The script checks the concurrent program status and aborts if the PPR is still in progress to prevent data corruption.

Script Inventory

File	Description
data_fix.sql	Oracle GDF script to release AP invoices from a terminated/failed/completed PPR. Clears payment selection status and restores invoices to Available for Payment. Uses AP_Acctg_Data_Fix_PKG framework with logging.

Key Tables Affected

Table	Action
AP_PAYMENT_SCHEDULES_ALL	Clear PPR assignment; reset payment status to Available
IBY_PAY_SERVICE_REQUESTS	Validate PPR status