Creating a Service Order in Depot Repair results in Error, but no Error Messages

(Doc ID 2401928.1)

Last updated on MAY 31, 2018

Applies to:

Oracle Quoting - Version 12.2.6 and later
Oracle Depot Repair - Version 12.2.6 and later
Oracle Order Capture - Version 12.2.6 and later
Oracle Teleservice - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, FORMS User Interface

When try to create a sales order from either Depot Repair or Service Request Charges using a star item (ABC123*45678), an error occurs.

ERROR
-----------------------
The Create Order API returned with and error status but no error messages.

after click "OK" the following error is displayed:

Message(s) form order Management : (The Create Order API returned with and error status but no error messages.)


Depot Repair calls Charges that in turn calls ASO code to do the Create Order.
While looking at the ASO Debug collected while reproducing the error, the following exception is seen:

ASO Exception in package : ASO_ORDER_INT
ASO Exception in API : Create_Order
ASO SQLCODE :
ASO SQLERRM :
ASO Exception in package : ASO_ORDER_INT
ASO Exception in API : Create_Order
ASO SQLCODE :
ASO SQLERRM :



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a service request
2. Go to Charges tab and enter service activity, item, etc. Be sure to use a star item, issue does not occur when using standard items
3. Try to submit and the reported error occurs

 

Changes

 

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