My Oracle Support Banner

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

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.