Add DFF Columns to Views Process


This process adds DFF columns to the SplashBI EBS views that includes seeded and custom and can be run whenever a DFF is changed by an Oracle E-Business Suite Developer/System Administrator.


To run add DFF columns to views process:


  1. Navigate to Reports >All Reports.
  2. Search for Add DFF Columns To Views Process in all reports tab.
  3. Click on Run icon to navigate to Submit page.
  4. Provide the following LOVs to the Parameters according to desired output.


    • To load DFFs for all modules: Submit the process by selecting the connection from Connection Name parameter.
    • To load DFFs for single module: Submit the process by selecting the domain from Domain parameter, Splash Business Area as Oracle E-Business Area, Group Name as same as Domain name.
    • To load DFFs for single/multiple views: Submit the process by selecting Connection, Splash Business Area, Group, Domain and View Name(s).




DFF Columns Parameters


Connection Name: Select Oracle EBS connection from Connection Name drop down.


Business Application: Select Oracle E-Business Suite Splash Business Area from the Splash Business Area drop down, where the data source is connected.


Group Name: Select the Group Name from the drop down.


Domain Name: After selecting Connection Name and Splash Business Area parameters, domain names associated with the selected Connection Name and Splash Business Area will be listed. Select the domain name from the drop down.


View Name: After selecting the Domain Name, tables (report source objects) will be listed. Select one from drop down to which DFF segments are to be processed. If this parameter is not selected, then Add DFF segments will be processed to all the tables in that domain.


Note: From 5.0.1 Reports like DFF addition processes are changed to non-Oracle EBS so that responsibility drop down is not showing on the run page.