Unable To Create OTBI Report On Non-Primary Sites For Enterprise Contracts (Doc ID 3010339.1)

Last updated on MAY 07, 2024

Applies to:

Symptoms

On : 11.13.22.10.0 version, Analytics

ACTUAL BEHAVIOR

------------------------------------------

While trying to create an analysis based on this subject area, it has been observed that users are unable to report on non primary billing sites, which previously did not happen. The conditions on which OTBI checks for primary sites are: "PRIMARY_FLAG = 'Y'" OR "PRIMARY_FLAG IS NULL", which is different than the default 'N' the database is attributing.

When re-setting the Primary Flag, the value in the database in not NULL, but it is set to "N". Because of that , in the subject area, the users are unable to catch records that are not primary, as the OTBI generates the following predicates:

EXPECTED BEHAVIOR

------------------------------------------

Non-primary sites should be captured in the OTBI based on the specified conditions.

STEPS TO REPRODUCE

--------------------------------------------

1. Create Subject Area report in OTBI.

2. Unable to capture the non-primary sites.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.