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 MARCH 30, 2020

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.

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

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
Goal
Solution


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