ODI – Session Logs

To view a specific session log file:

  1. Log into Fusion Applications Control.
  2. From the navigation pane, expand the farm, and then ODI.

    The Master Repository page displays.

  4. From the Agents section, from the Running column (Running column), click the number for the agent with the session to search the sessions, for example, FusionCrmOdiAgent

    The Search Sessions page displays.

  5. On the Search Sessions page, in the Sessions section, locate the session number corresponding to the job. Notice that while the session has a value in the Begin Date column, it does not have a value in the End Date column.
  6. Click the session number corresponding to the job.

    You are prompted to log in to the ODI Console.

  7. From the Repository list, choose Work Repository.
  8. Enter the credentials, and then click Sign In.
  9. On the Session page, in the Execution Statistics section, note the values for the Session ID and Session Name in the Definition section, and the time of session in the Execution Statistics section.
  10. Expand the Relationships and view the steps in the Session Steps tab.
  11. For a step that did not successfully complete, click the link in the Step Name column to perform a deeper analysis.
  12. On the Step page, expand the Relationships and view the tasks for the step in the Session Tasks tab.

    Description of odisessiontask.jpg follows

  13. For a step that did not successfully complete, click the link in the Step Name column to perform a deeper analysis.
  14. On the Session Task Detail page, review the Message field in the Execution Statistics section and the Target Command command in the Target Details section for errors.

    Description of odisessiondetail.jpg follows


India – Goods and Services Tax(GST) Overview

Goods and Services Tax(GST) is a destination based tax applicable for supply of goods and services or both administered concurrently by the Center and State Governments through out the value chain except:

  • Exempted goods and Services => Very few items with common list for CGST and SGST.

Find below the quick snapshot of the proposed GST Structure:

Following 3 new tax types got proposed in GST:
CGST (Central Goods and Services Tax)
SGST (State Goods and Services Tax)
IGST (Integrated Goods and Services Tax)

GST Rates are based on Revenue Neutral Rates. Following are the proposed rate types and the rates are not yet finalized as on the blog posted date:

1. Merit rate => For essential goods and services.
2. Standard rate => For goods and services in general.
3. Special rate => For precious metals and for specified goods and services.
4. Zero rate => For exports, supply to EOU/SEZ etc.

Goods and Services outside the purview of GST:

  • Alcohol for Human consumption =>  will continue with State Excise and VAT
  • Electricity => will continue with Electricity Duty
  • Petroleum Products => will continue with the current tax structure, likely to be brought under GST regime later
  • Tobacco products expected to be taxed under the GST regime along with Excise dutyGoods and Service Tax

GST is considered the largest indirect tax reform in India and will replace multiple indirect taxes that are administered by the Central and State Governments.

The Goods and Services Tax Network (GSTN), has been tasked by the Government of India with building and maintaining the centralized, national level government IT infrastructure required for GST.

In reference to the Government of India’s roll out of the Goods and Services Tax (GST) planned for April 2017, the Oracle E-Business Suite (EBS) team has already put a plan in place and the details of the same shall be shared shortly in the next post.

EBS: Oracle Financials for India(OFI) – India Localization GST Update

The EBS India GST Information Center is now available on My Oracle Support. This information center is the central source for EBS information on India GST including:
  • Functional scope summary
  • Order to Cash Setup
  • Order to Cash User Guide
  • Purchase to Pay Setup
  • Purchase to Pay User Guide
  • Early access — information on early access to phased software updates information on requirements, limitations and how to register to request access.
Troubleshooting guides and FAQs:  These will accumulate with time based on customer and partner interaction.
The EBS India GST Legislative Update document has also been updated to let customers and partners know the info center is now available.

You may please register your request for early access through  EBS India GST Information Center.

Oracle Assets – Difference Between Amortized and Expensed Adjustments

Just thought of sharing this information as in my blog i am getting this query again and again —

When you perform a financial adjustment on an asset such as a cost adjustment, a depreciation method change, or a date placed in service change, the effect that the adjustment will have depends on whether the adjustment is expensed or amortized.

