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

Last updated on APRIL 04, 2025

Applies to:

Goal

Can we do direct update to table WSH_CONTAINER_ITEMS for item-container relationship?

Details
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?


Requirement:
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.

Solution

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