Deal Simulation Error - SQL Exception Occurred During Deal Simulation for a Deal
(Doc ID 3077879.1)
Last updated on MARCH 31, 2025
Applies to:
Oracle Financial Services Revenue Management and Billing Cloud Service - Version 7.0.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On 7.0.0.0.0 version, Environment Issue
The following message is reported upon deal creation on a new customer the system is throwing error when simulating a deal after selecting a pricelist and price items:
ERROR
-----------------------
SQL exception Occurred during deal simulation for a Deal [DEAL_ID] and model Id [MODEL_ID].
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Deal Dashboard from Main Menu > Create Deal > Search existing customer.
2. Enter the deal information > Save and then Next.
3. Select price items from "Price Item Selection" under "Action" tab > Click on "Save and View Pricing and Commitments".
4. Change rate for few price items and go back and Simulate the deal (On this step the error is encountered).
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 |