Different Warehoue IDs For Different Service Lines in a Order Are Dropped When Reaching The Service Contract Causing Incorrect Ship_From Tax Calculation (Doc ID 2023075.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Service Contracts - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 Integration with OM, find that Service Contract are created from OM with WareHouse data from only one service line ignoring all additional  Service Lines Warehouse IDs  included in the same Order.
  
Expected Behavior:
Expected OKS to consider ALL Warehouses in the Service Line orders when creating Service Contracts.
All the Ship From Org IDs (Warehouses) are there correctly in OM. But not when the data is Processed to create contracts

If the order is added to an Existing Contract, then
Scenario 1.
Sales Order contains more than one Service Line and service lines created with different warehouses.
If service item Name is the same on both lines then, the contract will be created with only one service line in OKS. (The second line Warehouse ID is Lost)

Scenario 2.
When creating Sales Order select an option to add new service to existing contract.
Even if new line is entered with a warehouse ID different from those in contract, a new product will be added to existing service line. whic is not expected because the new line has its own parameters.

Profile OKS: Contracts Validation Source is set to "Ship from Org - Order Management" (which should pass the data back to OKS to be used as setup in OM. OKS seems to ignore this profile where the items are from multiple warehouses.

Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Create an Order with multiple lines pointing to different Warehouses (Check the Warehouse _ID : Help > Diagnostics > Examine: see BLOC: Lines, Field: SHIP_FROM_ORG_ID, see Value as 671)

2. The order can be attached to an existing contract.

Only the Fisrt line Warehouse details are captured
When additional service lines are added to the contract, the warehouse the item is shipped from is not captured.

When adding a second line added to an existing contract.
The Order in OM shows the correct ship_from warehouse ID for the item (contract subline)
This is evident thru an examination of the line Ship From Org ID. It retains the Ship from Warehouse ID

Once the contract is created, in OKS authoring form, the same line (Service) and Product (subline) Ordered from OM do not display the correct OrgID (OBJECT1_ID2) for bloc OKS_LINES (the Value is Unexpectedly 674 and not the OM Id  of 671.


The added line has unexpectedly the details of the warehouse ID of the First line of the Contract.
 

Business Impact:
Due to this issue, users cannot have contracts created from OM reflecting the correct Warehouses they shipped from.

Leading to incorrect line tax calculation.

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms