Unexpected Error: When trying to Create a Expense Report (Doc ID 1055421.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Expenses - Version 11.5.10.0 to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
When attempting to create Expense Report,
the following error occurs.

ERROR
-----------------------
You have encountered an unexpected error.Please contact System Administrator for assistance.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: APP-SQLAP-10000: ORA-06508: PL/SQL: could not find program unit being called occurred in
GetDefaultTemplateId
with parameters ()
while performing the following operation:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_WEB_DB_EXPTEMPLATE_PKG", line 444
ORA-06512: at "APPS.AP_WEB_OA_MAINFLOW_PKG", line 82
ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Expense Report

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