Unable to compile APXWCARD on EBS R12.1.3 on AIX 6.1 (2 nodes) over RDBMS Oracle 11.2.0.2 (RAC 11g R
Hi,
We have EBS R12.1.3 on AIX 6.1 (2 nodes) over RDBMS Oracle 11.2.0.2 (RAC 11g R2).
When we compile all forms with adadmin, we have a problem with the following forms( could not be generated successfully):
ap forms/RO APXWCARD.fmx
ap forms/US APXWCARD.fmx
When I recompile the form I get the following error in the worker log:
FRM-30064: Unable to parse statement select distinct full_name, employee_number, date_of_birth, pa.person_id
from per_all_people_f pap,
financials_system_parameters fsp,
per_assignments_f pa
where (trunc(sysdate) between pap.effective_start_date and pap.effective_end_date)
We have EBS R12.1.3 on AIX 6.1 (2 nodes) over RDBMS Oracle 11.2.0.2 (RAC 11g R2).
When we compile all forms with adadmin, we have a problem with the following forms( could not be generated successfully):
ap forms/RO APXWCARD.fmx
ap forms/US APXWCARD.fmx
When I recompile the form I get the following error in the worker log:
FRM-30064: Unable to parse statement select distinct full_name, employee_number, date_of_birth, pa.person_id
from per_all_people_f pap,
financials_system_parameters fsp,
per_assignments_f pa
where (trunc(sysdate) between pap.effective_start_date and pap.effective_end_date)
Tagged:
0