How to remove the Concurrent Program from a Request Group

SET SERVEROUTPUT ON spool /tmp/XXCDS_HRRPTXXX_REMOVE_RG.TXT WHENEVER SQLERROR EXIT FAILURE ROLLBACK BEGIN apps.fnd_program.remove_from_group(program_short_name => 'XXCDS_HREXT002_EMP_RECT_CP', -- Program Short Name program_application => 'XXCDS', -- Application Short Name request_group => 'XXCDS Audit Request Group', -- Request Group Name group_application => 'XXCDS'); -- Application Short Name dbms_output.put_line('Concurrent Program has been removed from request group Successfully '); COMMIT; EXCEPTION WHEN NO_DATA_FOUND THEN dbms_output.put_line ('Concurrent Program has already been removed from the Request group'); WHEN OTHERS THEN dbms_output.put_line ('Others Exception Removing Conc Program. ERROR:' || SQLERRM); END; / SHOW ERROR SPOOL OFF

How to add the Request Set to a Request Group

SET SERVEROUTPUT ON spool /tmp/XXCDS_HRXXXXX_ADD_RG.TXT WHENEVER SQLERROR EXIT FAILURE ROLLBACK BEGIN fnd_set.add_set_to_group (request_set => 'FNDRSSUB1817', -- Request Set Code set_application => 'XXCDS', -- Application Code Short Name request_group => 'XXCDS Audit Request Group', -- Request Group Name group_application => 'XXCDS'); -- Application Code Short Name dbms_output.put_line('Request Set has been attached to Request Group Successfully '); COMMIT; EXCEPTION WHEN DUP_VAL_ON_INDEX THEN dbms_output.put_line ('Request Set is already available in the Request group'); WHEN OTHERS THEN dbms_output.put_line ('Others Exception adding Request Set. ERROR:' || SQLERRM); END; / SHOW ERROR SPOOL OFF

How to Remove/End Date a Responsibility assigned to the User in Oracle Apps

DECLARE

     v_user_name                   VARCHAR2 (100) := 'TEST_USER';

     v_responsibility_name   VARCHAR2 (100) := 'System Administrator';

     v_application_name        VARCHAR2 (100) := NULL;

     v_responsibility_key       VARCHAR2 (100) := NULL;

     v_security_group            VARCHAR2 (100) := NULL;

BEGIN

   SELECT fa.application_short_name,

                 fr.responsibility_key,

                 frg.security_group_key,

                 frt.description

       INTO v_application_name,

                 v_responsibility_key,

                 v_security_group,

                 v_description

     FROM fnd_responsibility fr,

                 fnd_application fa,

                 fnd_security_groups frg,

                 fnd_responsibility_tl frt

   WHERE fr.application_id     = fa.application_id

        AND fr.data_group_id        = frg.security_group_id

        AND fr.responsibility_id    = frt.responsibility_id

        AND frt.LANGUAGE            = USERENV ('LANG')

        AND frt.responsibility_name = v_responsibility_name;

 

  fnd_user_pkg.delresp (username => v_user_name,

                                            resp_app => v_application_name,

                                            resp_key => v_responsibility_key,

                                            security_group => v_security_group);

  COMMIT;

  dbms_output.put_line ( 'Responsiblity ' || v_responsibility_name || ' is removed from the user '                                            || v_user_name || ' Successfully' );

EXCEPTION

    WHEN OTHERS THEN

         dbms_output.put_line ( 'Error encountered while deleting responsibilty from the user and                                                    the error is ' || SQLERRM );

END;

Source: Thanks for Sharing

Error "Each row in the Query Result Columns must be mapped to a unique Query Attribute in Mapped Entity columns" while extending a VO

I was trying to extend the seeded iProcurement VO “ReqsApprovalsVO” with out adding any custom attributes.

When I clicked “Next” button on the Step 4/7 (Attribute Mappings), I hit this roadblock which keeps saying “Each row in the Query Result Columns must be mapped to a unique Query Attribute in Mapped Entity columns” and does not let me extend the VO after this.

I thought of several reasons which could be causing this error. I thought it had something do with the file version of the seeded VO I am trying to extend or it could be due to the jDeveloper version I am using.

I ruled out all the possibilities one by one including the jDeveloper issues. Then I looked in metalink and one of the notes gave me a little clue which would solve my issue.

Source: Metalink Note: 1524622.1

I went back to the seeded VO to see if any of the attributes are having this issue. Right Click on “ReqsApprovalsVO” à Edit ReqsApprovalsVO

I found this attribute OrgId which is “Mapped to Column or SQL” and has the Query column as “OrgId”

When I verified the SQL Statement for this VO, OrgId attribute has been pulled as “Org_Id” in the query which is not same as “OrgId” and this explains me why the error has been occurring when I am trying to extend the VO.

To resolve the issue, I changed the OrgId to ORG_ID in the seeded VO and was able to extend the VO there after.