TriniDBA

Problem: After incorrect PPR (Payment Process Request) is terminated, the invoices cannot be selected for payment.

Solution:

Refer to R12: Generic Data Fix (GDF) patch for “stuck” invoices after PPR is terminated or completed (Doc ID 874862.1). Apply patch 19717441, then run the scripts $AP_TOP/patch/115/sql/ap_Rel_Inv_frm_TermPPR_sel.sql and ap_Rel_Inv_frm_TermPPR_fix.sql.

Firstly, download and apply 19717441. After applying the patch, run the scripts apgdfalb.pls and apgdfals.pls. These create the underlying packages for the datafix scripts. Log on to SQL*Plus as the apps user and run the ap_Rel_Inv_frm_TermPPR_sel.sql script. It requires four parameters:

• User_name: Provide the applications user_name.
• Email Id: Your email address, so that the output will be emailed to you
• Include Invoice Details in the Output Flag ‘Y’ or ‘N’: enter ‘Y’ to get the invoice details
• PPR Name: Specify PPR name (same as checkrun name) for the PPR to fix

After running, view the output log file created. It shows the PPR records that will be fixed. Then run the ap_Rel_Inv_frm_TermPPR_fix.sql script with the following parameters:

• User_Name: the EBS application user name for a user with the Payables responsibility
• Responsibility_name: the exact responsibility Name for the Payables responsibility
• Email Id: Your email address, so that the output will be emailed to you
• Include Invoice Details in the Output Flag ‘Y’ or ‘N’: enter ‘Y’ for invoice details

After these scripts have been run, you should be able to select the invoices once more.

Reference: R12: Generic Data Fix (GDF) patch for “stuck” invoices after PPR is terminated or completed (Doc ID 874862.1). Appl