My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

Applies to:

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

Symptoms

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.



Changes

 

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
Changes
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.