Search Results xnp_service_providers

Overview

The XNP_SERVICE_PROVIDERS table is a core master data table within the Oracle E-Business Suite (EBS) Number Portability (XNP) module. It serves as the central repository for defining and managing all telecommunications service providers (SPs) involved in number portability processes. In the context of EBS 12.1.1 and 12.2.2, this table is fundamental to the XNP application's operation, as it uniquely identifies every entity—such as donor, recipient, or mediator—that participates in the porting of telephone numbers between networks. Its integrity is critical for routing, auditing, and executing all portability transactions.

Key Information Stored

While the provided metadata does not list individual columns, the primary and unique key structures define the table's essential identifying attributes. The primary key is the SP_ID column, which is a unique system-generated identifier for each service provider record. The table also enforces a unique constraint (XNP_SERVICE_PROVIDERS_UK1) on the CODE column, which typically stores a business-friendly, unique abbreviation or code for the service provider (e.g., 'TELCO_A'). Other columns, inferred from standard practice and related foreign key relationships, would include descriptive fields such as NAME, STATUS, ADDRESS information, and configuration flags that control the provider's role and behavior within the number portability ecosystem.

Common Use Cases and Queries

This table is primarily referenced for master data lookups, validation, and reporting. Common operational and technical use cases include validating a service provider's existence during order entry, determining roles in a porting request, and generating provider-specific audit reports. A typical query would join this table to various transaction tables to enrich data with provider names.

Basic Lookup: SELECT sp_id, code, name FROM xnp_service_providers WHERE status = 'ACTIVE';
Transaction Enrichment: SELECT sv.order_number, sp_donor.code AS donor_code, sp_recipient.code AS recipient_code FROM xnp_sv_soa sv JOIN xnp_service_providers sp_donor ON sv.donor_sp_id = sp_donor.sp_id JOIN xnp_service_providers sp_recipient ON sv.recipient_sp_id = sp_recipient.sp_id;
Reporting Active Providers: SELECT sp.code, sp.name, COUNT(rng.number_range_id) AS assigned_range_count FROM xnp_service_providers sp LEFT JOIN xnp_number_ranges rng ON sp.sp_id = rng.assigned_sp_id GROUP BY sp.code, sp.name;

Related Objects

The XNP_SERVICE_PROVIDERS table has extensive foreign key relationships, underscoring its central role. Key related transactional and master tables include:

XNP_NUMBER_RANGES: Links via OWNING_SP_ID and ASSIGNED_SP_ID to define number block ownership and current assignment.
XNP_SV_SOA & XNP_SV_SOA_JN: Core porting order tables referencing SP_ID for DONOR, RECIPIENT, CREATED_BY, CHANGED_BY, and MEDIATOR roles.
XNP_SV_AUDITS, XNP_AUDIT_DISCREPANCIES, XNP_SV_FAILURES: Audit and error tracking tables linked via SP_ID or FOR_SP_ID.
XNP_ROUTING_NUMBERS, XNP_SERVICE_AREAS: Configuration tables that associate routing and geographic data with a specific provider.
XNP_SP_ADAPTERS, XNP_SP_CONTACTS, XNP_SP_FILTERS: Supporting tables storing technical integration details, contact information, and business rules for each provider.

