XNP Tables (40)

XNP - Number Portability — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
`XNP_AUDIT_DISCREPANCIES`	37	Stores mismatched network data for a given service provider and subscription version
`XNP_AUDIT_SMS_FAILURES`	10	Stores a list of service providers that failed to provide the requested audit information. This is an optional list in the audit results.
`XNP_CALLBACK_EVENTS`	20	Contains instances of message types for which one or more applications have registered
`XNP_DEBUG`	10	Stores general debug information in NP system
`XNP_EVENT_SUBSCRIBERS`	10	Stores a list of subscribers for a given message type
`XNP_GEO_AREAS_B`	11	Stores given geographic areas
`XNP_GEO_AREAS_TL`	12	Translation table to XNP_GEO_AREAS_B
`XNP_GEO_HIERARCHY`	10	Holds information about the geographic area hierarchy
`XNP_INTERCONNECT_AREAS`	9	Stores geographic area covered by a routing number
`XNP_MSGS`	26	Stores the actual instance of a message that passes over a network association
`XNP_MSG_ACKS`	10	Contains message relationships
`XNP_MSG_ATTR_VALUES`	10	Contains attribute values for XML message elements
`XNP_MSG_ELEMENTS`	16	Contains XML message elements
`XNP_MSG_ELEMENT_ATTR`	12	Contains attributes of XML elements
`XNP_MSG_STRUCTURES`	19	Contains the structural relationship or hierarchy of all the elements in the XML message
`XNP_MSG_TYPES_B`	20	Contains data dictionary for the message
`XNP_MSG_TYPES_TL`	12	Translation table to XNP_MSG_TYPES_B
`XNP_NETWORK_MAPS`	10	Stores the relationship between network elements
`XNP_NUMBER_RANGES`	22	Stores information about the characteristics of a service provider's telephone number ranges
`XNP_NUMBER_SPLITS`	12	Stores information about a number split including the old number range, new number range and algorithm to convert from the old number to the
`XNP_ROUTING_NUMBERS`	14	Stores routing numbers which are used to deliver ported telephone numbers to the appropriate service provider
`XNP_SERVED_NUM_RANGES`	13	Stores the mapping of number ranges served by network element for each feature type
`XNP_SERVICE_AREAS`	10	Stores geographic areas served by a service provider
`XNP_SERVICE_PROVIDERS`	35	Stores service provider definitions
`XNP_SP_ADAPTERS`	12	Stores mapping of a service provider to an external system
`XNP_SP_CONTACTS`	24	Stores contact information for a service provider
`XNP_SP_FILTERS`	12	Stores the number ranges for which a service provider does not want to be informed of subscription broadcasts
`XNP_SV_AUDITS`	26	Stores all subscription audits issued from a service provider
`XNP_SV_EVENT_HISTORY`	13	Stores information about any kind of event on the porting number or message
`XNP_SV_FAILURES`	12	Stores a list of service providers that failed to download subscription version data
`XNP_SV_ORDER_MAPPINGS`	11	Stores event information associated with subscription versions or messages.
`XNP_SV_SMS`	26	Container object for subscription versions downloaded to the network
`XNP_SV_SMS_FE_MAPS`	11	Stores a list of fulfillment elements provisioned with subscription version data
`XNP_SV_SOA`	101	Container object for a porting request on a single telephone number
`XNP_SV_SOA_JN`	105	Journalling table for the XNP_SV_SOA table
`XNP_SV_STATUS_TYPES_B`	13	Subsription version status definition
`XNP_SV_STATUS_TYPES_TL`	12	Translation table to XNP_SV_STATUS_TYPES_B
`XNP_SYNC_REGISTRATION`	12	Maintains the state of synchronized workflows
`XNP_TIMER_PUBLISHERS`	10	Stores timers related to a message
`XNP_TIMER_REGISTRY`	16	Stores a list of all timers in progress