My Oracle Support Banner

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

Last updated on FEBRUARY 06, 2022

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 execute the profile margin report
the following error occurs.

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 ## Detail 0 ## java.sql.SQLException: ORA-01427: single-row subquery returns more than one
row at oracle.jdbc.driver.T4CTTIoer.processError( at
oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4C8Oall.processError( at
oracle.jdbc.driver.T4CTTIfun.receive( at oracle.jdbc.driver.T4CTTIfun.doRPC( at
oracle.jdbc.driver.T4C8Oall.doOALL( at

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


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

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