Issues and Workarounds for Oracle GoldenGate

These issues and workarounds are related to the use of Oracle GoldenGate.

Support GoldenGate Integration for GL Segment Related Extract (EBS)

This change is required only when you use GoldenGate to replicate EBS data.

Model Change

Set Flexfields value OBI SDS Load Tech Exclusion List to BIA_OGG_SDS for FND_FLEX_VALUE_CHILDREN_V in EBS 12.2 (This value is already set for the other EBS versions)

  1. Open Model Oracle E-Business Suite R12.2 , click Application Object Library and select FND_FLEX_VALUE_CHILDREN_V.

  2. Open the Flexfields tab and set OBI SDS Load Tech Exclusion List to BIA_OGG_SDS.

  3. Save the change.

Package Changes

Modify the following packages to support SDS:

  • SDE_ORA_Stage_BalancingSegmentDimensionHierarchy_Primary

  • SDE_ORA_Stage_GLSegmentDimensionHierarchy_Primary

  • SDE_ORA_State_NaturalAccountDimensionHierarchy_Primary

As an example, the following instruction uses Balancing Segment.

  1. Take a backup of the ODI repository.

  2. In ODI client, open Mappings, click SDE_ORAXXX_Adaptor and select SDE_ORA_Stage_BalancingSementDimensionHiearrchy_Primary.

  3. Remove the link between SOFT_DELETE_PREPROCESS and SDE_ORA_Stage_BalancingSegmentDimensionHierarchy_Primary.W_BALANCING_SEGMENT_HIER_PS_PE.

  4. Drag variable SDS_LOAD_TECHNO and IS_SDS_DEPLOYED to the package.

  5. Rename the step name from SDS_LOAD_TECHNO to SDS_LOAD_TECHNO is BIA_OGG_SDS. Use Type “Evaluate Variable”, Operator “=”, and Value “BIA_OGG_SDS”.

  6. Use Type Set Variable and value N for IS_SDS_DEPLOYED.

  7. Connect SOFT_DELETE_PREPROCESS to SDS_LOAD_TECHNO is BIA_OGG_SDS .

  8. Connect SDS_LOAD_TECHNO is BIA_OGG_SDS to interface SDE_ORA_Stage_BalancingSegmentDimensionHierarchy_Primary.W_BALANCING_SEGMENT_HIER_PS_PE.

  9. Connect SDS_LOAD_TECHNO is BIA_OGG_SDS to IS_SDS_DEPLOYED .

  10. Connect IS_SDS_DEPLOYED to interface SDE_ORA_Stage_BalancingSegmentDimensionHierarchy_Primary.W_BALANCING_SEGMENT_HIER_PS_PE .

  11. Regenerate the scenario

Load Plan Change

Add variable SDS_LOAD_TECHNO and refresh it at root level.

  1. Open BIAPPS Load Plan, click Load Plan Dev Components, click SDE and select EBS_XXX LP component above.

    SDE Dims BALSEG_DIM

  2. Go to the Variables tab.

  3. Click Add. Search SDS_LOAD_TECHNO and click OK.

  4. Go to the Steps tab.

  5. Enable the Overwrite and Refresh checkboxes.

  6. Repeat the same for the following load plan components:

    • 3 SDE Dims GLSEG_DIM

    • 3 SDE Dims NAT_ACCT_DIM

    • 3 SDE Dims GLACCNT_DIM (The corresponding package change is already included in the product for this load plan).