Conditional field is not working on purchase requisition window
Hi ,
Conditional Fields is not working in one of the customer's APPS10 Environment. It gives below error View wMATERIAL_REQUISITION] not found in the dictionary.
I have refreshed the Dictionary Cache using the IFS Refresh Cache option. But it's not resolved the issue.
Can anyone help on this?
Best Regards -Kelum
Page 1 / 1
Hi @Kelum Niranjana
I have checked the same in APP10 / CORE / REGIONAL TEST CMB
we conditional fields are working fine in this environment for your screen.
I think we need to enable below system parameter to enable conditional fileds.
Please check.
Cheers,
Thilini
Hi @Thilini Aluthweediya Yes .Its enabled in the customers environment
further noticed, Conditional fields are not working in all windows. not only for the Purchase requisition window. ex:
-Kelum
Hi, Seems I found the root cause
The below error occurred
ORA-20105: Dictionary.DBNAME_TOO_LONG: The client name [XX_WORKER_SALARY_SHEET_GTY_REP] is too long to be converted into a 30 character database name.
when calling the following query:
"select vw.VIEW_NAME, vw.TYPE_OF_VIEW, vw.LU_NAME, lu.MODULE, lu.BASE_PACKAGE, language_sys.Translate_Lu_Prompt_(vw.LU_NAME) as TRANSLATED_PROMPT
from dictionary_sys_view vw inner join dictionary_sys_lu lu on vw.lu_name = lu.lu_name
where vw.VIEW_PROMPT IS NOT NULL ORDER BY VIEW_NAME;"
Seems there is a customer defined Report which has exceeded its name length 30 characters.