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:

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

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