My Oracle Support Banner

DGS VA - Error Logging (Doc ID 2796065.1)

Last updated on AUGUST 06, 2021

Applies to:

Oracle Financial Services Data Governance for US Regulatory Reporting - Version 8.0.8 and later
Information in this document applies to any platform.

Symptoms

DGS Batch Execution - Error Logging


1. Complete Error message was not getting captured in FSI_DGS_ERROR_LOG in case of index unusable error.
Eg below select * from eone.FSI_DGS_ERROR_LOG where batch_id like 'EONEINFO_E1_DGS_ACCT_MAPPER_INSERT_20200930_3%' and msg_text like '%ORA-12801:%';

Error : *** Final table insertion got failed ORA-12801: error signaled in parallel query server P01T, instance danuxl7350db04.XXXX:u73500192 (2)In above it is nowhere mentioned that the failure is due to index status.

********************************
Customer has to manually execute the insert to find out the issue.
*************************************
2. FSI_DGS_DATA_ORIGIN_AGG – No of records inserted message is not captured in FSI_DGS_ERROR_LOG unlike other tables which are part of account_mapper.
Query
 select * from eone.FSI_DGS_ERROR_LOG where batch_id like 'EONEINFO_E1_DGS_ACCT_MAPPER_INSERT_20200930_3%' order by msg_timestamp desc;

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


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