You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

OTBI Report Source System Item Real Time

Received Response
12
Views
1
Comments
in Reporting and Analytics for HCM 1 comment

Summary:

When i join Item Number and one of my EFF attribute in Product table i am getting one extra row in EFF table which is all blank. Do you know what might be the issue.

Content (please ensure you mask any confidential information):


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


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

SELECT 

  "Product Management - Source System Item Real Time"."Main"."Item" saw_0,

  "Product Management - Source System Item Real Time"."Region Assignments > Finished Good > Main"."EGO_ITEM_DL_XX_Region_Assignments_xxsoldToApac" saw_1,

  "Product Management - Source System Item Real Time"."Region Assignments > Finished Good > Main"."EGO_ITEM_DL_XX_Region_Assignments_xxsoldToEmea" saw_2,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!