My Oracle Support Banner

Projects Patch Failure During Application Gives Error 'ORA-20001: Crossedition Trigger APPS.PA_AGREEMENT_TYPES_F1 does not exist' (Doc ID 2925659.1)

Last updated on JULY 26, 2024

Applies to:

Oracle Project Billing - Version 12.2.7 and later
Oracle Project Foundation - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms


When attempting to apply Projects patch 33294610, the following error is returned:

ERROR
ERROR at line 1:
ORA-20001: Crossedition Trigger APPS.PA_AGREEMENT_TYPES_F1 does not exist
ORA-06512: at "APPS.AD_ZD", line 26
ORA-06512: at "APPS.AD_ZD_TABLE", line 19
ORA-06512: at "APPS.AD_ZD_TABLE", line 1767
ORA-06512: at line 1

Steps to Reproduce

1. Apply patch 33294610:R12.PA.C using adpatch

2. Check if there exists above is mentioned error in worker logs


OR

While following EBS_SYSTEM schema migration Document ID 2774309.1, Section 6, Step 6 "Apply product-specific postrequisite patches (Conditional)" and applying an environment specific merged patch containing Patches 33217102, 33133773, 33294610 and 31522737, adop fails with:

'ORA-20001: Crossedition Trigger APPS.PA_AGREEMENT_TYPES_F1 does not exist'

Steps to Reproduce

1. Apply the merged patch using adpatch

2. Check if there exists above is mentioned error in worker logs

 

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.