If the transaction is an Expensed Adjustment, the effect of the adjustment will be from the Date Placed In Service (DPIS) of the asset.  Oracle Assets recalculates depreciation using the new information starting from the DPIS and derives the expected depreciation. The expected depreciation reserve will be compared with the existing depreciation reserve of the asset and any excess or deficit amount will be accounted in the period in which the adjustment is done.

If you want the adjustment to be effective from a specific period and not from the DPIS, the transaction needs to be an Amortized Adjustment.  For amortized adjustments, the effect of the adjustment will be from the period in which the amortization start date falls and the accumulated depreciation prior to the amortization start date will not be re-validated.  When an amortized adjustment is performed, Oracle Assets spreads the adjustment amount over the remaining life or remaining capacity of the asset.

Note that once an asset has an amortized adjustment, it is no longer possible to perform an expensed adjustment on that asset.

How do you perform an Expensed or an Amortized adjustment?

While performing the transaction, whether it is expensed or amortized depends on these selections:



Here is an example of how expensed and amortized adjustments work:

Let’s take an asset that has these parameters:
Cost = 12000
DPIS = 01-JAN-2016
Depreciation method and life = STL for 12 months
In the Aug-16 period, the life is changed to 15 months.

If the adjustment is expensed:

The depreciation, with an asset life of 12 months, would be 12000 / 12 = 1000 per month.
The depreciation, with an asset life of 15 months, would be 12000 / 15 = 800 per month.
Until the Aug-16 period, the asset was depreciating based on a life of 12 months.  The existing depreciation reserve of the asset is 1000 * 7 months = 7000.
Based on the new life, the accumulated depreciation should be 800 * 7 months = 5600.
The depreciation catch-up in Aug-16 is 7000 – 5600 = (1400).
From the Aug-16 period onwards, the monthly depreciation for the asset will 800.

Now, if that adjustment is amortized:

The depreciation, with an asset life of 12 months, would be 12000 / 12 = 1000 per month.
The depreciation reserve amount charged up to Aug-16 is 1000 * 7 months = 7000.
So, the net book value of the asset as of Aug-16 is 12000 – 7000 = 5000.
The remaining life of the asset as of the Aug-16 period is:  Total life – life already completed = 15 months – 7 months = 8 months.
From the Aug-16 period onwards, the monthly depreciation for the asset will be Net Book Value / Remaining Life = 5000 / 8 months = 625.

Comments and Suggestions most welcome.



Oracle Data Integrator (ODI) Now Available

We are pleased to announce a new release to Oracle Data Integrator (ODI):

Oracle Data Integrator (ODI) provides a flexible and heterogeneous data integration platform for data processing that enables you to transform, enrich, and govern data for faster, more informed decision-making. In this release of Oracle Data Integrator, we have further extended our capabilities in 4 major areas: Big Data, Cloud, Lifecycle Management and Developer Productivity. Cloud and Big Data remain key investment areas and ensure that Oracle Data Integrator will continue to accompany customers throughout their technological transformation. Please visit the following two links for more information on Oracle Data Integrator (OD): ODI OTN Page, O.com Data Integration Page.

Big Data investments include Spark Streaming support, Apache Kafka and Apache Cassandra support, enhanced support around Hadoop Complex Types and Storage Formats in addition to enhancements to ODI’s Big Data Configuration Wizard. Through its unique decoupling of the Logical and Physical design of Mappings, Oracle Data Integrator is the only Data Integration tool on the market giving developers the flexibility to design Mappings with a generic business logic and then generate code for as many data processing technologies (Hive, Spark, Spark Streaming etc.) as they want. This provides a great platform for the ever changing and improved world around Big Data.


Cloud investments include RESTful Service support, where Oracle Data Integrator can now invoke RESTful Service. Data chunking and pagination are also supported for uploading or downloading larger payloads. Additionally, Business Intelligence Cloud Service (BICS) Knowledge Modules is now supported out of the box in Oracle Data Integrator. You can define Business Intelligence Cloud Service connectivity in Topology, reverse engineer metadata and load data into it just like any other target data server.

