My Oracle Support Banner

R12: OIE: Concurrent Program "Expense Report Export" Ends with Error "ORA-20001 in Package AP_VENDOR_PUB_PKG" (Doc ID 2904789.1)

Last updated on OCTOBER 26, 2022

Applies to:

Oracle Internet Expenses - Version 12.2.5 and later
Information in this document applies to any platform.


Concurrent Program "Expense Report Export" Ends with Error "ORA-20001 in Package AP_VENDOR_PUB_PKG"

The log of the concurrent program Expense Report Export (APXEXPER) shows:

Expense Report Number : **EXPXXXXX**
Transfer Attachments option(Y/N):Y

Header Total: 1925.44, Line Total: 1925.44, Dist Total: 1925.44
END ValidateAmounts

Call procedure to query and validate expense lines
Get/validate the vendor_id and vendor_site_id
Get Vendor Info
>p_vendor_rec.vendor_id := -1
>p_vendor_rec.vendor_site_id := -1
>p_vendor_rec.home_or_office := O
>p_vendor_rec.employee_id := &employee_id
>p_vendor_rec.vendor_name := &vendor_name
>p_vendor_rec.org_id := &org_id

>p_vendor_rec.pay_group := EMPLOYEE

Get Vendor Info when vendor id is not known
Employee Id &employee_id is not found
l_vendor_id := -1

Get party_id
l_vendor_rec.party_id = &party_id
Checking Automatic Create Employee as Supplier option
Checking ap_product_setup.supplier_numbering_method
Creating a vendor (AP_VENDOR_PUB_PKG.create_vendor())
l_val_return_status := U
l_val_msg_count := 10
l_val_msg_data(1) := &ERROR occurred in
l_val_msg_data(2) := ORA-20001: in Package AP_VEND

l_party_id := &party_id
Validation failed
Fetching expense report...
End UpdateDistsWithReceiptInfo


The same error messages are displayed while creating the supplier manually on the Suppliers setup web page:

&ERROR occurred in &CALLING_SEQUENCE with parameters (&PARAMETERS) while performing the following operation: &DEBUG_INFO ORA-20001: in Package AP_VENDOR_PUB_PKG Procedure Create_Vendor


Steps to reproduce:

  1. Log into Oracle Applications using iExpenses responsibility.
  2. Open the Standard Request Submission (SRS) form
    (N) Other > Request > Run
  3. Find/select the "Expense Report Export" concurrent (APXEXPER)
  4. Enter the parameters and submit.
  5. Review the Log and see the error.





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

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