My Oracle Support Banner

Can We Do Direct Update To Table WSH_CONTAINER_ITEMS For Item-container Relationship? (Doc ID 2649509.1)

Last updated on JUNE 07, 2021

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.