Lifecycle Management investments include Git Support as an external version control system. Other improvements to the overall lifecycle management functionality have been made, such as the enhanced merge capability with auto-merging of changes and simplified conflict resolution.


Developer Productivity investments include a superior Knowledge Module Framework that helps maximize flexibility and minimize maintenance. You can now inherit steps from a Knowledge Module into another Knowledge module and override steps like in object oriented programming languages. There are brand new template languages and syntaxes introduced providing greater control over the generated code.

For the full review of new functionality, please view the following What’s New Whitepaper.

Troubleshooting Essbase Agent Hangs on Windows Systems

The following steps should be taken when the Essbase Agent is in a hung/unresponsive state.  Recovery from the hang may result in a corrupt security file.  This Guide addresses periodically backing up the Security file.

There are 4 different areas that are covered:

  • Setting the debug for logs.
  • Taking mini dumps during the hang.
  • Taking java dumps.
  • Rebooting the machine.

Note – This is based on Essbase v11.1.2.x, however, can be used with previous versions. The pathing for files/logs will be different.

1. In the /Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/essbase.cfg file, add the following parameters:


2. In the /Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/logging.xml file in the section:

– <logger name=”oracle.EPMCSS” level=”NOTIFICATION:32″ useParentHandlers=”false”>
<handler name=”epmcss-handler” />


– <logger name=”oracle.EPMCSS” level=”TRACE:32″ useParentHandlers=”false”>
<handler name=”epmcss-handler” />

3. Restart Essbase after the changes have been made.

On the next occurrence of an Essbase agent or application hang:

1. Using ESSCMD or MaxL, try logging into the Essbase Agent. If there is no response from the Agent, it will appear to “hang”. Do not close this window.

2. Take a dump of the ESSBASE process:


b. Under the tab for PROCESSES select ESSBASE.exe process.

c. Make note of the Process ID (pid) that the ESSBASE.exe process is running on. If not displayed, Select View -> Select columns from the menu bar. Check PID (Process Identifier).

d. Right-click on ESSBASE.exe and select “Create Dump File”. When the dump is complete, it will show the path and filename of the dump file, for example C:\Users\EPMAdmin\AppData\Local\Temp\1\ESSBASE.dmp.

e. Repeat the above process for each ESSSVR.exe process. (Only needed for application hangs).


