My Oracle Support Banner

When Attempting To View or Create or Update a Timecard with Template Error Encountered ORA-01722: invalid number (Doc ID 2820683.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Oracle Time and Labor - Version 12.2.10 and later
Information in this document applies to any platform.


On : 12.2.10 version, Template Issues

Error when attempting to create a new timecard using existing template(s). Also, error while reviewing old timecard (entered via template).

You have encountered an unexpected error. Please contact your system Administrator for assistance.

Exception details show the below.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

The issue can be reproduced at will with the following steps:
1. Log in to OTL Self Service time entry responsibility.
2. Try to create a timecard using an existing template
3. Get 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.