Search Results amw_process_org_basicinfo_v

Overview

AMW_PROCESS_ORG_BASICINFO_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Internal Controls Manager (AMW) module. It presents basic, denormalized information about a Process Organization — the association between a defined business process and the operating unit or organization in which that process is performed and managed. The view is a convenience layer designed for inquiry screens, Oracle Discoverer worksheets, and custom reporting where a single row per process-organization combination is required without joining the underlying transactional tables directly.

The object is documented as VALID and is available in Oracle EBS 12.1.1 and 12.2.2. Because the view resolves workflow activity names, party names, audit unit descriptions, and derived opinion dates, it is typically consumed read-only. It also exposes the descriptive flexfield columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15) plus WHO columns and the OBJECT_VERSION_NUMBER, so it behaves much like a base table in form and integration contexts.

Underlying Base Objects

The view text is defined over five source objects joined as follows. AMW_PROCESS_ORGANIZATION (aliased AMW) is the driving table and supplies the process-organization identifier, risk and control counts, approval and audit statuses, owner identifiers, and DFF attributes. AMW_PROCESS (aliased AMWP) supplies the process name, item type, process category, and the standard process/variation flags. WF_ACTIVITIES and WF_ACTIVITIES_TL supply the workflow activity version and translated display name, constrained to the current session language via USERENV('LANG') and to open activities (WA.END_DATE IS NULL). HZ_PARTIES supplies the process owner party name, and AMW_AUDIT_UNITS_V supplies the audit unit name, company, and line-of-business attributes.

Two PL/SQL functions from AMW_UTILITY_PVT are invoked inline rather than joined: GET_PROC_ORG_OPINION_STATUS and GET_PROC_ORG_OPINION_DATE. These derive certification status and the certification date for each process/organization pair.

Key Columns

• PROCESS_ORGANIZATION_ID, PROCESS_ID, PROCESS_CATEGORY, PROCESS_CATEGORY_CODE, ITEM_TYPE, NAME — identify and classify the process organization.
• CERTIFICATION_STATUS — result of AMW_UTILITY_PVT.GET_PROC_ORG_OPINION_STATUS for opinion type 'CERTIFICATION'.
• LAST_CERTIFICATION_DATE — result of AMW_UTILITY_PVT.GET_PROC_ORG_OPINION_DATE for opinion type 'CERTIFICATION'; this is the column most frequently sought by users researching the last certification date.
• APPROVAL_STATUS, LAST_AUDIT_STATUS, LAST_AUDIT_DATE, NEXT_AUDIT_DATE — control and audit lifecycle indicators.
• RISK_COUNT, CONTROL_COUNT — aggregate counts of risks and controls associated with the process organization.
• ORGANIZATION_ID, PARTY_NAME, APPLICATION_OWNER_ID, PROCESS_OWNER_ID, FINANCE_OWNER_ID, TOP_PROCESS_ID — organizational and ownership attribution.
• AUDIT_UNIT, COMPANY, LOB_CODE, LOB_DESCRIPTION — audit unit and line-of-business descriptors.
• SIGNIFICANT_PROCESS_FLAG, STANDARD_PROCESS_FLAG, STANDARD_VARIATION — process significance and standardization indicators.
• SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER, END_DATE, WHO columns, ATTRIBUTE1–15 — multi-org security, concurrency control, and descriptive flexfield data.

Common Use Cases and Queries

Typical uses include certification reporting, process ownership listings, and audit scheduling dashboards. A common requirement is to list the latest certification date for each process organization within an operating unit:

• SELECT process_id, organization_id, name, certification_status, last_certification_date FROM apps.amw_process_org_basicinfo_v WHERE organization_id = :org_id ORDER BY last_certification_date DESC;
• SELECT process_id, name, risk_count, control_count, approval_status FROM apps.amw_process_org_basicinfo_v WHERE significant_process_flag = 'Y';
• SELECT process_id, organization_id, last_certification_date FROM apps.amw_process_org_basicinfo_v WHERE last_certification_date >= :from_date;

Because LAST_CERTIFICATION_DATE and CERTIFICATION_STATUS are computed by PL/SQL functions, filtering on these columns forces per-row function execution and can be costly over large result sets; restricting by organization or process first is advisable. The view should be queried from the APPS schema or through the Multi-Org secured responsibility context to honor SECURITY_GROUP_ID filtering.