Approval Style Page Errors When Querying a Custom Approval Style

(Doc ID 1602301.1)

Last updated on JULY 08, 2017

Applies to:

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

Symptoms

You have created a custom Approval Style which consists of multiple entry level
approval components ( more than 9).

When Re-Querying the approval style you get an error

ERROR
-----------------------
ORA-6512: at "APPS.HXC_NOTIFICATION_HELPER", line 406
ORA-6502: PL/SQL: numeric or value error: number precision too large




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