Wednesday, April 25, 2012

Query to find Responsibility for the Concurrent Program

SELECT frt.responsibility_name,
               frg.request_group_name,
               frg.description
  FROM fnd_request_groups frg
             ,fnd_request_group_units frgu
             ,fnd_concurrent_programs fcp
             ,fnd_concurrent_programs_tl fcpt
             ,fnd_responsibility_tl frt
             ,fnd_responsibility frs
 WHERE frgu.unit_application_id = fcp.application_id
 AND   frgu.request_unit_id = fcp.concurrent_program_id
 AND   frg.request_group_id = frgu.request_group_id
 AND   frg.application_id = frgu.application_id
 AND   fcpt.source_lang = USERENV('LANG')
 AND   fcp.application_id = fcpt.application_id
 AND   fcp.concurrent_program_id = fcpt.concurrent_program_id
 AND   frs.application_id = frt.application_id
 AND   frs.responsibility_id = frt.responsibility_id
 AND   frt.source_lang = USERENV('LANG')
 AND   frs.request_group_id = frg.request_group_id
 AND   frs.application_id = frg.application_id
 AND   fcp.concurrent_program_name = <shortname>
 AND   fcpt.user_concurrent_program_name LIKE <User concurrent program>



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

Wednesday, April 18, 2012

Oracle Apps R12 MOAC and its impact

Oracle R12 MOAC and its impact


Setup the Security Profile:
1.Create a Security Profile in HRMS Responsibility
    HRMS Manager>Security>Profile
    In this setup specify different Operating Units that you want to Access.

2.Run the Security List Maintenance
    This is a required step when you create a new Profile or modify existing one.


3.Setup the MO: Security Profile value to above created security profile.
     This "MO: Security Profile" Profile option has to be setup at the responsibility level.This will ensure that
     Responsibility will have access to the data of all the Operating units under the Security Profile.


Important profile option

MO: Security Profile:

MO: Operating Unit:
This comes from 11i and is still valid only its evaluated, if there is no value setup at MO:Security
Profile.

MO: Default Operating Unit
If the security profile is setup to access multiple operating units, this requires users to select
the Operating Unit every time user access the Sub ledger pages. To avoid this the Default Operating Unit profile can be setup.

How MOAC impacts the way we work in TOAD

11i
To set the Org id in TOAD
1. Get the Org_id from HR_ORGANIZATION_UNITS

2. In toad execute the below code
        begin
        fnd_client_info.set_org_context(&org_id);
        end;


To set the responsibility context in TOAD
1. Get the User id, Responsibility Id and Application id from Front end
    Help>Diagnostic>Examine and select BLOCK as "$PROFILES$" and then get the respective IDS

2. Using the IDs execute the below code in TOAD

      begin
      FND_GLOBAL.APPS_INITIALIZE(user_id in number,resp_id in number,resp_appl_id in
      number);
      end;

R12:
To set the Org id in TOAD
1. Get the Org_id from HR_ORGANIZATION_UNITS

2. In toad execute the below code
    --Sets the 201 as single Org id
    exec MO_GLOBAL.SET_POLICY_CONTEXT('S',201);
    Pass a value "S" in case you want your current session to work against Single ORG_ID
    Pass a value of "M" in case you want your current session to work against multiple ORG_ID's

To set the responsibility context and initiate MOAC in TOAD
1. Get the User id, Responsibility Id and Application id from Front end
     Help>Diagnostic>Examine and select BLOCK as "$PROFILES$" and then get the respective IDS

2. Using the IDs execute the below code in TOAD

       a. exec  FND_GLOBAL.INITIALIZE
          This will set your responsibility id, user_id etc

       b. call MO_GLOBAL.INIT('AR')
           This will read the MO profile option values for your responsibility/user, and will initialize the
           Multi Org Access.
        
MOAC for table access
In 11i _ALL Tables where non Org specific and Org specific views were created on these tables.
But in R12 its different concept
  a. For the table AP_INVOICES_ALL a synonym  AP_INVOICES_ALL is created in APPS.

  b. Also another synonym AP_INVOICES is created which refers to AP_INOICES_ALL.

  c. A Row Level security is applied to AP_INVOICES, using package function
      MO_GLOBAL.ORG_SECURITY.
     This can be double-checked by running SQL select * from all_policies where
      object_name='AP_INVOICES'

e. The effect of this policy is that,whenever you access AP_INVOICES, Oracle RLS will
    dynamically append WHERE CLAUSE similar to below

    SELECT * FROM AP_INVOICES
    WHERE EXISTS (SELECT 1 FROM mo_glob_org_access_tmp oa WHERE oa.organization_id =
     org_id)



at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,  
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database

Wednesday, April 4, 2012

Oracle Apps: LDT Commands


LDT Commands for Upload and Download of Programs:

Download
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXMLBEX.ldt PROGRAM APPLICATION_SHORT_NAME="XXTTY" CONCURRENT_PROGRAM_NAME="XXMLBEXPGAL"


Upload:
FNDLOAD apps/<appspwd> O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXMLBEX.ldt

--------------------------------------------------------------------------------------------------
Request group download for Specific Program
Download:
FNDLOAD apps/<appspwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXMREQ.ldt REQUEST_GROUP REQUEST_GROUP_NAME="All Project Billing Programs" UNIT_NAME="XXMLBEGAL"

