Home » Applications » Oracle Fusion Apps & E-Business Suite » query view returns no results (ebs projects)
query view returns no results [message #680484] Sat, 16 May 2020 09:12 Go to next message
irisa
Messages: 2
Registered: May 2020
Junior Member
Hello,

Cannot see any view results.

Example:
select * from PA_FIN_PLAN_TYPES_VL;

No rows returned, but is should.

This view is based on PA_FIN_PLAN_TYPES_B and PA_FIN_PLAN_TYPES_TL, for which I can see results.

I am using Oracle SQL Developer and standard user apps.

Please suggest what to look for.

Regards,
irisa
Re: query view returns no results [message #680485 is a reply to message #680484] Sat, 16 May 2020 09:30 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Is this an EBS related question?
Re: query view returns no results [message #680486 is a reply to message #680484] Sat, 16 May 2020 09:39 Go to previous messageGo to next message
John Watson
Messages: 8344
Registered: January 2010
Location: Global Village
Senior Member
If you look at the source code for the view you'll see that it ends with this,
FROM PA_FIN_PLAN_TYPES_TL T
, PA_FIN_PLAN_TYPES_B B
WHERE B.FIN_PLAN_TYPE_ID = T.FIN_PLAN_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
so unless your NLS session variables are set appropriately, you are not going to see any rows. What values are in the PA_FIN_PLAN_TYPES_TL.LANGUAGE column? What does USERENV(LANG) return for your session?

[Updated on: Sat, 16 May 2020 10:02]

Report message to a moderator

Re: query view returns no results [message #680511 is a reply to message #680486] Tue, 19 May 2020 08:39 Go to previous message
irisa
Messages: 2
Registered: May 2020
Junior Member
Hi John,

PA_FIN_PLAN_TYPES_TL.LANGUAGE = US

SELECT USERENV('LANG') FROM DUAL; -> RO

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Oracle\KEY_DevSuiteHome1\NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

SQL Developer > Tools > Preferences > Database > NLS > all set for AMERICAN / AMERICA

Where else I should check / change?

Thank you,
irisa
Previous Topic: oracle loan module implementation
Next Topic: XLAAARPT.RDF and APXAAREP.RDF QUERY
Goto Forum:
  


Current Time: Sat Sep 19 04:23:01 CDT 2020