My Oracle Support Banner

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 DECEMBER 11, 2019

Applies to:

Oracle Project Foundation - Version 12.2.9 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

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