How to find which SDE/SIL to Customize ?

November 30 0
Advertisement
I need to do a Type 1 Customization of adding a extra column from the Source System to Target DW Table in OBIA.
I am able to work out everything once i know which SDE/SIL Specifically to customize, however how to find out this one ?
I went through the OBIA Data Lineage Sheet which gives me multiple SDE/SILfor the same Target Table. Also i am able to see this from DAC that Multiple Tasks are listed for the same Table in most of the scenarios.
My question is how do we find out that one SDE/SIL only required for doing the Customization ? Or is my Understanding wrong here ?
Appreciate if someone can give me steps to identify the SDE/SIL required for doing customizations ?
Advertisement
When you have a case where multiple SDE or SILS are populating the same table, you need to understand the purpose of each one. Unfortunately, the Lineage doc wont be very helpful. However, looking at the mappings will help. For example, you may see that 3 task populate the same table for Workforce Events, but one is for Employee Job Events (Promotion, Transfer, etc), another is for Employee Age change, another for Performance. There is always a reason they are separated. Sometimes you can read the details in the mapping comments or in specifici transformations. If this helps, please mark the response.
How to find which SDE/SIL to Customize ?

I need to do a Type 1 Customization of adding a extra column from the Source System to Target DW Table in OBIA. I am able to work out everything once i know which SDE/SIL Specifically to customize, however how to find out this one ? I went through th

DAC execution

Hi I am trying to execute the prebuilt ETL ,some of the workflow failed, i check the log files and i found this error message WRITER_1_*_1> WRT_8229 Database errors occurred: ORA-26002: Table TRG_OWB.W_USER_D has index defined upon it. This is the st

Change Capture For Siebel OLTP task in DAC running for more than 10 hours

whole etl load used to complete in 2 hours (as on now siebel data having sample data). since last Friday Change Capture For Siebel OLTP task in DAC execution plan running for more than 10 hours. I am not able to trouble shoot the problem because no l

Oracle.jms.AQjmsException: invalid arguments in call

Hi Has anyone seen this error before? Environment Configuration: APP SERVER 9.0.4 (OUT 0F BOX CONFIG) JDK 1.4 RED HAT ENTERPRISE SERVER 3.0 COMPAC DL380 ON VM SOFTWARE DB 9.2.0.4 HP-UX 11i SUPERDOME Error logs: [18-06-04 10:27:20] [AJPRequestHandler-

Configure BI Apps on ODI installation

Hi All, we have installed ODI 11g and BI Applications 11.1.1.8 (on Windows Server 2008) and we have need to use BI Apps (like standard mapping SDE, SIL, PLP ecc). Our installation works correctly, but, under "Projects" tab, we don't have any obj

DAC Generate Parameters and Build Commands

Hi everyone, Can someone explain the differences between the generate parameters and the build commands? My initial thought was that generate parameters generated the Informatica parameter files. But then I couldn't figure out what the purpose of the

OBIA 7963 - HR Analytics - Customization Question

**Issue Description:** : OOTB Headcount calculations should exclude group of people who are called as non executive directors (NED). There are no indicators/ Flag in the source system to identify who is NED in a particular point in time. There are so

Error while running a customize report in oracle ebs

Hi .. can anybody suggest how to solve the follwing error while running a customize report in oracle ebs? XXIFMS: Version : UNKNOWN Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. Current system time is 03-JUN-2011 11:09:24 +------

Dunning Letters Customization

Hi, I want to customize Dunning letter program. We have around 10 Operating Units. We want to build the customization for only US and UK operating units using BI Publisher. Rest of the operating units need to use the standard report.(text output.) 'D

Customize Print Quote stylesheet ASOPRINT.xsl

Hi, I have a requirement where I need to check if we can use the existing Print Quote functionality to generate custom Quote Reports. As i see we can create new XML templates by making changes to the standard style sheet ASOPRINT.XSL. According to wh

Cannot open customize OAF screen after upgrade to 12.1.3

Hi, After upgrade to 12.1.3, I am not able top open customize OAF screens from Applications. By following some documents from MOS, I have done the following. 1)-applied patch 9879989 on Linux server. 2)-I am able to install JDeveloper,open and compil

Team Planner -- Customization

We recently upgraded to 2010 professional, and I was pleased to see the team planner view, which was something I was attempting to do in 2007.  We are using MS Project 2010 Professional more for resource management than project management.  In fact,

"Program files" directory problem during Microsoft Office Customization Installer in non-English versions of Windows

We have a document-level customization solution for Word and are experiencing problems during deployment in an environment running on terminal services. The OS (Windows 2012) is English and Word (2013) is non-English (German).  Installation is done i

No longer able to fully customize?

Follow up to closed thread https://support.mozilla.org/en-US/questions/985948 I have been happily using firefox since ages, although I've never liked the idea nor felt the need of frequent updates. Last January I did the move from 3.6 (aka 10) bundle

Adobe Muse - Menu Bar Customization

I am new to muse and have made a couple of test sites. I am not working on my first Muse site and running into the problem of customizing my menu bar. The bar no longer shows up as 4 different sections. It comes up as one big one. How do I add more s

? to Customize Sap GUI Logon Pad

Hello all, How can i customize Sapgui logon pad with own Logo instead of Default Logo. Thanks in advanace, RahulHi Markus  When we click on Logon Pad SapGUI 710 On the System Tab right hand side we have Viriable logon below to that We had a Logo Indi

How to customize the table layout in WAD (BI70)

hi experts, i want to customize the table layout in WAD. in 3.5, i can set the table interface class,and use T_Code se24. but now i am using BI7.0, there is no table interface, so how can i customize the table layout?Use report designer for customeri

Deploy customize workflow takes a long time to show up in application

Hi, This is the first time (newbie) i am customizing and deploying work flow in ebiz(R12), the problem that I am facing is that after I deploy the customize workflow it takes a long for the ebiz to pickup/show the changes. What I did was to customize

How to let other users use my customization?

Hello, I have a few nice dynamic pages with bind variables. I use the user PORTAL to customize my bind variables, but what I customize is not for other users, they see the result of the default bind variables. Surely there is a way to set the customi

Wlp10/wls10: Remote access to Portal Customization

Hi! I am developing a portlet that will be used to customize some portal content in the same domain, but in a different server environment (A preview environment will be used to let users with an editor role publish some portal inventory items to the