My Oracle Support Banner

Profit Margin Report In Service Request Errors Out (Doc ID 1565900.1)

Last updated on JULY 21, 2020

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Charges UI, APIs, and schema

When attempting to execute the profile margin report
the following error occurs.

ERROR
-----------------------
You have encountered an unexpected error. Please contact system administrator for assistance.

Exception details:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement:
SELECT * FROM (SELECT cia.incident_id , flv.meaning BillingType,ced.currency_code "Currency",cic.currency_code , flv.lookup_code
LookupCode,ced.org_id "ou", ced.estimate_detail_id "EstimateDetailId", ced.line_number "LineNumber", ( CASE WHEN
fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') ='Y' THEN to_char(
hz_timezone_pub.convert_datetime(fnd_profile.value('SERVER_TIMEZONE_ID'),fnd_profile.value('CLIENT_TIMEZONE_ID'),ced.creation_dat

java.lang.Thread.run(Thread.java:619) ## Detail 0 ## java.sql.SQLException: ORA-01427: single-row subquery returns more than one
row at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Service Request for Depot Repair
2. Create a Task
3. Do the Debrief
4. Go to Service Request Screen
5. Run the Profit Margin Report

Cause

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
Symptoms
Cause
Solution
References


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