My Oracle Support Banner

WIP Completion Transaction errored with "An assembly transaction cannot be processed in background mode" (Doc ID 1628037.1)

Last updated on APRIL 03, 2025

Applies to:

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

Symptoms

WIP Completion

When attempting to perform WIP Completion transaction, the following error occurs.

ERROR
-----------------------

An assembly transaction cannot be processed in background mode if it has backflush components that are serial controlled or lot controlled where the lot cannot be derived.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Organization parameter : Allow Negative Balances  : Yes

2. Component item is Lot controlled

3. WIP parameter Lot Selection Method is not Manual

4. Component Supply Type is Assembly Pull

5. The profile is set to the following

TP:INV Transaction processing mode : Immediate concurrent processing
TP:WIP Completion Transactions Form : On-line processing
TP:WIP Completion Material Processing : On-line processing

6. Perform WIP Completion transaction

 

FND Debug log shows the following.


MESSAGE_TEXT MODULE
... snip ....
       Session 101: [begin wip_autoLotProc_priv.deriveIssueLots] wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101:   p_orgID: 84 wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101:   p_treeMode: 1 wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101:   p_treeSrcName: wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101:   x_compLot(cur_item).inventory_item_id: 394 wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101:   x_compLot(cur_item).supply_subinventory: QD001 wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101:   x_compLot(cur_item).supply_locator_id: wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101:   x_compLot(cur_item).revision: wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101:   x_compLot(cur_item).primary_quantity: 2 wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101: [end wip_autoLotProc_priv.deriveIssueLots] wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101:   return status: E wip.plsql.wip_autoLotProc_priv.deriveIssueLots
       Session 101:   info: could not derive all qty. 2 remaining. wip.plsql.wip_autoLotProc_priv.deriveIssueLots
     Session 101: [end wip_autoLotProc_priv.deriveSingleItem] wip.plsql.wip_autoLotProc_priv.deriveSingleItem
     Session 101:   return status: E wip.plsql.wip_autoLotProc_priv.deriveSingleItem
... snip ....


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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