Skip to main content

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

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.

-Kelum