Can We Do Direct Update To Table WSH_CONTAINER_ITEMS For Item-container Relationship?
(Doc ID 2649509.1)
Last updated on MARCH 30, 2020
Applies to:Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.
Can we do direct update to table WSH_CONTAINER_ITEMS for item-container relationship?
We need to establish item-container relationship in Oracle inventory and thus update on WSH_CONTAINER_ITEMS table is required on fly.
However, as per Doc ID 1923080.1, there is no existing API for this action.
But this step is a mandate for us to build the functionality.
This is major hurdle to our current production release and will impact across all organization.
==> Can you please authorize that we can directly update the table either from back end or via a custom form?
Trying to pack an item in container by using WSH_CONTAINER_PUB.container_actions API.
Before running this API, I need to establish container-item relationship.
Hence I need to insert a new record into WSH_CONTAINER_ITEMS table and I want to INSERT this record through back end by running my code.
This is reason I am requesting you to please authorize direct INSERT into the table either from back end or via a custom form.
My team has already analyzed container-item relationship FORM. This form is based on only one oracle base WSH_CONTAINER_ITEMS table so direct INSERT operation on this table will not cause any data integrity issue.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document