80912 Y9LP : Schedule PC-A Intercompany Loans BHCP0533,BHCP0537,BHCP0204 Issues (Doc ID 2737828.1)

Last updated on DECEMBER 22, 2020

Applies to:

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

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