My Oracle Support Banner

SAR Filling Has XSD Validation Failed Error (Doc ID 2945355.1)

Last updated on MAY 03, 2023

Applies to:

Oracle Financial Services Regulatory Reporting - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

On CRR: 8.1.2.3.0 and ECM:8.1.2.3.0

SAR filling has XSD Validation Failed error 

in 812 USSAR, When a user click on the 'request for approve' button, the validation failed because in USSAR technical guide, we have the below steps:

-------------------------
4.2 Loading Product Supplied Metadata To load the product supplied metadata, follow these steps: Run the AtomicUSSAR.sql manually in the RR Atomic schema.
-------------------------

the values given in AtomicUSSAR.sql are not as per the OOB USSAR.xsd file nor with Fincen guideless

ex: dim_financial_inst_type
We have two sets of records, one set with integer(seeded) and the other with character(AtomicUSSAR.sql) in V_FININST_TYPE_CODE.

1 A Casino/Card Club
1009 1 Casino/Card Club

2 B Depository institution
1010 2 Depository institution

validation fails every time because the values are not supported as per xsd file.

expectation from the client:

- We need the clean-up script.
- SAR Admin doc needs to be updated if AtomicUSSAR.sql is not required to be executed as part of the post-install step.

 

 

 

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


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