Posts by Janani B

Create User and Add Responsibility from Backend

blog-2-create-user-and-add-responsibility-from-backend   Query: declare v_user_name varchar2(30) :=’AJ_TEST’;   — User Name v_password  varchar2(30) :=’johnytips’;  — Password — List of responsibilities to be added automatically cursor cur_get_responsibilities is select resp.responsibility_key ,resp.responsibility_name ,app.application_short_name…

Read More

Script to Create Responsibility using API

blog-1-script-to-create-responsibility-using-api Query: CREATE TABLE APPS.XXRAN_RESPONSIBILITY_TAB ( RESP_NAME    VARCHAR2(100 BYTE), APPLICATION  VARCHAR2(50 BYTE), RESP_KEY     VARCHAR2(40 BYTE), MENU_NAME    VARCHAR2(60 BYTE), DATA_GROUP   VARCHAR2(40 BYTE), REQ_GROUP    VARCHAR2(50 BYTE), STATUS       VARCHAR2(1 BYTE), ERROR_MSG    VARCHAR2(240 BYTE)…

Read More