Responsibilities Assigned to User.

-- Query To find Responsibilities Assigned to User.

    SELECT fu.user_name                "User Name",
       frt.responsibility_name     "Responsibility Name",
       furg.start_date             "Start Date",
       furg.end_date               "End Date",     
       fr.responsibility_key       "Responsibility Key",
       fa.application_short_name   "Application Short Name"
  FROM apps.fnd_user_resp_groups_direct        furg,
       applsys.fnd_user                   fu,
       applsys.fnd_responsibility_tl      frt,
       applsys.fnd_responsibility         fr,
       applsys.fnd_application_tl         fat,
       applsys.fnd_application            fa
 WHERE furg.user_id             =  fu.user_id
   AND furg.responsibility_id   =  frt.responsibility_id
   AND fr.responsibility_id     =  frt.responsibility_id
   AND fa.application_id        =  fat.application_id
   AND fr.application_id        =  fat.application_id
   AND frt.language             =  USERENV('LANG')
   AND UPPER(fu.user_name)      =  UPPER('SLAKKIREDDY')  -- <change it>
   -- AND (furg.end_date IS NULL OR furg.end_date >= TRUNC(SYSDATE))
 ORDER BY frt.responsibility_name;

Enable/Disable the Concurrent Program Parameters

HI Friends,

Here is the requirement.

1. I want to enable/disable concurrent program parameter based on other parameter value. Ex : If value for parameter1 is "Summary" i have to enable the parameter2 and if the value for parameter1 is "Detail" i have to disable the parameter2.

2. If user user select "Summary", i have to display the pop message, saying the "Please enter value for parameter2"

Step 1:

Create independent value set  "PARA_1" set for first parameter.

Step 2: Create one hidden dummy parameter (PARA_2 ) and create NONE value set and enter default value as

select decode(:$FLEX$.PARA_1,'Summary','Summary',null) from dual

Step 3:

Create third parameter which depends on value of first parameter.

For third parameter,create table value set and enter below condition in Where/Order By Clause.

WHERE :$FLEX$.PARA_2 = 'Summary'

Now test your concurrent program.

Step 4 : To Display Popup Message.

a). Create one dummy parameter.
b). Create special value set and attach this to parameter.
c). Pass some dummy constant value to parameter.

FND PLSQL "declare
begin
  if ':$FLEX$.PARA_1:NULL' = 'Summary' AND ':$FLEX$.TEST_9:NULL' IS NULL  THEN
  fnd_message.set_name( 'FND', 'FND_GENERIC_MESSAGE' ) ;
  fnd_message.set_token( 'MESSAGE', 'Enter Value for parameter 3' ) ;

 fnd_message.raise_error ;
  end if ;
END ;"

Now test your concurrent Program.

Issues With Profile Values Retrieving

Hi Friends,

Today i came across one issue.

i have changed the profile value "Concurrent:Report Copies" from 0 to 1 and i am trying to retrieve the profile value by using  select  fnd_profile.value('CONC_COPIES') from dual; . But still sql query is showing old value as 0.

Solution : Once after updating the profile value, open new toad session to get latest value.

How to cancel Scheduled Concurrent Programs

Use below query to cancel scheduled concurrent programs.

UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code IN ('Q','I')
AND requested_start_date > SYSDATE
AND hold_flag = 'N';

COMMIT;

LDT Files Generation Scripts

Hi,

Use the below commands to generat ldt files.

Concurrent Program:
-------------------------
$FND_TOP/bin/FNDLOAD apps/A4zRF5pg O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXHRPEN_PROG.ldt PROGRAM APPLICATION_SHORT_NAME="XXHR" CONCURRENT_PROGRAM_NAME="XXHRTOPEN"

$FND_TOP/bin/FNDLOAD apps/A4zRF5pg O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXBBHRPEN_PROG.ldt 
 

Multi Org Structure Table

Name :Business Group
Table :HRFV_BUSINESS_GROUPS
Profile:HR:Business Group ID
Column: BUSINESS_GROUP_ID

Name :Set Of Books
Table :GL_SET_OF_BOOKS
Profile:GL: Set of books name
Column: Set_of_book_id

Name :Legal Entity
Table :HR_LEGAL_ENTITIES


Name :Operating Unit
Table :HR_OPERATING_UNITS
Profile:MO:Operating Unit
Column:ORG_ID

Name:Inventroy Organization
Table:ORG_ORGANIZATION_DEFINITIONS
Column:ORGANIZATION_ID