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

Last updated on FEBRUARY 06, 2022

Applies to:

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

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