Skip to main content
Solved

Get_Ctx_Values___ doesn't return any value


Forum|alt.badge.img+7

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.

 

Best answer by Amila Samarasinghe

Hi @Hiroshi Perera 

 

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

BR,

View original
Did this topic help you find an answer to your question?

5 replies

Amila Samarasinghe
Superhero (Partner)
Forum|alt.badge.img+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,


Forum|alt.badge.img
  • Do Gooder
  • 1 reply
  • March 13, 2023

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


Amila Samarasinghe
Superhero (Partner)
Forum|alt.badge.img+14

Hi @Hiroshi Perera 

 

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

BR,


Forum|alt.badge.img+7
  • Author
  • Sidekick (Employee)
  • 26 replies
  • March 14, 2023
Amila Samarasinghe wrote:

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’ )


Forum|alt.badge.img+7
  • Author
  • Sidekick (Employee)
  • 26 replies
  • March 14, 2023
Amila Samarasinghe wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings