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 APRIL 23, 2018

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.


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> - 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.

---------------- ------------------------------



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




To view full details, 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 a vibrant support community of peers and Oracle experts.