OBIA 11g: An unposted journal can be deleted in EBS but OBIA does not have the logic to delete these journals in warehouse (Doc ID 2180011.1)

Last updated on FEBRUARY 05, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Goal

SILOS_SIL_GLOTHERFACT has a Soft delete preprocess step that is using W_GL_OTHER_F_PE to identify deleted records but there is no code to populate W_GL_OTHER_F_PE table

Please confirm how should W_GL_OTHER_F_PE table get populated?


Issue: An un-posted journal can be deleted in EBS but OBIA does not have the logic to delete these journals in warehouse.

Example: Lets say a user creates a journal for account 1234, Ledger ABC and JAN-16 period for $100.
                 This is un-posted but gets picked up by OBIA incremental load and gets loaded in W_GL_OTHER_F with un-posted status.
                 Next day, user deletes this journal in EBS and creates another journal for the same combination for $200.
                 When this journal gets loaded in OBIA, if I run a report aggregated at account 1234, Ledger ABC and JAN-16 level,
                 OBIA will show $300 but EBS will show $200 as 1st journal was deleted in EBS but it did not get deleted in OBIA.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms