Search Results financial_item_id




Overview
Explore in AI Chat

Overview

AMW.AMW_FIN_ITEM_ACC_RISK is an operational table in the Oracle E-Business Suite Financials/GRC-adjacent module owned by the AMW schema (commonly associated with Oracle Financial Services or Treasury/GRC-style risk certification flows). It functions as a cross-reference repository that links financial statement structures, financial items, account groups, natural accounts, and organizational context to risks, risk revisions, opinions, and financial certifications within a given process. In practical terms, it answers the question "which financial items, accounts, or statements are associated with a particular risk (or risk revision) inside a certification process?"

From a Data Vault modeling perspective, the mined metadata classifies this object as standalone (no declared hub-style relationships beyond two reference foreign keys, and only a composite business-key index). It behaves most like a link table — a many-to-many association between risk/certification entities and financial item/account entities — rather than a pure hub or satellite. This classification is heuristic, not authoritative; the ETRM FK structure only documents references to AMW_RISKS_B and FND_SECURITY_GROUPS, so the modeling suggestion should be treated as guidance rather than a documented constraint.

Key Information Stored

Although the table documents 19 columns, the columns that carry business meaning are concentrated in the risk/certification and financial-entity dimensions:

No single-column surrogate primary key is documented. The closest business-key candidates are the non-unique indexes AMW_FIN_ITEM_ACC_RISK_N8 (ACCOUNT_GROUP_ID, NATURAL_ACCOUNT_ID) and AMW_FIN_ITEM_ACC_RISK_N9 (FINANCIAL_STATEMENT_ID, FINANCIAL_ITEM_ID), which indicate the natural association keys used for lookup.

Common Use Cases and Queries

Typical reporting scenarios include: listing all financial items tied to a given risk, tracing which risks impact a certification, and reconciling account-group/natural-account mappings per organization. Index support (N1–N9) means filters on OBJECT_TYPE, ORGANIZATION_ID, PROCESS_ID, RISK_ID, RISK_REV_ID, and FINANCIAL_ITEM_ID are efficient.

  • Items per risk: SELECT f.FINANCIAL_ITEM_ID, f.RISK_ID FROM AMW.AMW_FIN_ITEM_ACC_RISK f WHERE f.RISK_ID = :p_risk;
  • Certification view: SELECT * FROM AMW.AMW_FIN_ITEM_ACC_RISK WHERE FIN_CERTIFICATION_ID = :p_cert AND ORGANIZATION_ID = :p_org;
  • Account mapping: SELECT ACCOUNT_GROUP_ID, NATURAL_ACCOUNT_ID FROM AMW.AMW_FIN_ITEM_ACC_RISK WHERE FINANCIAL_ITEM_ID = :p_item;

Because the table is on APPS_TS_TX_DATA with SECURITY_GROUP_ID, always respect the MOAC/data-security policy in custom SQL; joining without it can expose rows outside the user's security profile.

Related Objects

  • AMW.AMW_RISKS_B — referenced by RISK_REV_ID; the base risk entity. Join on RISK_REV_ID = AMW_RISKS_B.RISK_REV_ID.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; drives row-level security. Join on SECURITY_GROUP_ID = SECURITY_GROUP_ID.
  • AMW financial item / financial statement definition tables — joined via FINANCIAL_ITEM_ID and FINANCIAL_STATEMENT_ID.
  • AMW certification tables — joined via FIN_CERTIFICATION_ID and PROCESS_ID.
  • AMW opinion log — joined via OPINION_LOG_ID.

These relationships reflect the documented FK/index metadata; any additional AMW dependencies should be verified against the actual AMW data model for the specific 12.1.1 or 12.2.2 installation.