Monday, December 1, 2014




ODI-17501: Temporary table has no column



When trying to create an interface and get the data into temp table getting this error


To fix the issue open the interface and check Active Mapping check box 


And select either execute on Source, Staging or on target depending on your requirement and re-run the Interface



Sunday, March 16, 2014

Change ODI Studio logging Level to Debug ODI Studio Client


Change ODI Studio logging Level to Debug ODI Studio Client


Path to ODI Studio Log file :

C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\client\odi\bin\ODI-logging-config.xml

To get More Detail Log Levels in ODI Studio Client change the XLM from











TO


Trimming the BIAPPS RPD


Trimming the BIAPPS RPD



Step 1: Open CMD  the run bi-init.cmd

PATH: <MiddlewareHome>\instances\instance<n>\bifoundation\OracleBIApplication\coreapp
lication\setup


Step 2: In a Command prompt window, run ExtractProjects

PATH: <Oracle Home for BI>\bifoundation\server\bin.

Step 3: Run following command
ExtractProjects -B input_rpd -O output_rpd -I "project_name1" -I "project_
name2"-I "project_name3" (and so on)

MY Client Specific:

ExtractProjects -B C:\Users\Local\Desktop\OracleBIApps_BI0002.rpd -O C:\Users\Local\Desktop\OracleBIAppsTrimmed.rpd -I "Fusion Compensation Management Transactional Analysis" -I "Fusion Financial Control and Reporting Transactional Analysis" -I "Fusion Financials Transactional Analysis" -I "Fusion Incentive Compensation Transactional Analysis" -I "Fusion Innovation Management Transactional Analysis" -I "Fusion Marketing Transactional Analysis" -I "Fusion Materials Management and Logistics Transactional Analysis" -I "Fusion Order Orchestration Transactional Analysis" -I "Fusion Partner Transactional Analysis" -I "Fusion Procurement Transactional Analysis" -I "Fusion Product Management Transactional Analysis" -I "Fusion Projects Transactional Analysis" -I "Fusion Sales Transactional Analysis" -I "Fusion Workforce Deployment Transactional Analysis" -I "Fusion Workforce Development Transactional Analysis" -I "Manufacturing Analytics" -I "Student Information Analytics" -I "Marketing Analytics Fusion Edition"

Save and rename the trimmed RPD. 

Make sure the name identifies this RPD as one that has been trimmed, for example, OracleBIAppsTrimmed.rpd.