Results for “igi_exp_dial_unit_v”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGI_EXP_DIAL_UNIT_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGI – Public Sector Financials International product. In Oracle EBS 12.1.1 and 12.2.2, it exposes the complete configuration of "dialog units," which are setup records used by the IGI expenditure (EXP) functionality to define how third-party transactions are captured and processed. The view is informational rather than transactional: it presents dialog unit definition data joined with descriptive attributes from vendors, customers, sites, users, transaction types, so that implementers and support personnel can inspect setup without navigating multiple base tables.
The view is especially relevant to the search term third_party_name. One of its documented columns is literally THIRD_PARTY_NAME, which resolves to either a supplier (vendor) name or a customer name depending on the transaction type application. This makes the view a single point of reference for identifying the trading partner associated with each dialog unit.
Underlying Base Objects
According to its documented view text, IGI_EXP_DIAL_UNIT_V is a UNION ALL-style construct (implemented with UNION) over two branches:
- Supplier branch – joins IGI_EXP_DIAL_UNIT_DEF (the core dialog unit definition table) to PO_VENDORS and PO_VENDOR_SITES for third-party and site details, FND_USER for the creating user, and IGI_EXP_TRX_TYPE restricted to APPLICATION = 'P' (Payables).
- Customer branch – joins IGI_EXP_DIAL_UNIT_DEF to RA_CUSTOMERS (aliased C for CUSTOMER_NAME), RA_SITE_USES, IGI_AR_ADDRESSES_V for a formatted address reference, FND_USER, and IGI_EXP_TRX_TYPE restricted to APPLICATION = 'R' (Receivables).
The documented metadata lists DUAL (SYNONYM) as a referenced base object, reflecting the dictionary-level dependency tracking rather than the full join graph. In practice, all joins are driven from IGI_EXP_DIAL_UNIT_DEF, which supplies the DIAL_UNIT_ID primary identifier and the common descriptive columns.
Key Columns
- DIAL_UNIT_ID / DIAL_UNIT_NUM – surrogate key and user-facing number identifying the dialog unit.
- DESCRIPTION – free-text description of the dialog unit setup.
- THIRD_PARTY_ID / THIRD_PARTY_NAME – identifier and resolved name of the supplier or customer. THIRD_PARTY_NAME is populated from PO_VENDORS.VENDOR_NAME in the Payables branch and RA_CUSTOMERS.CUSTOMER_NAME in the Receivables branch.
- SITE_ID / SITE_NAME – the vendor site code or, for customers, the NVL of IGI_AR_ADDRESSES_V.STP_COMMON_REF over RA_SITE_USES.LOCATION.
- APPLICATION – distinguishes the source ('P' for Payables, 'R' for Receivables) and therefore the meaning of the third party.
- AMOUNT, CURRENCY_CODE – monetary threshold/attribute configured for the unit.
- TRX_TYPE_ID, DOC_TYPE_ID, STATUS – transaction type linkage and record status.
- CREATED_BY / USER_NAME – audit identification of the creating application user.
- ROW_ID, CREATION_DATE – row locator and creation timestamp.
Common Use Cases and Queries
The view is typically queried for setup verification, data migration validation, and reconciliation of dialog unit configuration across Payables and Receivables. A frequent requirement is locating a dialog unit by trading partner name:
SELECT dial_unit_num, third_party_name, site_name, application FROM igi_exp_dial_unit_v WHERE UPPER(third_party_name) LIKE 'ACME%';SELECT dial_unit_id, dial_unit_num, application, amount, currency_code FROM igi_exp_dial_unit_v WHERE application = 'P';SELECT third_party_id, third_party_name, COUNT(*) FROM igi_exp_dial_unit_v GROUP BY third_party_id, third_party_name;
Because the definition is a view, no DML is performed against it; maintenance is carried out on IGI_EXP_DIAL_UNIT_DEF through the corresponding IGI setup forms. Reporting tools and custom concurrent programs can safely join this view to other APPS objects using DIAL_UNIT_ID.
-
View: IGI_EXP_DIAL_UNIT_V 12.1.1
Displays all information pertaining to dialog unit setup
-
View: IGI_EXP_DIAL_UNIT_V 12.2.2
Displays all information pertaining to dialog unit setup
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - IGI Tables and Views 12.2.2
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.
-
eTRM - IGI Tables and Views 12.1.1
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: PUBLIC.DUAL 12.2.2
-
SYNONYM: PUBLIC.DUAL 12.1.1
-
eTRM - IGI Tables and Views 12.1.1
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.
-
eTRM - IGI Tables and Views 12.2.2
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.