Hr_operating_units Table Data In Oracle Apps Is Not Coming In ...

Trang chủ » Hr_organization_units In Oracle Apps » Hr_operating_units Table Data In Oracle Apps Is Not Coming In ...

Có thể bạn quan tâm

Wednesday, 10 January 2018

hr_operating_units table data in oracle apps is not coming in windows 10-Oracle Views return no data due to NLS LANGUAGE Settings

I faced some issues when I query the below table data is not fetching in my query: SELECT * FROM hr_operating_units SELECT * FROM MTL_CATEGORIES Solution: You just need to check the USER ENV Language from the below query. SELECT USERENV('LANGUAGE') Language FROM DUAL; After that run the below query(alter language) ALTER session SET nls_language='AMERICAN' then check in your table query output: ex: SELECT * FROM hr_operating_units ------------------------------ SELECTUSERENV('LANG')FROM DUAL; USERENV(‘LANG’) ------------------------------ S SELECT * FROM V$NLS_PARAMETERS where parameter in('NLS_LANGUAGE','NLS_TERRITORY'); PARAMETER VALUE -------------------------------------------------- NLS_LANGUAGE SWEDISH NLS_TERRITORY SWEDEN b.Set NLS_LANG value in client (This is permanent Solution) Windows: i.Go to Start-> run ii.Type regedit and click ok iii.Drill Down to HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE-> KEY_OraClientxxx_homeX (xxx is the oracle client version and X is the currently used home) iv.Double click NLS_LANG and change Value data. For example in the example scenario updated NLS_LANG value to SWEDISH_SWEDEN.WE8MSWIN1252 v.Close regedit Make sure you have backup windows registry before modifying it. Or i.Click on Computer, select Properties. ii.Select Advance system settings iii.In the Advance tab, select Environment Variables iv.Select New v.Set variable name NLS_LANG and variable value SWEDISH_SWEDEN.WE8MSWIN1252 vi.Select ok and you should now see the new environment variable that you just created. Linux: setenv NLS_LANG <NLS_LANG> Example: setenv NLS_LANG SWEDISH_SWEDEN. WE8MSWIN1252 3. Restart the client. Examples, if you are using Toad restart TOAD for the changes to take effect. http://www.nazmulhuda.info/setting-nls_lang-environment-variable-for-windows-and-unix-for-oracle-database - January 10, 2018

16 comments:

  1. Unknown27 June 2019 at 21:51

    Thank you so much for solution.

    ReplyDeleteReplies
      Reply
  2. Srinivas27 February 2020 at 00:31

    thank you.

    ReplyDeleteReplies
      Reply
  3. Pravallika Matcha16 July 2020 at 23:06

    This comment has been removed by the author.

    ReplyDeleteReplies
      Reply
  4. Anonymous16 July 2020 at 23:08

    Its working.TqBut why should we keep it as american.

    ReplyDeleteReplies
      Reply
  5. Unknown9 August 2020 at 23:30

    Hey Nageswara Rao, Thankyou very much for this solution and the blog. This helped me a lot. SuhasiniVinodh.

    ReplyDeleteReplies
      Reply
  6. Unknown21 September 2020 at 01:43

    Thank you so much for this solution! I can't thank you enough. <3

    ReplyDeleteReplies
      Reply
  7. Anonymous15 February 2021 at 17:48

    This is very Helpful. Thankyou somuch.

    ReplyDeleteReplies
      Reply
  8. Unknown5 March 2021 at 02:14

    why you stopped writing blog Nageswararao, start writing on ORacle Cloud

    ReplyDeleteReplies
    1. Anonymous2 September 2024 at 11:45

      I will write soon, thank you

      DeleteReplies
        Reply
      2. Reply
  9. Oracle Apps Technical Knowledge Sharing20 May 2021 at 04:13

    Thanks a lot Nagesh

    ReplyDeleteReplies
      Reply
  10. Unknown15 June 2021 at 07:16

    Thanks You

    ReplyDeleteReplies
      Reply
  11. Anonymous24 June 2022 at 01:06

    It worked. Very useful. Thanks

    ReplyDeleteReplies
      Reply
  12. Pradeep Reddy Ambala3 August 2022 at 02:12

    Its worked thanks for your blog

    ReplyDeleteReplies
      Reply
  13. Anonymous16 September 2022 at 04:42

    Thank You soo Much. it Worked..

    ReplyDeleteReplies
      Reply
  14. Kalpana28 January 2023 at 06:21

    Thank you so much. Timely needed.

    ReplyDeleteReplies
      Reply
  15. Yatin Kumar15 September 2023 at 10:40

    Thanks a lot. It worked.

    ReplyDeleteReplies
      Reply
Add commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom)

Script to update salespersons customer site wise in oracle apps R12

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'DEENA VISION%'; SELECT * FROM HZ_CUST_ACCOUNTS_ALL WHERE PARTY_ID =94043 ; SE...

  • oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException Errors In Oracle Apps R12.2.5 For this error need to Check RTF template there should be tags are not correctly and if you are developing new  RTF latest version. Just se...
  • hr_operating_units table data in oracle apps is not coming in windows 10-Oracle Views return no data due to NLS LANGUAGE Settings I faced some issues when I query the below table data is not fetching in my query: SELECT * FROM hr_operating_units SELECT * FROM MTL_CAT...
  • OPM - GME_BATCH_HEADER Statuses Information select * from all_objects where object_name like 'GME%BATCH%' and object_type = 'TABLE' --------------------------------...

Search This Blog

  • Home

About Me

My photo Nageswara Rao Boya Kurnool, Andhrapradesh, India View my complete profile

Report Abuse

Blog Archive

  • ▼  2018 (3)
    • ▼  January (1)
      • hr_operating_units table data in oracle apps is n...

Từ khóa » Hr_organization_units In Oracle Apps