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 laterInformation in this document applies to any platform.
Symptoms
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
&CALLING_SE
l_val_msg_data(2) := ORA-20001: in Package AP_VEND
l_party_id := &party_id
Validation failed
Fetching expense report...
End UpdateDistsWithReceiptInfo
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
&CALLING_SE
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:
- Log into Oracle Applications using iExpenses responsibility.
- Open the Standard Request Submission (SRS) form
(N) Other > Request > Run - Find/select the "Expense Report Export" concurrent (APXEXPER)
- Enter the parameters and submit.
- Review the Log and see the error.
Changes
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 |
Changes |
Cause |
Solution |