Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
PER_CHK_ACTION_OCC_ITEMS: which table and column does foreign key column OBJECT_CHANGE_ID reference? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PER_CHK_ACTION_OCC_ITEMS: which table and column does foreign key column OBJECT_CHANGE_ID reference?

Received Response
21
Views
3
Comments
edited Jul 28, 2022 4:43AM in Human Resources 3 comments

Summary:

I'm looking for information about column OBJECT_CHANGE_ID in table PER_CHK_ACTION_OCC_ITEMS. Which table and column does this column refer to?

Content (required):

I was under the impression that PER_CHK_ACTION_OCC_ITEMS.OBJECT_CHANGE_ID referenced HRC_EVT_OBJ_CHANGES.CHANGE_ID.

However, I've found a few values in OBJECT_CHANGE_ID that don't exist in HRC_EVT_OBJ_CHANGES.CHANGE_ID, thus violating referential integrity.

Can anyone confirm or deny my assumption, provide the correct reference, or confirm that records from HRC_EVT_OBJ_CHANGES can just be deleted, without cascading or setting null in dependent tables?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!