Results for “revenue_percent_split”

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

Overview

FII_AR_SALES_CREDITS is an intermediate staging table owned by the FII (Financial Intelligence) schema in Oracle EBS 12.1.1 and 12.2.2. It stores sales credit assignment records associated with Oracle Receivables (AR) transactions. In the Oracle E-Business Suite architecture, FII tables such as this function as extract and transformation layers that support Oracle Financial Intelligence and related analytical or data warehouse products. Rather than holding transactional data authored directly by users, the table captures sales credit distributions for invoice lines so that revenue attribution, salesperson performance, and commission-related reporting can be performed against a consolidated and denormalized structure.

From a heuristic Data Vault modeling perspective, the FK structure mined from the metadata classifies this table as a link. It resolves relationships between multiple business entities — a sales credit record, an invoice line, a sales representative, and a sales group — rather than acting as a standalone hub or a descriptive satellite. This classification is a modeling suggestion, not an Oracle-documented designation.

Key Information Stored

The table contains 10 documented columns in the 12.1.1 physical schema. The most significant include:

• SALESCREDIT_PK — The surrogate primary key, enforced by the unique index FII_AR_SALES_CREDITS_U1 and the constraint FII_AR_SALES_CREDITS_PK. It uniquely identifies each sales credit row and serves as the foreign key to RA_CUST_TRX_LINE_SALESREPS_ALL.
• INVOICE_LINE_ID — Foreign key to RA_CUSTOMER_TRX_LINES_ALL, tying the sales credit to a specific invoice line.
• SALESREP_ID — Foreign key to JTF_RS_SALESREPS, identifying the salesperson receiving the credit.
• SALESGROUP_ID — Foreign key to JTF_RS_GROUPS_B, identifying the sales group associated with the credit.
• REVENUE_PERCENT_SPLIT — The percentage of revenue attributed to the salesperson or group for that line.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN, which support lineage and change tracking.

SALESCREDIT_PK is the documented primary key and unique business-key candidate. No secondary unique indexes are documented in the provided metadata.

Common Use Cases and Queries

Typical scenarios involve reconciling AR sales credits to invoice lines, reporting revenue by salesperson or sales group, and validating credit percentage splits before loading into downstream FII or warehouse targets. A representative query joining the credit row to its invoice line looks like:

• SELECT c.SALESCREDIT_PK, c.INVOICE_LINE_ID, c.SALESREP_ID, c.REVENUE_PERCENT_SPLIT FROM FII_AR_SALES_CREDITS c JOIN RA_CUSTOMER_TRX_LINES_ALL l ON c.INVOICE_LINE_ID = l.CUSTOMER_TRX_LINE_ID WHERE c.SALESREP_ID = :salesrep_id;
• Aggregation by sales group: SELECT SALESGROUP_ID, SUM(REVENUE_PERCENT_SPLIT) FROM FII_AR_SALES_CREDITS GROUP BY SALESGROUP_ID;
• Validation of orphan credits by outer-joining to RA_CUST_TRX_LINE_SALESREPS_ALL on SALESCREDIT_PK.

Related Objects

The table participates in four documented foreign-key relationships and is tightly coupled to the following objects:

• RA_CUST_TRX_LINE_SALESREPS_ALL — joined on SALESCREDIT_PK; the source AR sales credit assignment.
• RA_CUSTOMER_TRX_LINES_ALL — joined on INVOICE_LINE_ID; the invoice line context.
• JTF_RS_SALESREPS — joined on SALESREP_ID; the salesperson resource.
• JTF_RS_GROUPS_B — joined on SALESGROUP_ID; the sales group definition.

These relationships confirm the table's role as a link between AR transaction lines and Oracle resource/resource-group master data, supporting sales credit analytics across the Receivables and Financial Intelligence modules.