OTBI - Joins between Procurement and Payment related Subject Areas

Sridhar Gupta Yerram-Oracle

Summary:

Content (required):

Hi Team,

There is an issue while joining two Subject Areas related to Procurement and Payment (trying to join below subject areas as in attached file : PROCSubjectAreas.png).

Requirement – Need to subtract Approval Date , Payment Date in one OTBI analysis which are being fetched from two different subject areas.

Issue : Fetching undesired data in the OTBI when I join below two subject areas in one analysis. {Procurement and Payment related Subject Areas}

I have done below checks while joining two subject areas:

1)Have a common folder between 2 Subject Areas of least granular level (i.e. supplier)

2)Added one measure column from each subject area

3) Checked the dimensionality check box

4) Also added columns from two subject areas 

--Please validate and let us know your inputs on the above issue.

-Sridhar

Version (include the version you are using, if applicable):

Oracle Fusion Applications - 22B

Code Snippet (add any code snippets that support your topic, if applicable):

PROCSubjectAreas.png

Raghavan p-Oracle

This is a note from product dev team on this topic:

https://community.oracle.com/customerconnect/discussion/29538/viewlet-cross-subject-area-join