Expense Report Fails in Workflow With ORA-06533 ORA-20001 APP-SQLAP-10000 (Doc ID 1113316.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

Oracle Internet Expenses - Version: 11.10.5.2 to 12.1 - Release: 11 to 12.1
Information in this document applies to any platform.

Symptoms

When attempting to submit an expense report, the following error occurs in workflow during Server Side Validation Process/AP Validate Expense Report

ERROR
-----------------------
ORA-20001: APP-SQLAP-10000: ORA-6533: Subscript beyond count
occurred in
AddDistributionLine
with parameters (&PARAMETERS)
while performing the following operation:
get next AP_EXP_REPORT_DISTS_S

AP_WEB_EXPENSE_WF.APValidateExpenseReport(APEXP, 231706, 0, Call DoAPValidationORA-06533: Subscript beyond count occurred in
AddDistributionLine
with parameters (&PARAMETERS)
while performing the following operation:
get next AP_EXP_REPORT_DISTS_S)
Wf_Engine_Util.Function_Call(AP_WEB_EXPENSE_WF.APVALIDATEEXPENSEREPORT, APEXP, 231706, 222263, RUN)

OR

ORA-20001: APP-SQLAP-10000: Se ha producido el error ORA-06533: Subscript beyond count en la secuencia
AddDistributionLine
con los par�metros (&PARAMETERS)
durante la ejecuci�n de la siguiente operaci�n:
get next AP_EXP_REPORT_DISTS_S


Expected Behavior
----------------------
Server side validation should complete without error and generate rows successfully in the ap_exp_report_dists_all table.

Changes

In Release 11.5.10, patches 8200168 and 9036980 were applied.

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