Monday, December 20, 2010

Sysadmin User Responsibilities Missing

ISSUE: Sysadmin User Responsibilities Missing

In Oracle Applications, when logging as sysadmin - all the Sysadmin User Responsibilities Missing.

To fix this issue please perform the below.

1.) Execute following select :

SELECT *
FROM Fnd_Responsibility_vl
WHERE Application_Id = 1
AND Responsibility_Name = 'System Administrator'
AND Start_Date <= Sysdate
AND ( End_Date is NULL OR End_Date > Sysdate );

2.) Execute following select :

SELECT count(*) FROM Fnd_User_Resp_Groups;

3.a) Create the Backup table :

CREATE TABLE wf_role_hierarchies_copy AS SELECT * FROM wf_role_hierarchies;

3.b) truncate the existing table:

TRUNCATE TABLE applsys.wf_role_hierarchies;

3.c)sqlplus apps/xxxx @$FND_TOP/patch/115/sql/affurgol.sql FORCE

3.d) Insert the data into the new created table :

INSERT INTO wf_role_hierarchies SELECT * FROM wf_role_hierarchies_copy;

4.) Verify the output of the following SQL statement at this point :

SELECT count(*) FROM Fnd_User_Resp_Groups;



7 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  2. As the science is getting heights, projects deal for you because they create the best out of the available resources so that a customer cannot say NO to the seller and after this the quality of the product dies speak for the users.

    ReplyDelete
  3. This is the blog for the Oracle of the E-business and you can easily make your business better in place of the learning and boosting your business. You can also see the pattern of the fusion application from best essay writers and enjoy the knowledge zone.

    ReplyDelete
  4. This is the blog for the Naresh Miryala's and you can see the partner of the DBA blog for the better working of the Oracle which is the biggest company in the field of the IT. Give your big contribution to the samsung vr headset and move your idea for success.

    ReplyDelete