In OFS PBSM, Not Able To Load Data From STG_MANAGEMENT_LEDGER Into FSI_D_MANAGEMENT_LEDGER
(Doc ID 2974932.1)
Last updated on OCTOBER 05, 2023
Applies to:
Oracle Financial Services Profitability Management Cloud Service - Version 23.6.1 and laterInformation in this document applies to any platform.
Profitability Management Cloud Service (PBSM)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Modern Risk and Finance (MRF)
Symptoms
On PBSM 23.6.1 version, you are unable to load the data from STG_MANAGEMENT_LEDGER into FSI_D_MANAGEMENT_LEDGER table.
From Data Loader task logs:
Total Records - 0
Scheduler Service: Target service request received with following details:
{"batchRunId":"FSI_D_MANAGEMENT_LEDGER_01_2032-12-31_123456789_1","response":{"MESSAGE":"save executed","STATUS":"success"},"taskName":"FSI_D_MANAGEMENT_LEDGER_01"}
You verified and there are no duplicate records. Still, despite the batch got successful, no data has been loaded.
Below query returned no results in SQL Query Browser:
select * from FSI_D_MANAGEMENT_LEDGER where COMMON_COA_ID = 101;
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 |
| Cause |
| Solution |
| References |