Tuesday, 24 September 2013

Cannot Select View eam_work_order_details_v Oracle EBS R12

I want to select View eam_work_order_details_v from TOAD in Oracle EBS R12. But, after i running the query, no rows Returned. :(

So, the steps for i can select view eam_work_order_details_v like this:

  1. Check your USERENV ('LANG') in your Profile. Check with this Query (select userenv('LANG') from dual).
  2. If the results Language not US, u must alter setting USERENV to US (alter session set nls_language='AMERICAN').
  3. Done, i can selected this query. :D 

0 comments:

Post a Comment