Solved

Get_Ctx_Values___ doesn't return any value

  • 9 March 2023
  • 5 replies
  • 123 views

Userlevel 3
Badge +5

Problem

There is a customer, who is in 22R2 SU4. Their reported issue appear due to not returning any value from the following method call.

BEGIN
   -- Call the function
   :RESULT := DOMAIN_SYS.Get_Translated_Values(domain_ => :domain_, lang_code_ => :lang_code_);
END;
 

 

Following is the Get_Translated_Values method content.

Both methods return, null. 

According to the following Get_Ctx_Values__ method, context_value_ variable always returns null in customer environment.

 

domain_ is ‘WorkTypeCategory’

value is ‘gb’

Following values are available in customer environment.

 

So, my question is, can anyone please let me know, what could be other reasons for not returning any values for , 

context_value_ := Sys_Context(context_, nvl(value_, 'PROG'), ctx_length_);

 

In 22R2 core environment following records were returned any issue.

 

icon

Best answer by Amila Samarasinghe 14 March 2023, 11:10

View original

5 replies

Userlevel 6
Badge +14

Hi @Hiroshi Perera 

 

Did you check whether these prog texts exist in Text Translations window? Search “%WorkTypeCategory%” for Path column and see if it returns data.

 

BR,

Badge

Thank you for this information. i will figure out more.

Userlevel 6
Badge +14

Hi @Hiroshi Perera 

 

If everything looks ok in text translation, then try refreshing caches including language cache.

BR,

Userlevel 3
Badge +5

Hi @Hiroshi Perera 

 

If everything looks ok in text translation, then try refreshing caches including language cache.

BR,

Hi Amila thank you for the suggestions. I refreshed, language cache (In ‘Used Languages’ → Selected gb language and refreshed). And also refreshed  dictionary and Reference cache (In Refresh Server Cache’ )

Userlevel 3
Badge +5

Hi @Hiroshi Perera 

 

Did you check whether these prog texts exist in Text Translations window? Search “%WorkTypeCategory%” for Path column and see if it returns data.

 

BR,

Yes amila… It returns the expected results without any issue

Reply