CONVERSION_RATE & CONVERSION_RATE_DATE In CS_ESTIMATE_DETAILS Have Junk Values (Doc ID 2220797.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Depot Repair - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Repair Order Management

ACTUAL BEHAVIOR
---------------
Value for the columns CONVERSION_RATE & CONVERSION_RATE_DATE In the table CS_ESTIMATE_DETAILS is not populating correctly. It is showing as below.

CONVERSION_RATE Junk value : 999000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.00

CONVERSION_RATE_DATE:
01-JAN-4712 00:00:00

EXPECTED BEHAVIOR
-----------------------
Value for these column in CS_ESTIMATE_DETAILS table should populate correctly.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an SR and repair Order.
2. Add logistics line and book the order, which will insert the record in CS_ESTIMATE_DETAILS table
3. Table's column CONVERSION_RATE & CONVERSION_RATE_DATE showing wrong values.



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