SQL - Find Last accessed date of responsibility by USER

SELECT FU.USER_NAME,

  FRT.RESPONSIBILITY_NAME,

  MAX(FL.START_TIME),

  MAX(fl.login_id)

FROM FND_LOGINS FL,

  FND_LOGIN_RESPONSIBILITIES FLR,

  FND_USER FU,

  FND_RESPONSIBILITY_TL FRT

WHERE FL.LOGIN_ID         = FLR.LOGIN_ID

AND FL.USER_ID            = FU.USER_ID

AND FU.USER_NAME          ='OA_LEARNINIG'

AND FRT.RESPONSIBILITY_ID = FLR.RESPONSIBILITY_ID

GROUP BY FU.USER_NAME,

  FRT.RESPONSIBILITY_NAME

ORDER BY 3 DESC ;

PN –  System captures login date only from core forms. 

Additional Parameter Operating Unit in R12

You must have observed additional parameter (Operating Unit) option while running the concurrent program in R12. It's due to MOAC feature to run the program for selective OU only.

This additional parameter is controlled from System Administrator responsibility Self service version.

This post is to help how to pass value to this parameter if we are triggering such programs from database.

DECLARE
l_request_id  NUMBER;
BEGIN
           dbms_output.put_line('OAL - START::');
           FND_REQUEST.SET_ORG_ID(82); 
          -- This is required to set the value for additional Operating Unit Parameter

         l_request_id :=
         fnd_request.submit_request( 'APPLICATION_SHORT_NAME' ,'CPSHORTNAME' ,NULL ,NULL ,TRUE,Arg1,Arg2......);


           dbms_output.put_line('OAL - END::'|| l_request_id );

EXCEPTION
WHEN OTHERS THEN
      dbms_output.put_line('OAL - Exception ::'||SQLERRM);
END;