WIP Assembly Complewtion Failes With Transaction Processor Error ORA-01422: exact fetch more than requested number of rows in Package wip_cplProc_priv Procedure processTemp (Doc ID 2994926.1)

Last updated on JANUARY 06, 2025

Applies to:

Symptoms

When attempting to perform WIP assembly completion for quantity larger than 1 against e job having assembly with serial control, the following error occurs:

ERROR

Transaction processor error
ORA-01422: exact fetch more than requested number of rows in Package wip_cplProc_priv Procedure processTemp


STEPS

1. Work in Process responsibility
2. Navigation: WIP > Material Transactions > Assembly Completion form
3. Enter the job number and continue
4. Enter the serial numbers to match the qty completed (must be more than 1)
5. Save --> error returned.

Cause

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