Solved

Conditional field is not working on purchase requisition window

  • 28 October 2021
  • 3 replies
  • 299 views
Kelum Pradeep Kumara
Rank
Userlevel 7
Badge +18

Hi ,

Conditional Fields is not working in one of the customer's APPS10 Environment.
It gives below error 
View [MATERIAL_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

icon

Best answer by Kelum Pradeep Kumara 30 October 2021, 03:25

View original
-Kelum Niranjana
This topic has been closed for comments

3 replies

Thilini Aluthweediya
Rank
Userlevel 5
Badge +6

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

Kelum Pradeep Kumara
Rank
Userlevel 7
Badge +18

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

-Kelum Niranjana
Kelum Pradeep Kumara
Rank
Userlevel 7
Badge +18

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

-Kelum Niranjana
Terms & ConditionsCookie settings