{"id":1509,"date":"2018-01-31T15:58:20","date_gmt":"2018-01-31T18:58:20","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=1509"},"modified":"2018-01-31T15:58:51","modified_gmt":"2018-01-31T18:58:51","slug":"criando-um-usuario-no-oracle-ebs-por-api","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/criando-um-usuario-no-oracle-ebs-por-api\/","title":{"rendered":"Criando um usu\u00e1rio no Oracle EBS por API"},"content":{"rendered":"<p>As vezes precisamos automatizar o processo de cria\u00e7\u00e3o de usu\u00e1rios no Oracle EBS ou ter mais agilidade na cria\u00e7\u00e3o , alguns casos podemos criar os usu\u00e1rios pelo Banco,\u00a0 n\u00e3o necessitando acesso as telas do EBS.<\/p>\n<p>Para criar \u00e9 muito simples.<\/p>\n<p>Inicialmente execute o bloco an\u00f4nimo passado o novo usu\u00e1rio.<\/p>\n<pre class=\"lang:default decode:true \">DECLARE\r\n\r\nv_user_name VARCHAR2 (100) := upper(\u2018&amp;Enter_User_Name\u2019);\r\n\r\n\u00a0v_description VARCHAR2 (100) := \u2018new test user';\r\n\r\nBEGIN\r\n\r\n\u00a0fnd_user_pkg.createuser\r\n\r\n(x_user_name =&gt; v_user_name,\r\n\r\n\u00a0x_owner =&gt; NULL,\r\n\r\n\u00a0x_unencrypted_password =&gt; \u2018&amp;input_password\u2019,\r\n\r\n\u00a0x_session_number =&gt; 0,\r\n\r\n\u00a0x_start_date =&gt; SYSDATE,\r\n\r\n\u00a0x_end_date =&gt; NULL,\r\n\r\n\u00a0x_last_logon_date =&gt; NULL,\r\n\r\n\u00a0x_description =&gt; v_description,\r\n\r\n\u00a0x_password_date =&gt; NULL,\r\n\r\n\u00a0x_password_accesses_left =&gt; NULL,\r\n\r\n\u00a0x_password_lifespan_accesses =&gt; NULL,\r\n\r\n\u00a0x_password_lifespan_days =&gt; NULL,\r\n\r\n\u00a0x_employee_id =&gt; NULL,\r\n\r\n\u00a0x_email_address =&gt; NULL,\r\n\r\n\u00a0x_fax =&gt; NULL,\r\n\r\n\u00a0x_customer_id =&gt; NULL,\r\n\r\n\u00a0x_supplier_id =&gt; NULL,\r\n\r\n\u00a0x_user_guid =&gt; NULL,\r\n\r\n\u00a0x_change_source =&gt; NULL\r\n\r\n\u00a0);\r\n\r\n\u00a0COMMIT;\r\n\r\nEND;\r\n\r\n\u00a0\/\r\n\r\nSHOW ERR;<\/pre>\n<p>Esse segundo bloco e para adicionar uma responsabilidade ao novo usu\u00e1rio.<\/p>\n<pre class=\"lang:default decode:true \">DECLARE\r\n\r\n\u00a0v_user_name VARCHAR2 (100) := upper(\u2018&amp;Enter_User_Name\u2019);\r\n\r\nBEGIN\r\n\r\nfnd_user_pkg.addresp(username =&gt; v_user_name\r\n\r\n\u00a0,resp_app =&gt; \u2018&amp;APPLICATION_SHORT_NAME\u2019\r\n\r\n\u00a0,resp_key =&gt; \u2018&amp;RESPONSIBILITY_KEY\u2019\r\n\r\n\u00a0,security_group =&gt; \u2018STANDARD\u2019\r\n\r\n\u00a0,description =&gt; NULL\r\n\r\n\u00a0,start_date =&gt; SYSDATE\r\n\r\n\u00a0,end_date =&gt; null);\r\n\r\n\u00a0commit;\r\n\r\nEND;\r\n\r\n\u00a0\/\r\n\r\nSHOW ERR;<\/pre>\n<p>Caso voc\u00ea tenha dificuldades em encontra os par\u00e2metros para a nova responsabilidade, o select abaixo pode ajudar.<\/p>\n<pre class=\"lang:default decode:true \">set lines 132\r\ncol RESPONSIBILITY_NAME format a50\r\nselect a.application_short_name, r.responsibility_key\r\nfrom fnd_responsibility_vl r, fnd_application_vl a where\r\nr.application_id =a.application_id\r\nand upper(r.responsibility_name) in upper (\u2018&amp;RESPONSIBILITY_NAME\u2019);<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As vezes precisamos automatizar o processo de cria\u00e7\u00e3o de usu\u00e1rios no Oracle EBS ou ter mais agilidade na cria\u00e7\u00e3o , alguns casos podemos criar os usu\u00e1rios pelo Banco,\u00a0 n\u00e3o necessitando acesso as telas do EBS. Para criar \u00e9 muito simples. Inicialmente execute o bloco an\u00f4nimo passado o novo usu\u00e1rio. DECLARE v_user_name VARCHAR2 (100) := upper(\u2018&amp;Enter_User_Name\u2019); \u00a0v_description VARCHAR2 (100) := \u2018new test user&#8217;; BEGIN \u00a0fnd_user_pkg.createuser (x_user_name =&gt; v_user_name, \u00a0x_owner =&gt; NULL, \u00a0x_unencrypted_password =&gt; \u2018&amp;input_password\u2019, \u00a0x_session_number =&gt;[&#8230;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[2,20],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1509"}],"collection":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/comments?post=1509"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1509\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=1509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=1509"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=1509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}