Navigate to the Execute page. In the Execution Plans tab, click on the New tab.

Enter the name Custom_R12_Financials. Check 'Full Load Always' and 'Drop/Create Indices' box. Uncheck 'Analyze' box. Click Save

Click the Subject Areas tab, click Add/Remove icon

Click Query

Enter a new query for Name = Financials%, click Go

Click 'Add All' to select all the subject areas

Click OK to return to Choose Subject Areas screen

Click OK

In the Parameter tab, click 'Generate'

Click Yes to proceed

Screen shows the progress

Click OK to set the new values for Execution plan parameters

Use the dropdown box in Value column to set the values for the parameters

Execution parameters value
SDE_ORAR12_Adaptor : SDE_ORAR12_Adaptor
SILOS: SILOS
PLP: PLP
DBConnection_OLAP: DataWarehouse
DBConnection_OLTP: ORA_R12
FlatFileConnection: ORA_R12_flatfile
Click Save

From Execution Plans, click Build to build to the Execution Plan.

Click OK for Selected record only

Screens shows the progress

Check both 'Enable batch mode' and 'Generate All Dependencies' box. Click OK

Once completed, click OK

Comments
Post a Comment