OBIA 11.1.1.8.1: Incorrect Index Creation In GL Journal Fact Group (Doc ID 1915375.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

In OBIA 11.1.1.8.1 the table maintenance ODI procedure in GL Journal Fact Group is dropping and creating indexes in the wrong table.
This OOB load plan is generated from Configuration Manager. Source is EBS 11.5.10

It should be dropping and creating indexes in W_GL_OTHER_F and W_GL_LINKAGE_INFORMATION_G. 

Instead its dropping and creating indexes on W_POSTED_SLENTRY_G.


Cause

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