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 MARCH 08, 2018

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP4 and later
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

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