Skip to Main Content

Data Lake & Services

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Clarification on deposit institution account id Field in Oracle FCCM

Fang LiuMay 1 2025

Hi Oracle Community,

I'm currently working on a project involving Oracle Financial Services Crime and Compliance Management (FCCM) and need clarification on the field deposit institution account id.

Despite reviewing the standard documentation and data model references, I have not been able to locate a definitive, official definition or source mapping for this field. Specifically, I'm looking to understand:

  • What is the intended definition or business meaning of dep_instn_acct_id / **deposit institution account id**?
  • Which upstream source system field(s) typically map to this field during implementation?
  • In which FCCM tables (e.g., **TRANSACTION_FACT**, **CUST_ACCT_DIM**) is this field commonly used, and what is the best practice for populating it?

If anyone has access to official Oracle guidance (e.g., STM documents, data model diagrams, or implementation experience) and could shed light on this, I’d greatly appreciate it.

Thanks in advance for your help!

Comments
Post Details
Added on May 1 2025
0 comments
114 views