Table: XNP_SERVICE_PROVIDERS 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SERVICE_PROVIDERS, object_name:XNP_SERVICE_PROVIDERS, status:VALID, product: XNP - Number Portability , description: Stores service provider definitions , implementation_dba_data: XNP.XNP_SERVICE_PROVIDERS ,
Table: XNP_SERVICE_PROVIDERS 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SERVICE_PROVIDERS, object_name:XNP_SERVICE_PROVIDERS, status:VALID, product: XNP - Number Portability , description: Stores service provider definitions , implementation_dba_data: XNP.XNP_SERVICE_PROVIDERS ,
Table: XNP_SV_SOA 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SV_SOA, object_name:XNP_SV_SOA, status:VALID, product: XNP - Number Portability , description: Container object for a porting request on a single telephone number , implementation_dba_data: XNP.XNP_SV_SOA ,
Table: XNP_SV_SOA_JN 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SV_SOA_JN, object_name:XNP_SV_SOA_JN, status:VALID, product: XNP - Number Portability , description: Journalling table for the XNP_SV_SOA table , implementation_dba_data: XNP.XNP_SV_SOA_JN ,
Table: XNP_SV_SOA_JN 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SV_SOA_JN, object_name:XNP_SV_SOA_JN, status:VALID, product: XNP - Number Portability , description: Journalling table for the XNP_SV_SOA table , implementation_dba_data: XNP.XNP_SV_SOA_JN ,
Table: XNP_SV_SOA 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SV_SOA, object_name:XNP_SV_SOA, status:VALID, product: XNP - Number Portability , description: Container object for a porting request on a single telephone number , implementation_dba_data: XNP.XNP_SV_SOA ,
Table: XNP_NUMBER_RANGES 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_NUMBER_RANGES, object_name:XNP_NUMBER_RANGES, status:VALID, product: XNP - Number Portability , description: Stores information about the characteristics of a service provider's telephone number ranges , implementation_dba_data: XNP.XNP_NUMBER_RANGES ,
Table: XNP_SV_AUDITS 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SV_AUDITS, object_name:XNP_SV_AUDITS, status:VALID, product: XNP - Number Portability , description: Stores all subscription audits issued from a service provider , implementation_dba_data: XNP.XNP_SV_AUDITS ,
Table: XNP_SV_AUDITS 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SV_AUDITS, object_name:XNP_SV_AUDITS, status:VALID, product: XNP - Number Portability , description: Stores all subscription audits issued from a service provider , implementation_dba_data: XNP.XNP_SV_AUDITS ,
Table: XNP_NUMBER_RANGES 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_NUMBER_RANGES, object_name:XNP_NUMBER_RANGES, status:VALID, product: XNP - Number Portability , description: Stores information about the characteristics of a service provider's telephone number ranges , implementation_dba_data: XNP.XNP_NUMBER_RANGES ,
Table: XNP_SP_CONTACTS 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SP_CONTACTS, object_name:XNP_SP_CONTACTS, status:VALID, product: XNP - Number Portability , description: Stores contact information for a service provider , implementation_dba_data: XNP.XNP_SP_CONTACTS ,
Table: XNP_SP_ADAPTERS 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SP_ADAPTERS, object_name:XNP_SP_ADAPTERS, status:VALID, product: XNP - Number Portability , description: Stores mapping of a service provider to an external system , implementation_dba_data: XNP.XNP_SP_ADAPTERS ,
View: XNP_SV_SOA_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:XNP.XNP_SV_SOA_VL, object_name:XNP_SV_SOA_VL, status:VALID, product: XNP - Number Portability , description: Shows porting information for a single telephone number. Removed ( SVA.CREATED_BY_SP_ID=SPR_OWN.SP_ID ) from WHERE clausefor Service Bureau, since this will be handled automagically by VPD. rnyberg, 11/06/2000. , implementation_dba_data: APPS.XNP_SV_SOA_VL ,
Table: XNP_AUDIT_DISCREPANCIES 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_AUDIT_DISCREPANCIES, object_name:XNP_AUDIT_DISCREPANCIES, status:VALID, product: XNP - Number Portability , description: Stores mismatched network data for a given service provider and subscription version , implementation_dba_data: XNP.XNP_AUDIT_DISCREPANCIES ,
Table: XNP_SP_ADAPTERS 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SP_ADAPTERS, object_name:XNP_SP_ADAPTERS, status:VALID, product: XNP - Number Portability , description: Stores mapping of a service provider to an external system , implementation_dba_data: XNP.XNP_SP_ADAPTERS ,
View: XNP_SV_SMS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:XNP.XNP_SV_SMS_V, object_name:XNP_SV_SMS_V, status:VALID, product: XNP - Number Portability , description: Shows porting information broadcasted by the NRC for the intention of network update , implementation_dba_data: APPS.XNP_SV_SMS_V ,
View: XNP_SV_SMS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:XNP.XNP_SV_SMS_V, object_name:XNP_SV_SMS_V, status:VALID, product: XNP - Number Portability , description: Shows porting information broadcasted by the NRC for the intention of network update , implementation_dba_data: APPS.XNP_SV_SMS_V ,
Table: XNP_SP_FILTERS 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SP_FILTERS, object_name:XNP_SP_FILTERS, status:VALID, product: XNP - Number Portability , description: Stores the number ranges for which a service provider does not want to be informed of subscription broadcasts , implementation_dba_data: XNP.XNP_SP_FILTERS ,
Table: XNP_SV_SMS 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SV_SMS, object_name:XNP_SV_SMS, status:VALID, product: XNP - Number Portability , description: Container object for subscription versions downloaded to the network , implementation_dba_data: XNP.XNP_SV_SMS ,
Table: XNP_SV_SMS 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SV_SMS, object_name:XNP_SV_SMS, status:VALID, product: XNP - Number Portability , description: Container object for subscription versions downloaded to the network , implementation_dba_data: XNP.XNP_SV_SMS ,
View: XNP_SV_SOA_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:XNP.XNP_SV_SOA_VL, object_name:XNP_SV_SOA_VL, status:VALID, product: XNP - Number Portability , description: Shows porting information for a single telephone number. Removed ( SVA.CREATED_BY_SP_ID=SPR_OWN.SP_ID ) from WHERE clausefor Service Bureau, since this will be handled automagically by VPD. rnyberg, 11/06/2000. , implementation_dba_data: APPS.XNP_SV_SOA_VL ,
Table: XNP_SP_CONTACTS 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SP_CONTACTS, object_name:XNP_SP_CONTACTS, status:VALID, product: XNP - Number Portability , description: Stores contact information for a service provider , implementation_dba_data: XNP.XNP_SP_CONTACTS ,
Table: XNP_SV_FAILURES 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SV_FAILURES, object_name:XNP_SV_FAILURES, status:VALID, product: XNP - Number Portability , description: Stores a list of service providers that failed to download subscription version data , implementation_dba_data: XNP.XNP_SV_FAILURES ,
Table: XNP_SERVICE_AREAS 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SERVICE_AREAS, object_name:XNP_SERVICE_AREAS, status:VALID, product: XNP - Number Portability , description: Stores geographic areas served by a service provider , implementation_dba_data: XNP.XNP_SERVICE_AREAS ,
Table: XNP_AUDIT_DISCREPANCIES 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_AUDIT_DISCREPANCIES, object_name:XNP_AUDIT_DISCREPANCIES, status:VALID, product: XNP - Number Portability , description: Stores mismatched network data for a given service provider and subscription version , implementation_dba_data: XNP.XNP_AUDIT_DISCREPANCIES ,
Table: XNP_SP_FILTERS 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SP_FILTERS, object_name:XNP_SP_FILTERS, status:VALID, product: XNP - Number Portability , description: Stores the number ranges for which a service provider does not want to be informed of subscription broadcasts , implementation_dba_data: XNP.XNP_SP_FILTERS ,
Table: XNP_AUDIT_SMS_FAILURES 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_AUDIT_SMS_FAILURES, object_name:XNP_AUDIT_SMS_FAILURES, status:VALID, product: XNP - Number Portability , description: Stores a list of service providers that failed to provide the requested audit information. This is an optional list in the audit results. , implementation_dba_data: XNP.XNP_AUDIT_SMS_FAILURES ,
Table: XNP_AUDIT_SMS_FAILURES 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_AUDIT_SMS_FAILURES, object_name:XNP_AUDIT_SMS_FAILURES, status:VALID, product: XNP - Number Portability , description: Stores a list of service providers that failed to provide the requested audit information. This is an optional list in the audit results. , implementation_dba_data: XNP.XNP_AUDIT_SMS_FAILURES ,
Table: XNP_SERVICE_AREAS 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SERVICE_AREAS, object_name:XNP_SERVICE_AREAS, status:VALID, product: XNP - Number Portability , description: Stores geographic areas served by a service provider , implementation_dba_data: XNP.XNP_SERVICE_AREAS ,
Table: XNP_SV_FAILURES 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_SV_FAILURES, object_name:XNP_SV_FAILURES, status:VALID, product: XNP - Number Portability , description: Stores a list of service providers that failed to download subscription version data , implementation_dba_data: XNP.XNP_SV_FAILURES ,
Table: XNP_ROUTING_NUMBERS 12.1.1
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_ROUTING_NUMBERS, object_name:XNP_ROUTING_NUMBERS, status:VALID, product: XNP - Number Portability , description: Stores routing numbers which are used to deliver ported telephone numbers to the appropriate service provider , implementation_dba_data: XNP.XNP_ROUTING_NUMBERS ,
Table: XNP_ROUTING_NUMBERS 12.2.2
owner:XNP, object_type:TABLE, fnd_design_data:XNP.XNP_ROUTING_NUMBERS, object_name:XNP_ROUTING_NUMBERS, status:VALID, product: XNP - Number Portability , description: Stores routing numbers which are used to deliver ported telephone numbers to the appropriate service provider , implementation_dba_data: XNP.XNP_ROUTING_NUMBERS ,