My Oracle Support Banner

After running "EBS Online Patching Database Compliance Checker"(ADZDDBCC.sql), PER_STD_HOLIDAY_ABSENCES in the section "SECTION-32" (Doc ID 2370819.1)

Last updated on JUNE 02, 2024

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP4 to 12.2 HRMS RUP6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Problem Statement:

After running "EBS Online Patching Database Compliance Checker"(ADZDDBCC.sql", there is one HR object "PER_STD_HOLIDAY_ABSENCES" in the section "SECTION-32"

DOC> **********************************************************************
DOC> SECTION-32 [full]
DOC> **********************************************************************
DOC> "Seed Data Table must have a unique index."
DOC>
DOC> - P2: Run Edition updates to these tables will not be synchronized to the
DOC> Patch Edition if these tables are loaded during online patching.
DOC> - This violation can be ignored if the table is "Read-Only" for the runtime
DOC> application. To remove read-only tables from this report, please log a
DOC> bug with AD (166/OP).
DOC> Note: This check only works after Online Patching Enablement.
DOC>#

OWNER TABLE_NAME
---------------- ------------------------------
HR PER_STD_HOLIDAY_ABSENCES

 

 

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1.  Run "EBS Online Patching Database Compliance Checker"(ADZDDBCC.sql)
  2. Check SECTION-32

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.