In OTM not able to fetch the Line Items in Parent Invoice from Child Invoices

Summary:

In Oracle Transportation Management, we are working with a 3-leg shipment scenario as outlined below:

• Truckload: Location A → Location B (Service Provider: CPKC)
• Rail: Location B → Location C (Service Provider: CPKC)
• Truckload: Location C → Location D (Service Provider: Rapid Trucking)

Currently, the system generates a separate invoice for each leg. However, we have a business requirement where a single invoice should be created when the service provider is the same across multiple legs.

In this scenario:

• The first two legs are handled by CPKC
• The third leg is handled by Rapid Trucking

Therefore, the expected outcome is:

• One consolidated invoice for CPKC