Search Results so_sales_credits_interface




Overview
Explore in AI Chat

Overview

SO_SALES_CREDITS_INTERFACE is an Order Entry (OE) module interface table that stages imported sales credit information before it is validated and transferred into the permanent sales credit tables of Oracle E-Business Suite. Sales credits allocate revenue and quota responsibility for an order line to one or more sales representatives, and this interface exists to receive that attribution data from external order capture systems, legacy migrations, or bulk conversion programs prior to the Order Import process. The table is owned by the OE schema and is documented as VALID in both ETRM 12.1.1 and 12.2.2 references.

The documented physical schema lists 40 columns. The table carries the standard Oracle interface audit columns together with a set of denormalized descriptive fields (SALESREP_NAME, SALES_CREDIT_TYPE, PERCENT) that allow importing systems to supply human-readable values rather than only internal identifiers. This dual representation supports the Order Import validation logic, which resolves names to IDs and rejects or flags records it cannot reconcile.

Based on the mined foreign key structure, the table can be modeled heuristically as a Data Vault link: its primary key composes multiple business references that connect an order header reference, an order line reference, and an order source, functioning as an associative relationship between those entities rather than as a standalone descriptive hub or satellite.

Key Information Stored

The primary key is SO_SALES_CREDITS_INTERFACE_PK, defined over the composite of ORDER_SOURCE_ID, ORIGINAL_SYSTEM_LINE_REFERENCE, and ORIGINAL_SYSTEM_REFERENCE. These three columns are the business-key candidates that uniquely identify a staged sales credit row and tie it back to the originating order header and line in the source system.

  • ORIGINAL_SYSTEM_REFERENCE — identifies the source order header; foreign key to SO_HEADERS_INTERFACE_ALL.
  • ORIGINAL_SYSTEM_LINE_REFERENCE — identifies the source order line within that header.
  • ORDER_SOURCE_ID — identifies the order source (originating system) for the record.
  • SALESREP_ID — the internal sales representative identifier; foreign key to RA_SALESREPS_ALL.
  • SALESREP_NAME — descriptive sales representative name used during resolution.
  • SALES_CREDIT_TYPE_ID — internal credit type identifier; foreign key to SO_SALES_CREDIT_TYPES_115.
  • SALES_CREDIT_TYPE — descriptive credit type (for example, quota or non-quota sales credit); also foreign keyed to SO_SALES_CREDIT_TYPES_115.
  • QUOTA_FLAG — indicates whether the credit counts toward quota.
  • PERCENT — the percentage of the line amount allocated to this sales representative.
  • USE_IDS_FLAG — signals whether the importing system supplied internal IDs or descriptive names, driving name-to-ID resolution during import.
  • LINE_NUMBER and LINE_TYPE — the source line number and line category the credit applies to.
  • INTERFACE_STATUS, ERROR_FLAG, and OPERATION_CODE — control columns indicating the processing state, error state, and intended operation (insert, update, delete) for each staged row.
  • REQUEST_ID and PROGRAM_APPLICATION_ID/PROGRAM_ID — identify the concurrent request and program that populated the row.

Common Use Cases and Queries

The dominant use case is the Order Import concurrent program, which reads rows from this interface, validates the sales representative and credit type, resolves names to IDs, and writes the resulting credit records into the permanent sales credit structures. Reporting queries most often reconcile the interface against its sources and targets.

  • Identifying rejected or unprocessed rows: SELECT ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE, SALESREP_NAME, ERROR_FLAG FROM SO_SALES_CREDITS_INTERFACE WHERE ERROR_FLAG = 'Y';
  • Checking the status of a submitted import run: filter on REQUEST_ID or INTERFACE_STATUS to gauge progress and success.
  • Validating name-to-ID resolution by joining SALESREP_NAME to RA_SALESREPS_ALL and SALES_CREDIT_TYPE to SO_SALES_CREDIT_TYPES_115.
  • Verifying percentage allocation integrity, ensuring credits for a given line reference sum to 100 percent.
  • Auditing the population of a batch by grouping on PROGRAM_APPLICATION_ID, PROGRAM_ID, and CREATION_DATE.

Related Objects

The following objects are the most significant for dependency and join purposes, based on documented foreign key relationships:

  • SO_HEADERS_INTERFACE_ALL — joined on ORIGINAL_SYSTEM_REFERENCE; holds the staged order header the credit belongs to.
  • RA_SALESREPS_ALL — joined on SALESREP_ID; the sales representative master that resolves representative identity.
  • SO_SALES_CREDIT_TYPES_115 — joined on both SALES_CREDIT_TYPE_ID and SALES_CREDIT_TYPE; defines valid credit type categories.
  • SO_LINES_INTERFACE_ALL — the companion line-level interface, typically coordinated through ORIGINAL_SYSTEM_LINE_REFERENCE and ORIGINAL_SYSTEM_REFERENCE.
  • Order Import concurrent program — the primary consumer that processes rows from this interface into the permanent OE sales credit tables.