R12 Pay Process Request Will Not Mark As Complete (Doc ID 1518757.1)

Last updated on JANUARY 02, 2017

Applies to:

Oracle Payments - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When Attempting to Mark The Payments Complete the Process appears to do nothing.
The user is not notified of any error.

FND DEBUG Shows

AP.PLSQL.AP_WITHHOLDING_PKG.Create_AWT_Invoices Insert Into ap_invoices
AP.PLSQL.AP_WITHHOLDING_PKG.Create_AWT_Invoices Insert INTO ap_invoice_lines_all
AP.PLSQL.AP_UTILITIES_PKGGet_Current_Gl_Date Begining of Function
AP.PLSQL.AP_UTILITIES_PKGGet_Current_Gl_Date Index Value: 20-APR-2012-11583
AP.PLSQL.AP_UTILITIES_PKGGet_Current_Gl_Date Period Name not there in plsql table : 1-13
AP.PLSQL.AP_WITHHOLDING_PKG.Create_AWT_Invoices invoice_id = 3754735
AP.PLSQL.AP_WITHHOLDING_PKG.Create_AWT_Invoices invoiceline_number = 3
AP.PLSQL.AP_WITHHOLDING_PKG.Create_AWT_Invoices c_awt_lines chosen
AP.PLSQL.AP_WITHHOLDING_PKG.Create_AWT_Invoices rows chosen0
AP.PLSQL.AP_WITHHOLDING_PKG.Create_AWT_Invoices Fetch CURSOR c_awt_lines
AP.PLSQL.AP_WITHHOLDING_PKG.Create_AWT_Invoices Insert INTO ap_invoice_distributions
AP.PLSQL.AP_UTILITIES_PKGGet_Current_Gl_Date Begining of Function
AP.PLSQL.AP_UTILITIES_PKGGet_Current_Gl_Date Index Value: 20-APR-2012-11583
AP.PLSQL.AP_UTILITIES_PKGGet_Current_Gl_Date Period Name from existing plsql table for index found: 1-13
AP.PLSQL.AP_WITHHOLDING_PKG.Create_AWT_Invoices Update ap_invoice_distributions
AP.PLSQL.AP_WITHHOLDING_PKG.Create_AWT_Invoices Fetch CURSOR c_awt_lines
AP.PLSQL.AP_CREATE_PAY_SCHEDS_PKG.AP_Create_From_Terms AP_CREATE_PAY_SCHEDS_PKG.AP_Create_From_Terms<-ap_do_withholding
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_CREATE_PAY_SCHEDS_PKG.AP_Create_From_Terms<-ap_do_withholding
with parameters (Invoice_Id = 3807569, Terms_Id = 10021, Last_Updated_By = 143151, Created_By = 143151, Payment_Priority = 99, Batch_Id = 306701, Terms_Date = 20-APR-2012, Invoice_Amount = 293, Amount_for_discount = , Payment_Method = CHECK, Currency = GBP)
while performing the following operation:
Delete from ap_payment_schedules"
...
iby.plsql.IBY_VALIDATIONSETS_PUB IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete : Fatal: External app callout 'AP_PMT_CALLOUT_PKG.payments_completed', generated exception.
iby.plsql.IBY_VALIDATIONSETS_PUB IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete : SQL code: -20001
iby.plsql.IBY_VALIDATIONSETS_PUB "IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete : SQL err msg: ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_CREATE_PAY_"
iby.plsql.IBY_VALIDATIONSETS_PUB IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete : Exception occured when marking payments complete for payment instruction 79350
iby.plsql.IBY_VALIDATIONSETS_PUB IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete : SQLCODE: -20001
iby.plsql.IBY_VALIDATIONSETS_PUB "IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete : SQLERRM: ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_CREATE_PAY_SCHE"
iby.plsql.IBY_VALIDATIONSETS_PUB IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete : EXIT

 

There are two responsibilities used for Payment Processing.
One for ORG 1 - Which is an Operating Unit and a Business Group
One for ORG 2 - Which is an Operating Unit in the same Business Group.
When a PPR is processed it contains invoices of only ONE Operating Unit at a time.

The ORG 2 run sometimes has AWT invoices and sometimes doesn't.

The Payment Runs are set to Manual Completion (at the insistence of business users),
and the Funds Disbursement Responsibility is used to mark the electronic payments as complete.

The issue comes when marking payments as complete for the ORG 2 Payment run (under ORG 2 responsibility) when AWT invoices are included.
The AWT invoices are not created and the Payment run does not complete.

The Customer has two Responsibilities in AP one for ORG 1 and one for ORG 2 and only one for Funds Disbursement with an MO Security Profile including Both Operating Units..

If the completion point is set to "Formatted" then they will not use the Funds Disbursement and the Operating Unit Specific Responsibilities complete the payments directly from AP.

If the PI does not include AWT Invoices for ORG 2 then the Manual Completion of the Payments using FD Responsibiity works correctly.
If the PI includes AWT Invoices only for ORG 1 then it works correctly
If the PI includes AWT Invoices for ORG 2 then the FD Responsibility must have the Profile Options modified such that MO Security Profile and MO Operating
Unit must point to ORG 2.

The issue is that the MO: Profiles for the Funds Disbursement responsibility either have to point to ORG 1 or ORG 2 regardless of how the security profiles
are set up. The Customer does not want separate Funds Disbursement Responsiblity for each Operating Unit. Setting the MO Security Profile to include Both Operating Units should be sufficient.

The problem can be worked around by resetting the profile options for the Funds Disbursement Responsibility when required such that MO Security Profile and MO Operating Unit point to ORG 2.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms