Fusion Global HR: Flatten HCM Position Hierarchy Process Failed

(Doc ID 2399327.1)

Last updated on MAY 18, 2018

Applies to:

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


On Rel13 and HCM Position Hierarchy is enabled at an enterprise level.
After loading the position hierarchy, run the "Flatten HCM Hierarchy" process in "parallel mode".
The processes resulted in an error stating the table or view does not exists.

*** ERROR *** ORA-00942: table or view does not exist

The issue can be reproduced at will with the following steps:
1. Manage Schedule process and run the process Flatten HCM Hierarchy in parallel mode


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