Sunday, 8 July 2018

Oracle Workflow Compilation Steps

-----Workflow Compilation Command----

Step 1: Upload Workflow file respective Top for customized component it will be custome top.
-----------------------
Seeded Workflow Files Location
You can also download seeded workflow definition files directly from below directory-

$<Application_TOP>/patch/115/import/<LANG>

For example- Account Payables workflow file can be found at-
$AP_TOP/patch/115/import/US



Step 2: Set Environment
------------------------
cd /appl/atulorc/apps/apps_st/appl/

ls *.env

 . APPSatuldb_testof.env


Step 3: Based on requirement we have to upgrade/upload and force compilation command used.
-------------------------------------------------------------------------------------------
WFLOAD Command to upload Oracle Workflow
 
To upgrade-- WFLOAD apps/pwd 0 Y UPGRADE file.wft

    To upload-- WFLOAD apps/pwd 0 Y UPLOAD file.wft

    To force-- WFLOAD apps/pwd 0 Y FORCE file.wft

    To download-- WFLOAD apps/pwd 0 Y DOWNLOAD file.wft ITEMTYPE1 [ITEMTYPE2 ...ITEMTYPEN]


For Example-
WFLOAD apps/passed123@DEVL 0 Y UPLOAD APEXP_TEMP.wft









Oracle Form Compilation Steps

Step 1:Goto APPL Directory.

cd /appl/atulorc/apps/apps_st/appl/

Step 2: Set Environment Variable.

ls *.env

 . APPSatuldb_testof.env

Setp 3: Goto AU_TOP

 cd /appl/atulorc/apps/apps_st/appl/au/12.0.0/forms/US

Upload form on following path

/appl/atulorc/apps/apps_st/appl/au/12.0.0/forms/US

upload .fmb here

Step 4: Execute below command

Compilation Command;

frmcmp_batch $AU_TOP/forms/US/XX_VENDOR.fmb Userid=apps/welcome output_file=$XXCUS_TOP/forms/US/XX_VENDOR.fmx

Oracle Web ADI Form Error: Desktop Integration Manager is not a valid responsibility for the current user. Please contact your System Administrator.

Error: Desktop Integration Manager is not a valid responsibility for the current user. Please contact your System Administrator.

Online Link: http://mandeeporacle.blogspot.com/2014/05/xxx-is-not-valid-responsibility-for.html



This is happening because middle tiers has yet to pick the change in assigned responsibility. To resolve this issue we need to clear the middle tier cache.

Step 1:Navigate to Functional administrator>Core Service >Caching Framework > Global Configuration

Step 2: Click on Clear All Cache

Step 3: Try It again.