Concurrent Program 'Update Budgets from Interface Tables' Receive Error ORA-01426: numeric overflow in Package OZF_RESALE_COMMON_PVT Procedure update_main_tables
(Doc ID 2798835.1)
Last updated on AUGUST 04, 2023
Applies to:
Oracle Trade Management - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.6 version, Offers
Update Budgets from Interface Tables Concurrent Program is completing in Error.
Error:
ORA-01426: numeric overflow in Package OZF_RESALE_COMMON_PVT Procedure update_main_tables
Steps:
1. Navigate to Oracle Trade Management Administrator
2. Select Concurrent Requests > Run
3. Select Program 'Update Budgets from Interface Tables' and enter Batch Type as 'Funds Accrual Engine'
4. Submit program
Details
========
OZFCHBKBUDMAIN: Update Budgets from Interface Tables
+---------------------------------------------------------------------------+
Current system time is 09-AUG-2021 03:27:03
+---------------------------------------------------------------------------+
[09-AUG-2021 03:27:03]: **Starts**
[09-AUG-2021 03:27:10]: **Ends**
Error while running staging table Concurrent Program
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Concurrent Program updating records from Staging to Main tables - Started
Updating all the records to table OZF_FUNDS_ALL_B, OZF_ACT_BUDGETS when batch_id is null
p_batch_type: FAE
p_batch_id:
Updating funds record xxxxx
Updating funds record xxxxx
Updating ozf_act_budgets record xxxxxx
Updating ozf_act_budgets record xxxxxx
Concurrent Program updating records to main tables failed
l_return_status := U
(1) ORA-01426: numeric overflow in Package OZF_RESALE_COMMON_PVT Procedure update_main_tables
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
0
Deleting empty output file.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 09-AUG-2021 03:27:11
+---------------------------------------------------------------------------+
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 |