Concatenation Does Not Work For Address Field.
(Doc ID 2985683.1)
Last updated on NOVEMBER 11, 2023
Applies to:
Oracle Financial Services Regulatory Reporting - Version 8.1.1 and laterInformation in this document applies to any platform.
Symptoms
On 8121v, The Address field of a Signatory, Entity, or Conductor is a concatenation of StreetLine1, StreetLine2, StreetLine3, StreetLine4, StreetLine5, and StreetLine6 as per FCT_CRR_TRG_SRC_TRG_MAP table. However, after posting the case, we observed that the report contains only the text present for StreetLine1.
Steps:
1. Consider a AML case with complete data(ex: customer, account and transaction)
2. Verify the customers who are present in the customer tab has a corresponding address.
3. Please add complete streets in the customer address.
4. promote the case to CRR
5. verify the new report. Only street1 is copied.
6. verify fct_Address table.
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 |