My Oracle Support Banner

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 DECEMBER 15, 2023

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

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

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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