My Oracle Support Banner

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

Click OK

(SQLCODE=-60)(SQLERRM=ORA-00060: deadlock detected while
waiting for resource
ORA-6510: PL/SQL: unhandled user-defined exception)

Click OK

Steps to Replicate

The issue can be reproduced at will with the following steps:
(R) Service
(N) Service Requests > Find/Create Service Requests
Query SR
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!

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