3.  Take  a Java dump of the ESSBASE process. (NOTE: Information taken from external site: https://access.redhat.com/solutions/19170)

After each ESSBASE dump file creation, get an Essbase Java stack trace:

a. Download PsTools from https://technet.microsoft.com/en-us/sysinternals/bb897553.aspx and extract it. This file contains the PsExec utility.

b. Run the following in a cmd window from the location where you extracted PsExec (On Windows 2012, use “Run as administrator” to open the cmd window.)

PsExec.exe -s \Oracle\Middleware\jdk{version}\bin\jstack.exe -l {ESSBASE|ESSSVR process ID} > c:\temp\jstack_{pid}.txt

For example, if the ESSBASE process is run on process ID 3816:

PsExec.exe -s F:\Oracle\Middleware\jdk160_35\bin\jstack.exe -l 11196 > c:\temp\jstack_11196.txt

4. Check the MaxL/ESSCMD window. If the login is still not responding, repeat step 2-3 more couple of times with interval of 1-2 minutes. On each run, the ESSBASE.dmp filename will append so existing files will not be overwritten, for example, , ESSBASE (2).dmp, ESSBASE (3).dmp.

5. Note exact time of occurrence.

Attach the following:

Essbase.dmp files (should be 3)
jstack_{pid}.txt files (should be 3)
ESSBASE.log and ESSBASE_ODL.log with debug level messages.
application.log (if needed)


After dump files have been attached:

2. Start killing the ESSSVR processes, noting the PID as you kill them and checking the MaxL/ESSCMD Window after each. If killing the PID allows you to login, attach the log from that ESSSVR (application) process. The ESSSVR PIDs are located in the essbase.log. For example:

Application [Sample] started with process id [1928]


Other Windows 32-bit machines:

Install the following debugging tool on the Essbase server and run it against the ESSBASE.exe and ESSSVR.exe processes.  The debugger can be downloaded from Microsoft:

After installing, from a ‘cmd’ window change to the x64 directory.  For example, C:\Tools\userdump8.1\x64.

1. Create the following directories on the same drive where the tool was installed.  These are for the output files:


2. Run the following command:

userdump essbase.exe .\minidumps_1\essbasedmp1.mdmp
userdump esssvr.exe .\minidumps_1\esssvr1.mdmp

3.  Wait 5 minutes and run the dumps a second time, changing the output directory:

userdump essbase.exe .\minidumps_2\essbasedmp2.mdmp
userdump esssvr.exe .\minidumps_2\esssvr2.mdmp

4.  Wait 5 minutes and run the dumps a third time, changing the output directory:

userdump essbase.exe .\minidumps_3\essbasedmp3.mdmp
userdump esssvr.exe .\minidumps_3\esssvr3.mdmp

5.  Attach the following files to the Service Request:

  • All memory dump files from above commands, zip up each directory to separate files.
  • All application logs that were active at time of hang. These are located in the C:\Oracle\Middleware\user_projects\epmsystem2\diagnostics\logs\essbase\essbase_0\app\{appname} folder.
  • The Essbase Agent log, located in C:\Oracle\Middleware\user_projects\epmsystem2\diagnostics\logs\essbase\essbase_0\essbase.log.
  • The environment variables used.  From a ‘cmd’ window, type the following command, attach the envvars.txt file:
set > envvars.txt
  • The Essbase Configuration File, essbase.cfg, located in the C:\Oracle\Middleware\user_projects\epmsystem2\EssbaseServer\essbaseserver1\bin folder.
  • The Shared Services logs, SharedServices_Security_Client.log.  This file is usually located in C:\Oracle\Middleware\user_projects\epmsystem2\diagnostics\logs\essbase\essbase folder.


1.  Before rebooting the system, bring up the Services Console:

  • select START -> RUN
  • type services.msc

2.  Locate the Essbase Server process, i.e. opmn_EPM_epmsystem2.

3.  Right click and select Properties.

4.  Change the Startup Type to Manual.

5.  Reboot the machine.

6.  Before starting Essbase, restore the last security file that was backed up in the Section “Backing Up The Essbase Security File”.

7.  Go back to the Services Console and start the Essbase service.

8.  Reset the service Startup Type to Automatic.



Smartview Essbase client support with SSL

Does Smartview Essbase client support SSL?

Yes it does.

If you want to use an Essbase client with SSL, then you can use the Smartview client which supports SSL.

You need to configure the SmartView client to connect via HTTPs to the Analytic Provider Services (APS).

APS will access Essbase on secure port.



FDM Error “Unable To Load The JVM” When Importing Data From ERPI

This error generally occurs when you apply a patch to upgrade your EPM to

In Financial Data Quality Management (FDM) the following error message is displayed during import from ERPI:

Unable to load the JVM.

The data load in ERPi runs without issue.

The main reason it occurs is as during the patch installation the Java Virtual Machine (JVM) path to the ERPICOMJNIBridge has not been updated correctly.

so as to fix this issue Reconfigure the FDM Load Balancer. This will configure and register the JVM path.


How to Launch Essbase Calculation Manager Rules Using the Command Launcher

To launch the Command launcher you need to call Java to call the calcmgrCmdLine.jar and then add the parameters needed to launch the rule:

java -jar calcmgrCmdLine.jar http://machinename:port username password Application Database rulename

You can launch the command like this:

C:\Oracle\Middleware\jdk160_35\bin\java -jar calcmgrCmdLine.jar http://servername:19000 admin password Sample Basic PROMPT

You can also create your own bat file that calls the .jar so all you have to do is add the parameters.

Create a file called CmdLauncher.bat
Add the following into the file:

C:\Oracle\Middleware\jdk160_35\bin\java -jar “C:\Oracle\Middleware\EPMSystem11R1\common\calcmgr\\lib\calcmgrCmdLine.jar” %1 %2 %3 %4 %5 %6

This can be copied on the desktop or anywhere on the machine as the paths are hard coded.