R12.2.9: Upgrading EBS from R12.2.5 to R12.2.9, Not Able To Compile View APPS.PA_PROJECT_ASSIGNMENTS_V (Doc ID 2619411.1)

Last updated on NOVEMBER 09, 2022

Applies to:

Symptoms

1. Upgrading EBS from R12.2.5 to R12.2.9 through Patch 28840850 - ORACLE E-BUSINESS SUITE 12.2.9 RELEASE UPDATE PACK

It failed at form:
------------------
The following Oracle Forms objects did not generate successfully:
pa forms/US PAXTRAPE.fmx

2. When trying to manually recompile the form PAXTRAPE.fmx:
/sbpd8i/applmgr/fs2/EBSapps/10.1.2/bin/frmcmp_batch userid=apps/xxxx module=/sbpd8i/applmgr/fs2/EBSapps/appl/au/12.0.0/forms/US/PAXTRAPE.fmb output_file=/sbpd8i/applmgr/fs2/EBSapps/appl/pa/12.0.0/forms/US/PAXTRAPE.fmx module_type=form compile_all=special

Get error:
-----------
FRM-30064: Unable to parse statement select psgn.assignment_name,psgn.assignment_id, psgn.project_role_name, substr(psgn.resource_name,1,80)"resource_name" , psgn.start_date, psgn.end_date
from pa_project_assignments_v psgn
where ((:items_qf.project_id is not null
and psgn.project_id = :items_qf.project_id)
OR
( :items_qf.project_id is null)) AND assignment_type = 'STAFFED_ASSIGNMENT'

.
ORA-04063: view "APPS.PA_PROJECT_ASSIGNMENTS_V" has errors
Record Group ASSIGNMENT_QF
Form: PAXTRAPE

FRM-30085: Unable to adjust form for output.

Form not created

3. Tried manually compile the view, getting error:

SQL> alter view APPS.PA_PROJECT_ASSIGNMENTS_V compile;

Warning: View altered with compilation errors.

SQL> show errors view APPS.PA_PROJECT_ASSIGNMENTS_V
Errors for VIEW APPS.PA_PROJECT_ASSIGNMENTS_V:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-01719: outer join operator (+) not allowed in operand of OR
or IN

Customer has RDBMS version 12.1.0.2.0.

Changes

 Upgrading EBS from R12.2.5 to R12.2.9

Cause

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