Results for “interface_line_attribute7”

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

Overview

RA_INTERFACE_SALESCREDITS_ALL is the Oracle Receivables AutoInvoice interface table that holds sales credit information for transactions imported into Oracle E-Business Suite. When external source systems — order management, legacy billing platforms, or third-party applications — deliver transaction data to Receivables, the sales credit lines associated with each imported transaction are staged in this table before AutoInvoice validation and transfer. The table belongs to the AR schema and is present in both EBS 12.1.1 and 12.2.2.

Within the AutoInvoice architecture, RA_INTERFACE_SALESCREDITS_ALL operates as the child of RA_INTERFACE_LINES_ALL. Each row links to a parent interface line through INTERFACE_LINE_ID, and multiple sales credit rows may exist per line to represent revenue splits across salespersons, sales groups, and sales credit types. Records persist in the interface table after import and can be purged through the standard AutoInvoice purge program.

The documented physical schema for release 12.2.2 identifies 49 columns in the AR schema, with primary key RA_INTERFACE_SALESCREDITS_PK on INTERFACE_SALESCREDIT_ID and a unique index RA_INTERFACE_SALESCREDITS_U1 on the same column. The metadata's heuristic Data Vault classification is satellite-leaning, which suggests modeling this table as a satellite attached to a line-level hub rather than as an independent hub or link. This classification is a modeling suggestion derived from the foreign key structure, not a physical implementation directive.

Key Information Stored

The surrogate primary key is INTERFACE_SALESCREDIT_ID, populated from the RA_INTERFACE_SALESCREDITS_S sequence. The unique index RA_INTERFACE_SALESCREDITS_U1 on the same column confirms it as the sole business-key candidate documented in the metadata; it is a system-generated identifier rather than a natural business key.

The most significant columns include:

• INTERFACE_LINE_ID — joins the sales credit row to its parent transaction line in RA_INTERFACE_LINES_ALL.
• INTERFACE_LINE_CONTEXT and INTERFACE_LINE_ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield context and segment values propagated from the interface line for reporting and validation.
• SALESREP_NUMBER and SALESREP_ID — the salesperson identifier, supplied either by number or by internal ID.
• SALES_CREDIT_TYPE_NAME and SALES_CREDIT_TYPE_ID — the sales credit type (for example, quota or non-quota credit), with the ID resolving to SO_SALES_CREDIT_TYPES_115.
• SALES_CREDIT_AMOUNT_SPLIT and SALES_CREDIT_PERCENT_SPLIT — the revenue split assigned to the salesperson, expressed as an amount or a percentage.
• SALESGROUP_ID — the sales group associated with the credit, referencing JTF_RS_GROUPS_B.
• INTERFACE_STATUS — the processing state of the row during AutoInvoice validation.
• REQUEST_ID — the concurrent request that loaded or processed the record.
• ORG_ID — the operating unit, supporting multi-org partitioning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

The primary use case is diagnosing AutoInvoice import failures. Sales credit rows flagged with a non-success INTERFACE_STATUS value typically indicate missing salespersons, invalid credit types, or splits that do not reconcile to line amounts. A representative diagnostic query joins the sales credit table to the interface line table:

• SELECT sc.INTERFACE_SALESCREDIT_ID, sc.INTERFACE_LINE_ID, sc.SALESREP_NUMBER, sc.SALES_CREDIT_TYPE_NAME, sc.SALES_CREDIT_PERCENT_SPLIT, sc.INTERFACE_STATUS FROM RA_INTERFACE_SALESCREDITS_ALL sc WHERE sc.INTERFACE_STATUS = 'E' AND sc.REQUEST_ID = :request_id;

Reporting teams also use the table to audit revenue attribution before transfer, reconciling the sum of SALES_CREDIT_PERCENT_SPLIT per INTERFACE_LINE_ID against 100 percent. Because ORG_ID is present, all queries against multi-org environments should filter by operating unit. Purge and archival scripts frequently select on REQUEST_ID and CREATION_DATE to remove processed rows.

Related Objects

• RA_INTERFACE_LINES_ALL — parent table; join on INTERFACE_LINE_ID.
• RA_INTERFACE_DISTRIBUTIONS_ALL — sibling interface table for accounting distributions.
• JTF_RS_GROUPS_B — referenced by SALESGROUP_ID via the documented foreign key.
• SO_SALES_CREDIT_TYPES_115 — referenced by SALES_CREDIT_TYPE_ID.
• RA_CUST_TRX_LINE_SALESREPS_ALL — destination table receiving validated sales credit rows after AutoInvoice transfer.
• RA_CUSTOMER_TRX_LINES_ALL — the transaction line table populated from the interface line parent.
• AutoInvoice Import and Purge concurrent programs — the standard APIs and programs that read, validate, transfer, and purge rows in this table.