Oracle Fusion Financials Real-Time Requirement- Core Customer Credit Hold and Past Due Risk Report

 --===========================================

--Real Time Requirement

--Report Name:  Credit Hold and Past Due Risk Report

--Module: Oracle Fusion Financials (AR)

--============================================

Customer_Name

Party_ID

Customer_Account_Id

Customer_Account_Profile_Id

Account_Number

Account_Description

PROFILE_CLASS_ID

Profile_Class_Name

Account_Last_Updated_By

Account_Last_Update_Date

Credit_Hold

Credit_Hold_Last_Updated_By

Credit_Hold_Last_Update_Date

Registry_Id

Relationship_parent_child_

Account_Hierarchy

Related_Name

Oldest_Due_Date

Past_Due_Days

Past_Due_Balance

From_Date

To_Date

Account_Status

----------------------------

Optional Parameters:

Registry Id & Account Number 

------------------------------

Output format: CSV/XML/Excel

-----------------------------

Logics: Need to display Parent and Child Accounts in the same field.

Means Need to follow the hierarcy Registry ID-->Parent-->Childs.

If parent account as on-hold then related child accounts also be on-hold.Past due days(>=32)

If parent or child account has credit hold  then related all the accounts should be on-hold.Past due days(>=32)

If any account releases manually(i.e .com or system) then it account status should go release.

Filter only Core Customers