WIPTXSFM: ORA-01427: SINGLE-ROW SUBQUERY RETURNS MORE THAN ONE ROW FOR REPETITIVE SCHEDULES
(Doc ID 2769991.1)
Last updated on JUNE 10, 2021
Applies to:Oracle Work in Process - Version 12.2.9 and later
Information in this document applies to any platform.
On : 12.2.9 version, Transactions
Currently getting 3 errors in the move transactions form for repetitive schedules
APP-INV-05407 Quantity will drive inventory negative
unexpected error: ORA- 01476: divisor is equal to zero SQLCODE = -1476
unexpected error: ORA-01427: single-row subquery returns more than one row SQLCODE = -1427
This happens in move transaction for repetitive schedules only.
For discrete jobs it works fine
This works fine in 12.1.3 instance
In 12.2.9 it fails in all instances
The issue can be reproduced at will with the following steps:
1. Navigate to Move Transactions form
2. Attempt to save a move and get the error messages
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