Results for “igs_fi_com_recs_int”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_FI_COM_RECS_INT table is the Commercial Receivables Open Interface table within the IGS (Student System) product family of Oracle E-Business Suite. It functions as a staging and inbound interface structure through which commercial receivable transactions — charges, fees, and related accounting entries originating from student-system activity — are collected before they are validated and transferred into Oracle Receivables. In Oracle EBS 12.1.1 and 12.2.2 the object is owned by the IGS schema and is documented in ETRM as a VALID table with 47 columns.

Its primary key, IGS_FI_COM_RECS_INT_PK, is defined over the composite of TRANSACTION_CATEGORY and TRANSACTION_HEADER_ID. This composite structure, together with foreign-key references to HZ_PARTIES and IGS_FI_CR_TYPES_ALL, indicates that the table records associations between transacting parties and receivable header events. Under the heuristic Data Vault classification mined from the foreign-key structure, the table is best modeled as a link — a relationship-bearing structure that connects parties, credit types, and transaction header events rather than acting as a standalone hub or a pure descriptive satellite.

Key Information Stored

The documented metadata identifies several columns of primary significance:

• TRANSACTION_CATEGORY and TRANSACTION_HEADER_ID — the composite business-key candidates that form the unique index IGS_FI_COM_RECS_INT_PK and govern row uniqueness.
• TRANSACTION_NUMBER — the external-facing transaction identifier used for reconciliation and audit trails.
• PARTY_ID — foreign key to HZ_PARTIES, identifying the commercial account or paying entity.
• STUDENT_PARTY_ID — a second HZ_PARTIES reference identifying the student associated with the transaction.
• TRANSACTION_DATE, EFFECTIVE_DATE, and GL_DATE — the event, accounting-effective, and general-ledger dates that drive period placement.
• FEE_TYPE, S_FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FEE_CATEGORY — fee identification and calendar context for the charge.
• AMOUNT, CURRENCY_CD, CREDIT_POINTS — monetary and credit values carried into Receivables.
• CREDIT_TYPE_ID — foreign key to IGS_FI_CR_TYPES_ALL, classifying the credit or receivables type.
• CREDIT_GL_CODE_COMBINATION_ID and DEBIT_GL_CODE_COMBINATION_ID — accounting flexfield references for the double-entry posting.
• EXTRACT_FLAG, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID — interface processing and concurrency control columns.
• SOURCE_INVOICE_ID — linkage back to the originating invoice.

Common Use Cases and Queries

Typical usage centers on monitoring inbound commercial receivable data, diagnosing failed or unprocessed interface rows, and reconciling student-system charges against Receivables.

• Rows pending extraction (filtering on EXTRACT_FLAG) to determine items awaiting transfer to Oracle Receivables.
• Joining PARTY_ID or STUDENT_PARTY_ID to HZ_PARTIES to resolve party names for reporting.
• Joining CREDIT_TYPE_ID to IGS_FI_CR_TYPES_ALL to categorize transactions.
• Aggregating AMOUNT by CURRENCY_CD, FEE_CATEGORY, or GL_DATE for financial summaries.
• Troubleshooting using REQUEST_ID and PROGRAM_ID to trace the concurrent program that loaded or processed a given batch.
• Detecting reversals via REVERSAL_FLAG and REVERSAL_REASON for audit or exception reports.

Related Objects

• HZ_PARTIES — referenced twice, via IGS_FI_COM_RECS_INT.PARTY_ID and IGS_FI_COM_RECS_INT.STUDENT_PARTY_ID.
• IGS_FI_CR_TYPES_ALL — referenced via IGS_FI_COM_RECS_INT.CREDIT_TYPE_ID, supplying credit type definitions.
• IGS_FI_COM_RECS_INT_PK — the composite primary key index over TRANSACTION_CATEGORY and TRANSACTION_HEADER_ID.
• Oracle Receivables interface objects — the downstream destination into which validated rows are loaded.
• General Ledger code combination structures — consumed through the credit and debit GL code combination columns.