In EBS R12.1.3, After Applying Oracle Purchasing Consolidation Patch for 12.1.3 - August 2019. In order to open Forms, Receipts, Returns & View receiving transactions are showing Error as follows:
|
The following Oracle Forms objects did not generate successfully:
ar forms/US ARXRWRCT.fmx
po forms/US RCVRCVRC.fmx
po forms/US RCVSHESH.fmx
po forms/US RCVTXVTX.fmx
po forms/US RCVTXERE.fmx
po forms/US RCVCOFND.fmx
po forms/US RCVRCERC.fmx
po forms/US RCVTXECO.fmx
po forms/US RCVTXERT.fmx
Try to Execute the following commands to generate the forms manually:
frmcmp_batch userid=apps/<apps_pw> module=RCVRCVRC.fmb output_file=$AU_TOP/forms/US/RCVRCVRC.fmx module_type=form batch=no compile_all=special
Not compiled with below Errors: FRM-30064: Unable to parse statement select
distinct hre.person_id, hre.full_name, nvl(hre.employee_number,
hre.npw_number) employee_number from per_all_people_f hre, rcv_transactions
rt where rt.employee_id = hre.person_id and (rt.transaction_type = 'UNORDERED'
or rt.transaction_type = 'RECEIVE') and rt.organization_id =
:po_startup_values.org_id
and hre.business_group_id in (select
nvl(fsp.business_group_id,0)
from financials_system_params_all fsp where
mo_global.check_access(fsp.org_id) = 'Y')
and trunc(sysdate) between
hre.effective_start_date and hre.effective_end_date
and decode(hr_security.view_all ,'Y','TRUE',
HR_SECURITY.SHOW_PERSON (HRE.person_id ,
HRE.current_applicant_flag ,HRE.current_employee_Flag , HRE.current_npw_flag
,HRE.employee_number , HRE.applicant_number , HRE.npw_number)) = 'TRUE'
and
decode(hr_general.get_xbg_profile,'Y',hre.business_group_id ,
hr_general.get_business_group_id) =
hre.business_group_id
order by upper(hre.full_name)
.
ORA-01791: not a SELECTed expression
Record Group FIND_RECEIVER
Form: RCVRCVRC
FRM-30085: Unable to adjust form for output.
Form not created
|
Solution:
Step 1: First, test in UAT environment or cloned instance.
Set the database parameter
- _replace_virtual_columns = false
SQL> alter system set "_replace_virtual_columns"=FALSE;
|
|
Step
2: Stop the application service and Restart the database.
Then,
Run adadmin to Relink / Generate Forms Library Files:
Select the "Generate
Applications Files menu" option.
Then select the "Generate
forms files" option.
Choose
the number of workers, the default is recommended and is based off the number
of CPUs in your server.
|
Enter
"yes" at this prompt to regenerate PL/SQL library files (.pll
extension)
Enter
"yes" at this prompt to regenerate Forms Menu files (.mmb ->
.mmx extension)
Enter
"yes" at this prompt to regenerate Forms Executable files (.fmb
-> .fmx extension)
Enter the list
of products, by short name as they are listed in "$APPL_TOP/".
Use commas to separate the product names.
|
|
|
As per above steps, Recompiled all forms and
form libraries and then follow step 4.
|
|
Step 4: Retest the
issue. Otherwise, If the issue get resolved, then implement the solution
on PRODUCTION Instance.
|
Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldEditEdit in GingerEdit in GingerEnable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldEditEdit in GingerEdit in Ginger
