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

BIP report to pull in-transit time from interorg ship methods

in Supply Chain Planning and Collaboration

Summary:

I'm rather new to Fusion SCP tables. I need to modify existing custom BI Report lead time calculations for "transfer from" sourcing rules to use in-transit time. I have the logic for Oracle EBS, but it looks like Fusion tables join differently. Specifically around msc_interorg_ship_methods (this has in-transit time). This table has ORIGIN_ID and DESTINATION_ID, but they don't seem to align with warehouse orgs.

Content (please ensure you mask any confidential information):

Oracle EBS SQL is something like this:


I have the corresponding table names for Fusion. I realize that ship method is no longer a join field. Also that ORIGIN_ID and DESTINATION_ID seem to be the key fields I need to join on. Is there an intermediate table I'm missing because none of our organization IDs match what is in origin/destination IDs.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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