My Oracle Support Banner

Insert Multiple Records Into WIP_SERIAL_MOVE_INTERFACE For One Transaction_id (Doc ID 2626056.1)

Last updated on JANUARY 05, 2020

Applies to:

Oracle Work in Process - Version 12.2.7 and later
Information in this document applies to any platform.

Goal

Users insert record into wip_move_txn_interface and WIP_SERIAL_MOVE_INTERFACE. After that,  the Move Transaction Report is run to process this record.
This functionality works correctly when processing one serial number from WIP_SERIAL_MOVE_INTERFACE for transaction id.
However, when inserting multiple records into WIP_SERIAL_MOVE_INTERFACE, the transaction ends with error: "You can only move/complete/return only one serial assembly per record."

Is there any limitation to the code in Rel 12.2.6 ?
 

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
References


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