Search Results so_sales_credits_interface




Overview
Explore in AI Chat

Overview

The SO_SALES_CREDITS_INTERFACE table is a critical staging table within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically for versions 12.1.1 and 12.2.2. It serves as the primary data repository for importing sales credit information from external, non-Oracle systems or legacy data sources into the core Oracle Order Management tables. Its role is integral to the Order Import process (Order Management Super User > Orders, Returns > Import Orders), where interface tables act as a buffer zone for data validation and transformation before permanent insertion into the transactional schema. This table ensures that sales representative commissions and revenue attribution are correctly established for imported sales orders.

Key Information Stored

The table stores metadata and credit details necessary to assign sales credits to imported order lines. Its primary key is a composite of ORDER_SOURCE_ID, ORIGINAL_SYSTEM_LINE_REFERENCE, and ORIGINAL_SYSTEM_REFERENCE, which uniquely identifies a credit record for a specific line from a specific source system. Key columns include ORIGINAL_SYSTEM_REFERENCE (the header transaction identifier from the source system), ORIGINAL_SYSTEM_LINE_REFERENCE (the corresponding line identifier), and SALESREP_ID (linking to the RA_SALESREPS_ALL table to identify the credited salesperson). It also holds SALES_CREDIT_TYPE_ID and SALES_CREDIT_TYPE (linking to SO_SALES_CREDIT_TYPES_115), which define the commission rule or credit category, and the CREDIT_PERCENTAGE or CREDIT_AMOUNT assigned to the sales representative.

Common Use Cases and Queries

The primary use case is the batch import of sales credits via the Order Import concurrent program. A typical operational query checks for records pending processing or those that have errored, which is vital for troubleshooting failed imports. For example:

  • Identifying interface records for a specific source order: SELECT * FROM oe.so_sales_credits_interface WHERE original_system_reference = '&ext_order_num';
  • Validating data integrity before running the import: SELECT scr.* FROM oe.so_sales_credits_interface scr WHERE NOT EXISTS (SELECT 1 FROM ra_salesreps_all s WHERE s.salesrep_id = scr.salesrep_id);
  • Reporting on total credits staged by batch: SELECT request_id, COUNT(*), SUM(credit_amount) FROM oe.so_sales_credits_interface GROUP BY request_id;

After successful import, records are typically purged from this interface table.

Related Objects

SO_SALES_CREDITS_INTERFACE has defined relationships with several core EBS objects, as per the provided metadata. It is a child table to SO_HEADERS_INTERFACE_ALL via the ORIGINAL_SYSTEM_REFERENCE foreign key, ensuring credit data is associated with a valid staged order header. Its critical foreign keys to RA_SALESREPS_ALL (for salesrep validation) and SO_SALES_CREDIT_TYPES_115 (for credit type validation) enforce business rules. The processed data ultimately populates the transactional table SO_SALES_CREDITS. The Order Import concurrent program (OE_ORDER_PUB.PROCESS_ORDER) is the primary API-driven process that reads from this interface, validates using the related tables, and moves data into the Order Management base tables.