80912 Y9LP : Schedule PC-A Intercompany Loans BHCP0533,BHCP0537,BHCP0204 Issues
(Doc ID 2737828.1)
Last updated on DECEMBER 22, 2020
Applies to:
Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.9 and laterInformation in this document applies to any platform.
Symptoms
Issue 1-
Inter company transactions (other than related institutions) logic missing for "Loans, advances, notes, bonds, and debentures" MDRMs (BHCP0533,BHCP0537,BHCP0204)
Missing this logic in DEPCA003 data set join applicable for these cells
Intercompany transactions (other than related institutions) logic:
AND ( a_org_structure.v_entity_code = dim_org_structure.v_parent_code OR a_org_structure.v_entity_code IN (
SELECT a_dim_org_structure.v_entity_code AS v_entity_code
FROM ( SELECT
CASE
WHEN v_parent_code = v_entity_code THEN NULL ELSE v_parent_code END AS v_parent_code,
v_entity_code,
v_entity_type,
f_latest_record_indicator
FROM dim_org_structure
WHERE dim_org_structure.f_latest_record_indicator = 'Y' ) a_dim_org_structure
CONNECT BY
PRIOR a_dim_org_structure.v_entity_code = a_dim_org_structure.v_parent_code
START WITH a_dim_org_structure.v_parent_code = dim_org_structure.v_entity_code
AND a_dim_org_structure.f_latest_record_indicator = 'Y'))
Issue 2-
The "Other receivables" MDRMs (BHCP0534,BHCP0538,BHCP0205) should have NOT IN conditions to exclude intercompany reg product classifications (ADBANASSSUB,ADNONBANASSO and ADBANSUBHOLASSO) which are already reported on "Loans, advances, notes, bonds, and debentures" MDRMs (BHCP0533,BHCP0537,BHCP0204) otherwise the balances will be double counted in MDRMs (BHCP0534,BHCP0538,BHCP0205).
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 |