R12: Error When Submitting A Return Line To Order Management - This Item Is Not Under Lot Control
(Doc ID 1940114.1)
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Charges UI, APIs, and schema
When attempting to submit Charges in the Service Request form, the following error occurs. This error was first seen in Depot Repair when a Return line is submitted for an item instance that has a lot number and the item is no longer lot controlled. This error wasn't seen in Release 11i.
This item is not under lot control
(SQLCODE=-60)(SQLERRM=ORA-00060: deadlock detected while
waiting for resource
ORA-6510: PL/SQL: unhandled user-defined exception)
Steps to Replicate
The issue can be reproduced at will with the following steps:
(N) Service Requests > Find/Create Service Requests
Click on Charges tab
Enter Item that is not lot controlled
The error above is displayed.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!