Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

BI Publisher report to join MSC_CUSTOMER_SITES to MSC_CALENDAR_ASSIGNMENTS and MSC_REGIONS

edited Nov 7, 2024 3:55PM in Supply Chain Planning and Collaboration 1 comment

I'm trying to write a BI Publisher report to join MSC_CUSTOMER_SITES to MSC_CALENDAR_ASSIGNMENTS and MSC_REGIONS and how to best join these planning tables to the customer data that I'm familiar with in HZ_PARTIES.

It's not clear to me from the documentation https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/24d/oedsc/msccustomersites-20758.html#msccustomersites-20758 what tables I can join to MSC_CUSTOMER_SITES.

The values I'm looking to include: Calendar Name, Customer Name, Customer Number, Site Number, Location (Address), Shipping Region/Zone, and our associated ship from site (MSC_PARAMETERS)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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