My Oracle Support Banner

Differences Between Position Management Tables PS_POSITION_DATA_E and PS_POSITION_DATA (Doc ID 2677223.1)

Last updated on MAY 15, 2023

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Fluid Position Management uses PS_POSITION_DATA_E record/table
Classic Mode Position Data uses PS_POSITION_DATA record/table

These 2 records will need to co-exist even after enabling Fluid Position Management.

The tables may go out-of-sync for a variety of reasons.

- When a position is created using Fluid Position Management, for the period before the position is approved
- If the approval process fails during the update to PS_POSITION_DATA will not occur
- If the approval fails for any other reason (such as incumbents couldn't be updated)

If the tables are found to be out-of-sync, how to address the out-of-sync problem?


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.