Process Scheduled Ownership Change Data (ownership_change_process)
|
Module Name |
ownership_change_process.ksh |
|
Description |
Processes scheduled ownership change records from the Ownership Change related tables. |
|
Functional Area |
Foundation Data |
|
Module Type |
Business Processing |
|
Module Technology |
Ksh |
|
Catalog ID |
N/A |
|
Wrapper Script |
rmswrap_shell.ksh |
Design Overview
This batch program process scheduled and approved ownership change transaction records that are set to go into effect the next day. It updates costing and ownership attributes of item/supplier/country or item/supplier/country/location combinations.
Additionally, primary supplier and country is updated for item/location records. This process will also trigger creation of PO and RTV depending on ownership change type along with relevant tran data postings to account for financial impacts of such transactions. There will not be any tran data entries if non-inventoried consignment items are involved. In case the item on the ownership change has child items, then the children will also be updated with the same changes as the parent item. On successful completion of the batch, overall status of the Ownership transaction will be updated to 'Processed'.
To account for changes in the item and other transactions that can happen between the time the ownership change was approved and it's picked by the batch for processing; following validations are performed at the time of batch execution. The batch program will fail to process for the ownership change transaction if any of the item/supplier/country/location fails the following validations.
-
The item should not be part of any pack; the exception being when its component of sellable only complex pack or an orderable (non-sellable) buyer complex pack
-
The location should not be included in any other approved Ownership Change transaction for the similar Item/Supplier/Country combination
-
Item should be associated with supplier site and country as specified in the items table.
-
Current Primary supplier site of the location should be same as the one specified in Items table (When the change type is Update Primary Supplier)
-
The item/supplier/country/location combination should not exist on any approved and not closed Purchase Order
-
The item/supplier/country/location combination should not exist on any open Return to Vendor
-
Any replenishment attribute should not be active for item/supplier/country/location combination
-
The item/supplier/country/location combination should not exist on any Cost Change scheduled on or after the effective date of the ownership change
-
Item/supplier/country/location should currently have a purchase type that corresponds to the ownership change type. For example: If Change Type is 'Owned to Consignment' then allow those locations with Purchase Type at Item/Supplier/Country/Location as 'Owned'. Similar treatment for other Change Types.
-
The item/supplier/country location should have a purchase type of either consignment or concession (When the change type is Update Primary Supplier).
The item/supplier/country/location should have the same purchase type for the current and new supplier/country; either both are consignment or both are concession. (When the change type is Update Primary Supplier).