Violations List Contains Objects Starting With TICK_F After EBS Upgrade to 12.2.x (Doc ID 2364013.1)

Last updated on AUGUST 14, 2023

Applies to:

Symptoms

Summary:After EBS was upgraded to 12.2.x, CCG objects starting with TICK_F owned by AM_AGENT schema in EBS instance, appear in the Violations List.

Details:

The customer is following the below document to upgrade from EBS 12.1.2 to 12.2.3. As a pre-requsite/validation, a script is run to show violations and recommendations are to fix those violations before proceeding with upgrade.The details are as below:

http://docs.oracle.com/cd/E26401_01/doc.122/e48834.pdf
Oracle® E-Business Suite Upgrade Guide Release 11i to 12.2
Part No. E48834-05

Page 92, step 4

Fix Violations Listed in the Online Patching Readiness Report that Require Manual Intervention The Online Patching Readiness Report contains sections with different violation types.
1. Review all sections listed from the ADZDPMAN.sql report. Follow instructions in each section to fix violations.

When we run this sql, its generating all the violations by CCG user AM_AGENT. The upgrade guide strongly recommends NOT to proceed with the upgrade unless these violations are fixed.

Actual Violations are as below, there are around 2035 CCG objects owned by AM_AGENT with below violations

"Query/DML statements must access Tables via the Table Synonym or Editioning View"
************************************
AM_AGENT TICK_F_0000000002080704 FUNCTION APPLSYS FND_USER

There are two issues that customer is requesting to be addressed.
1. Fix these violations
2. Can these violations be ignored for now and proceed with upgrade.

Changes

 EBS upgraded to 12.2.x

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.