R12: AP: APXINWKB Creating a Project Related Invoice With Sufficient Funds Encountering - APP-SQLAP-10000: USER-DEFINED EXCEPTION OCCURED (Doc ID 2959951.1)

Last updated on MAY 10, 2024

Applies to:

Symptoms

While creating a project related invoice with sufficient funds,
encountering the following error when performing Check Funds

The master GDF picks up the following known issue.

Findings and Recommendations:
Solution GDF: 18022957
Note: Doc ID 1349026.1
Script Name: ap_psa_cleanup_2_s.sql check 2

Apply the GDF patch following the instructions provided in Doc ID 1349026.1

The solution from Doc ID 1349026.1 can be run to correct the issue, however, the RCA is needed as the issue occurs often.

Steps to reproduce

1. Nav: Invoices-Entry-Invoices
2. Create an invoice with the following Line information:

Line 1 Item 5.00 Account=AAA Project info entered(sufficient funds in projects)
Line 2 Item -5.00 Account=AAA No project info entered.
Line 3 Item 5.00 Account=BBB No project info entered(sufficient funds in GL)

3.#3 - Click General Tab
From the toolbar select Actions-Check Funds

Receive:

Decision
Insufficient Funds remain in your budget for this invoice or
distribution. Payables includes encumbered funds in its funds check.

#4 - From the actions button

Validate the invoice.

Invoice is placed on a Insufficient Funds hold.
Click General Tab

#6 - From the toolbar select Actions-Check Funds and receive:

Error
APP-SQLAP-10000 User-Defined Exception occurred in
AP_FUNDS_CONTROL_PKG.Funds_Check<-Funds_Check_Processor
<-APXINWKB<-INV_SUM_FOLDER_BLOCK_UTIL
with parameters(invoice_id = XXXXX)
while performing the following operation
PSA PSA_BC_EVENT_ALREADY_PROCESSED N EVENT_ID XXXXX N
INVOICE_ID XXXXX N INV_DISTRIBUTION_ID XXXXX

Cause

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