need to reset Oracle concurrent manager profile values to process another set of books without changing RESPONSIBILITY
Posted: 04 November 2008 10:56 PM
Newbie
Rank
Total Posts:  4
Joined  2007-11-26

I am working on oracle apps 11.5.10.2 , running an oracle report under responsibility, ‘GLOBAL INTERFACE OPERATOR’,

need to reset Oracle concurrent manager profile values to process another set of books. I need to change set_of_books_id for multiple runs of an Oracle ‘seeded’ report in one request set. I have a procedure that attempts this and works unless the report is running against project data. The program unit being executed is APXIIMPT_PC.

What profile values do I need to alter other than apps.Fnd_profile_option_values.PROFILE_OPTION_VALUE and fnd_responsibility.RESPONSIBILITY_KEY = org_id ?

profile_option_value was altered in the following manner.

WHEN 'HR: SECURITY PROFILE'
          THEN
                 SELECT S.SECURITY_PROFILE_ID
                   INTO g_profile_option_value
                   FROM PER_SECURITY_PROFILES S,
                   PER_BUSINESS_GROUPS   O
                  WHERE O.BUSINESS_GROUP_ID (+) = S.BUSINESS_GROUP_ID
                   AND S.ORGANIZATION_ID IS NULL
                   AND S.BUSINESS_GROUP_ID = P_ORG_ID   -- 6
                    ;
 WHEN 'HR:BUSINESS GROUP'
              THEN
                 SELECT O.business_group_id
                   INTO g_profile_option_value
                   FROM PER_SECURITY_PROFILES S,
                   PER_BUSINESS_GROUPS   O
                  WHERE O.BUSINESS_GROUP_ID (+) = S.BUSINESS_GROUP_ID
                   AND S.ORGANIZATION_ID IS NULL
                   AND S.BUSINESS_GROUP_ID = P_ORG_ID   -- 6
                    ;
 WHEN 'HR:ORGANIZATION ID'
              THEN
                 SELECT O.business_group_id
                   INTO g_profile_option_value
                   FROM PER_SECURITY_PROFILES S,
                   PER_BUSINESS_GROUPS   O
                  WHERE O.BUSINESS_GROUP_ID (+) = S.BUSINESS_GROUP_ID
                   AND S.ORGANIZATION_ID IS NULL
                   AND S.BUSINESS_GROUP_ID = P_ORG_ID   
                    ;
 WHEN 'GL SET OF BOOKS ID'
              THEN
                 SELECT DISTINCT SET_OF_BOOKS_ID
     INTO   g_profile_option_value
     FROM     DISCMAN.ORG_ORGANIZATIONS
     WHERE  ORG_ID = P_ORG_ID
     AND ROWNUM < 2
                 ;

WHEN 'GL SET OF BOOKS NAME'
           THEN
                 SELECT DISTINCT ORGANIZATION_NAME
                 INTO   g_profile_option_value
     FROM     DISCMAN.ORG_ORGANIZATIONS
     WHERE  ORG_ID = P_ORG_ID
     AND ROWNUM < 2
                 ;
WHEN 'MO: OPERATING UNIT'
              THEN
                 SELECT DISTINCT ORGANIZATION_NAME
     INTO   g_profile_option_value
     FROM     DISCMAN.ORG_ORGANIZATIONS
     WHERE  ORG_ID = P_ORG_ID
     AND ROWNUM < 2
                 ;
 Signature 

wrwelden

Profile