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

Last updated on JANUARY 05, 2017

Applies to:

Oracle Work in Process - Version 12.1.1 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
-----------------------

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

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 hundreds of Community platforms