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
+---------------------------------------------------------------------------+
