In the part1 in this series, we showed how you can identify the top running maps in a load plan. In this blog, we list certain parameter/settings at...
In the part1 in this series, we showed how you can identify the top running maps in a load plan. In this blog, we list certain parameter/settings at ODI/Database/Network level that can influence the overall load plan timings. ODI Settings 1) Check the number of parallel sessions configured against the ODI agent. Recommendation is to have NOT more than 5 ODI sessions configured to run in parallel. If your server is not sized up properly, this may have to be reduced further....
In the part1 in this series, we showed how you can identify the top running maps in a load plan. In this blog, we list certain parameter/settings at ODI/Database/Network level that can influence the...
Once in a while, there might be a need to change some of the passwords of the system users in OBIA. These could include the BIAppsSystemUser or the database...
Once in a while, there might be a need to change some of the passwords of the system users in OBIA. These could include the BIAppsSystemUser or the database passwords for the BIAPPS warehouse. BIAPPS 10.2 version users can follow the instructions as mentioned in this MOS tech note. OBIA 11g: How to change the system account passwords in BI Applications (Doc ID 2264922.1) If you are on older versions of BIAPPS, you can refer to this document instead OBIA 11g: Installing Oracle...
Once in a while, there might be a need to change some of the passwords of the system users in OBIA. These could include the BIAppsSystemUser or the database passwords for the BIAPPS warehouse. BIAPPS...
Authors: "Yadukrishna Munugoti - Oracle " and "Guna Vasireddy - Oracle" The blog1 and blog2 in this series provided steps on how to get Fusion Flexfields into...
Authors: "Yadukrishna Munugoti - Oracle " and "Guna Vasireddy - Oracle" The blog1 and blog2 in this series provided steps on how to get Fusion Flexfields into BIAPPS. This blog, the third in this series, details some common issues you might encounter when doing so and how to resolve those issues. ODI-40444: Column not found:XXXXXXXXXXXXXXXXXX After doing the required configuration to get the Fusion Flexfields into BIAPPS, you might encounter the ODI-40444: Column not found...
Authors: "Yadukrishna Munugoti - Oracle " and "Guna Vasireddy - Oracle" The blog1 and blog2 in this series provided steps on how to get Fusion Flexfields into BIAPPS. This blog, the third in...
In OBIA, the normal process would be to use OBIACM to generate the load plan then schedule it. However at times, customers report issues with regards to load...
In OBIA, the normal process would be to use OBIACM to generate the load plan then schedule it. However at times, customers report issues with regards to load plan schedules. This blog explains why such things are likely to happen and how to resolve them Symptoms Observed: Duplicate Load plan schedules, so the same load plan running multiple times. However only one schedule visible in OBIACM Schedule not visible in OBIACM but load plan running daily as if it were scheduled...
In OBIA, the normal process would be to use OBIACM to generate the load plan then schedule it. However at times, customers report issues with regards to load plan schedules. This blog explains...
How to handle BIAPPS ETL failures due to duplicate data issues in Oracle DW Author: Amit Kothari Sometimes there are duplicate data rows in the source tables,...
How to handle BIAPPS ETL failures due to duplicate data issues in Oracle DW Author: Amit Kothari Sometimes there are duplicate data rows in the source tables, due to this while running a ODI Load Plan (LP) in BI Applications 11.1.1.7.1 the ODI sessions may error out while creating the unique indexes. It is always recommended that the source data issues be fixed first but that may not be feasible sometimes or you may just want to fix the data in the warehouse and continue with...
How to handle BIAPPS ETL failures due to duplicate data issues in Oracle DW Author: Amit Kothari Sometimes there are duplicate data rows in the source tables, due to this while running a ODI Load Plan...