My Oracle Support Banner

Error while running Process Grants Regeneration (Doc ID 2532808.1)

Last updated on APRIL 19, 2019

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.10.0 version, Global Payroll

When attempting to to run the process "Process Grants Regeneration" the following error occurs.
User is able to regenerate the roles manually one by one.

ERROR
-----------------------
1. A system error ORA-06535: statement string in OPEN is NULL or 0 length ORA-06512: at "FUSION.PAY_POPULATION_RANGES_PKG", line 446 ORA-06512: at "FUSION.PAY_POPULATION_RANGES_PKG", line 491 ORA-06512: at line 1 occurred in table Chunk.Popul

2. ORA-06535: statement string in OPEN is NULL or 0 length ORA-06512: at "FUSION.PAY_POPULATION_RANGES_PKG", line 446 ORA-06512: at "FUSION.PAY_POPULATION_RANGES_PKG", line 491 ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Manage Data Roles and Security Profiles
2. Run the Process Grants Regeneration
3. Fails with errors


Changes

 

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
Changes
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.