{"id":1184,"date":"2012-04-22T00:17:17","date_gmt":"2012-04-22T00:17:17","guid":{"rendered":"http:\/\/www.juniovitor.com\/?p=1184"},"modified":"2014-12-05T19:45:00","modified_gmt":"2014-12-05T19:45:00","slug":"contexto-oracle","status":"publish","type":"post","link":"https:\/\/www.juniovitor.com\/?p=1184","title":{"rendered":"Contexto Oracle"},"content":{"rendered":"<div align=\"justify\">\nFala pessoal,<\/p>\n<p>Quem \u00e9 que nunca executou um SQL e n\u00e3o retornou dados? Bom&#8230; existem in\u00fameros motivos dos quais o seu SQL pode n\u00e3o estar retornando dados, mas deixo aqui um dica quando necess\u00e1rio executar uma query que necessita de contexto. <\/p>\n<p>Setar contexto \u00e9 como se estivesse exatamente dentro do aplicativo Oracle EBS, com as todas as restri\u00e7\u00f5es, atribui\u00e7\u00f5es,  organiza\u00e7\u00f5es, etc&#8230; Quando criar um SQL a partir de tabelas sem o prefixo \u201c_all\u201d, recomenda-se a utiliza\u00e7\u00e3o do contexto.<\/p>\n<p>Para fazer isto, basta executar os comandos abaixo:<\/p>\n<p>Para recuperar as informa\u00e7\u00f5es a seguir, utilize os SQL\u2019s:<\/p>\n<p><strong>Recuperando Informa\u00e7\u00f5es Usu\u00e1rio<br \/>\n<\/strong><\/p>\n<pre class=\"brush:sql\">\r\nSELECT USER_ID\r\n  FROM FND_USER \r\n WHERE USER_NAME = '<USUARIO>'; -- Usu\u00e1rio de Login no Oracle EBS\r\n<\/pre>\n<p><strong>Recuperando Informa\u00e7\u00f5es Responsabilidade<br \/>\n<\/strong><\/p>\n<pre class=\"brush:sql\">\r\nSELECT RESPONSIBILITY_ID\r\n     , APPLICATION_ID\r\n  FROM FND_RESPONSIBILITY_TL\r\n WHERE RESPONSIBILITY_NAME = &NOME_DA_RESPONSABILIDADE;\r\n<\/pre>\n<p><strong>Setando Contexto ORG_ID na Release 12<br \/>\n<\/strong><\/p>\n<pre class=\"brush:sql\">\r\nBEGIN\r\n  MO_GLOBAL.SET_POLICY_CONTEXT (P_ACCESS_MODE => 'S',\r\n                                P_ORG_ID      => &ORG_ID);\r\nEND;\r\n<\/pre>\n<p><strong>Setando Contexto ORG_ID na Release 11i<br \/>\n<\/strong><\/p>\n<pre class=\"brush:sql\">\r\nBEGIN\r\n   FND_CLIENT_INFO.SET_ORG_CONTEXT (P_ORG_ID      => &ORG_ID);\r\nEND;\r\n<\/pre>\n<p><strong>Setando o Usu\u00e1rio, Responsabilidade e Aplica\u00e7\u00e3o<br \/>\n<\/strong><\/p>\n<pre class=\"brush:sql\">\r\nBEGIN\r\n  FND_GLOBAL.APPS_INITIALIZE(USER_ID      => &USER_ID,\r\n                             RESP_ID      => &RESP_ID,\r\n                             RESP_APPL_ID => &RESP_APPL_ID);\r\nEND;\r\n<\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Fala pessoal, Quem \u00e9 que nunca executou um SQL e n\u00e3o retornou dados? Bom&#8230; existem in\u00fameros motivos dos quais o seu SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[216,215,622,214,217,213],"class_list":["post-1184","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-context","tag-contexto","tag-oracle","tag-org_id","tag-setando-contexto-oracle","tag-setting"],"_links":{"self":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/1184"}],"collection":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1184"}],"version-history":[{"count":11,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/1184\/revisions"}],"predecessor-version":[{"id":1271,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/1184\/revisions\/1271"}],"wp:attachment":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}