--------------------------------------------------------------------------------------
Request Group (NEW request group creation)

Download:
FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_XXX_DTC_Request_Gr.ldt REQUEST_GROUP REQUEST_GROUP_NAME="ALL Programs" APPLICATION_SHORT_NAME="XX"

Upload:
FNDLOAD apps/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_XXX_DTC_REQUEST_GR.ldt

---------------
Oracle Menu (New Menu)

Download:
FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXX_DTC_GLOBAL_MENU.ldt MENU MENU_NAME="XXX_DTC_GLOBAL"

Upload:
FND_TOP/bin/FNDLOAD apps/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XXX_DTC_GLOBAL_MENU.ldt

--------------
Oracle Responsibility (New Responsibility)

Download:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XXX_DTC_GLOBAL_RESPO.ldt FND_RESPONSIBILITY RESP_KEY="XXX_DTC_GLOBAL"


Upload
FNDLOAD apps/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XXX_DTC_GLOBAL_RESPO.ldt

------------------------------------------------------

Lookup Type:

DownLoad:
FNDLOAD apps/pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_OA_STATUTORY_ACCT_MAPPING.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XX" LOOKUP_TYPE="XX_OA_STATUTORY_ACCT_MAPPING"

Upload:
FNDLOAD apps/<Pwd> 0 Y UPLAOD $FND_TOP/patch/115/import/aflvmlu.lct XX_OA_STATUTORY_ACCT_MAPPING.ldt

-------------

Value set only:

Download:
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

Upload:
FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

Value set with values:

Download:
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

Upload:
FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

----------------------------------------------------

Descriptive flex field

Download:
FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_OA_EXP_RPT_SEG_MAP_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="FND_COMMON_LOOKUPS" DESCRIPTIVE_FLEX_CONTEXT_CODE="XX_OA_EXP_RPT_SEG_MAP"

Upload:
FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_OA_EXP_RPT_SEG_MAP_DFF.ldt


----------------------------------------------------
Concurrent Program

Download:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXOAGLTSIMP_CONC.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="XXOAGLTSIMP"

Upload:
FNDLOAD <apps>/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXOAGLTSIMP_CONC.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="XXOAGLTSIMP"

Conc program assignment to Request Group

Download:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXOAGLTSIMP_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME=" DTC Global" APPLICATION_SHORT_NAME="XX" REQUEST_GROUP_UNIT UNIT_NAME="XXOAGLTSIMP"

Upload:
FNDLOAD <apps>/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXOAGLTSIMP_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME=" DTC Global" APPLICATION_SHORT_NAME="XX" REQUEST_GROUP_UNIT UNIT_NAME="XXOAGLTSIMP"
FNDLOAD <apps>/<apps> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_CW_EVAL_NOTIFY_CONC_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME="PO All Reports" APPLICATION_SHORT_NAME="PO" REQUEST_GROUP_UNIT UNIT_NAME="XX_CW_EVAL_NOTIFY"


---------------------------------------------------

Forms:

Download
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXFRMNAME.ldt FORM APPLICATION_SHORT_NAME="PN" FORM_NAME="XXFRMNAME"

Upload:
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afsload.lct XXFRMNAME.ldt

Functions:

Download
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXFUNNAME.ldt FUNCTION FUNC_APP_SHORT_NAME="PN" FUNCTION_NAME="XXFUNNAME"

Upload
FNDLOAD apps/apps O Y UPLOAD @FND:patch/115/import/afsload.lct XXFUNNAME.ldt

----------------------------------------------------

Form Personalization

Download:
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_PERWSHRG.ldt FND_FORM_CUSTOM_RULES function_name="PERWSHRG-404"

Upload:
FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXGLJOURNALIMP.ldt

----------------------------------------------------

FND Load for DFF Context

FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXAPdff_CUST_DECL.ldt DESC_FLEX APPLICATION_SHORT_NAME="SQLAP" DESCRIPTIVE_FLEXFIELD_NAME="AP_INVOICES" DFF_CONTEXT DESCRIPTIVE_FLEX_CONTEXT_CODE="CUST_DECL"

-----------------------------------------------------

FND Load for Messages

Donwload:
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_ICX_POR_LIFECYCLE_PAY_TIP.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='ICX' MESSAGE_NAME=XX_ICX_POR_LIFECYCLE_PAY_TIP
or for all messages
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_ALL_GMS_MESSAGES_00.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='XXGMS'

Upload:
FNDLOAD apps/$CLIENT_APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_ICX_POR_LIFECYCLE_PAY_TIP.ldt

-----------------------------------------------------

FND Load for Alert

Download
FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct Email_to_requestes_for_PO_Receipt.ldt ALR_ALERTS APPLICATION_SHORT_NAME='PO' ALERT_NAME=' Email to requestes for PO Receipt'

Upload
FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct Email_to_requestes_for_PO_Receipt.ldt

-----------------------------------------------------------------
XML Publisher Data Definition and Templates

a) To download all Templates defined for a particular Data Definition

FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ldt_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=[APPSHORTNAME] DATA_SOURCE_CODE=[DATADEFINITIONCODE]


b) To download for a particular Template and Data Definition

FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ldt_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=[APPSHORTNAME] DATA_SOURCE_CODE=[DATADEFSHORTCODE] TMPL_APP_SHORT_NAME=[APPSHORTNAME] TEMPLATE_CODE=[TEMPLATECODE]