This chapter consists of the standard functions provided by Oracle Number Portability
This chapter covers the following topics:
You receive the following number portability standard function activities with the application:
| Name | Description |
|---|---|
| Check Flag Value | Checks the flag value for the given PORTING_ID workitem parameter. |
| Check if Donor is eligible to Port Out | Checks whether or not the donor service provider in this porting transaction has provisioned the number range, or has assigned the number range. If either condition is true, then the activity completes with Y. |
| Check if Donor is Initial Donor | Checks whether or not this donor is also the initial donor. |
| Create or Modify SMS Porting Records | Creates or modifies a Porting Record for each telephone number in the range. The Porting ID for the first record is the same as that set in the work item parameter. |
| Create Porting Order | Creates a porting order based on the Service Provider role. |
| Deprovision FEs | Sets the fulfillment elements to be deprovisioned for this feature type and number range. For each fulfillment element, the Oracle Service Fulfillment Manager provisioning procedure (Execute FA) is invoked. At the end of this activity, control passes to the provisioning subsystem which executes the fulfillment procedure. An FA_ DONE message is subscribed for each fulfillment action being executed which gives the execution result of the fulfillment procedure. The callback procedure associated with the FA_ DONE handles the responses received. The immediate next activity following this activity must be the Oracle Service Fulfillment Manager Standard Wait For Flow. This is to ensure proper hand-off from the provisioning system back to the Number Portability system. Only fulfillment elements that were earlier provisioned by this service provider can be modified. Otherwise, the fulfillment elements are ignored. |
| Determine Current Service Provider Role | Determines whether or not a given service provider is the donor, original donor, or recipient for the current porting transaction, and completes the activity with the appropriate result code. |
| Determine if Subsequent Porting Request | Checks whether or not this is a subsequent porting request. Returns either Y or N. |
| Does Porting Record exist for Donor | Check whether or not there exists a porting record with the given status in this telephone number range that belongs to the given donor’s service provider ID. Returns either Y or N. |
| Does Porting Record exist for Recipient | Check whether or not a porting record with the given status exists in this telephone number range that belongs to the given recipient’s service provider ID. Returns either Y or N. |
| Get Porting Status | Retrieves the status of the porting record for the given PortingID |
| Prepare Notification Message | Prepares a default notification message. |
| Provision or Modify Provisioned FEs | Sets or retrieves the fulfillment elements to be provisioned or modified for this feature type and number range. For each fulfillment element, the Service Delivery Platform’s provisioning procedure (Execute FA) is invoked. At the end of this activity, control passes to the provisioning subsystem which executes the fulfillment procedure. An FA_ DONE message is subscribed for each fulfillment action being executed which gives the execution result of the fulfillment procedure. The callback procedure associated with the FA_ DONE handles the responses received. The immediate next activity following the activity must be SFM Standard Wait For Flow. This is to ensure proper hand-off from the provisioning system back to the Number Portability system. Only fulfillment elements that were earlier provisioned by this service provider can be modified. |
| Set Date Value | Sets the Date value |
| Set Flag Value | Sets the flag to the given value for the entries in XNP_SV_SOA for the given PORTING_ID workitem parameter, and FLAG_ NAME for the current Service Provider. Accepted values are 'Y' or 'N’. |
| Set SMS Provisioning Done Date | Sets the date when the Service Management System completes provisioning |
| Update Charging Information | Updates the Subscription Version in the Service Order Administrator for each telephone number with the given Porting ID, with invoice information. |
| Update Comments and Notes Information | Updates the comments and notes for the current Porting ID and the current service provider. |
| Update Customer Information | Updates the customer information for the current Porting ID and the current service provider. |
| Update Network Information in SOA | Updates the network information in the XNP_SV_SOA for the current Porting ID and the current service provider. |
| Update Porting Status for Number Range | Updates the status type code in the XNP_SV_SOA with the new status type code. All records with the porting ID belonging to the current service provider are updated to the new status. If the new status belongs to the ACTIVE phase, and if records exist for this number range in ACTIVE phase, then these records are first reset to the OLD phase. The actual update of the records with the given porting ID is performed after this step. |
| Update Porting Status for Porting Id | Updates the status type code in the XNP_SV_SOA with the new status type code. All records with the porting id and belonging to the current service provider are updated to the new status. If the new status belongs to the ACTIVE phase, and if there exists records for this number range already in ACTIVE phase, then they first are reset to OLD phase. The actual update of the records with the given porting id is done next. |
| Validate Runtime Data | Validates runtime data. |
| Verify Porting Status | Checks if the STATUS_TYPE_CODE from XNP_SV_SOA for the given PORTING_ID is same as the given status type code (in STATUS_TO_COMPARE_WITH). Returns T if the two statuses match. Returns F if the two statuses do not match. |
Work items are organized into groups known as item types. The following table lists the standard item types delivered with Oracle Number Portability.
Note: Do not modify any of the standard Oracle Number Portability item types, except NP Processes.
| Item Type | Internal Name | Description | Customizable |
|---|---|---|---|
| Standard | WFSTD | Contains standard function activities that are commonly used to create business processes. | No |
| SFM Standard | XDPWFSTD | Contains function activities that are commonly used across both the Oracle Service Fulfillment Manager and Oracle Number Portability applications. The following are examples of functions:
|
No |
| SFM Lookup Code | XDPCODES | Contains lookup types used for easy selection in workflow activities. This could be, for example, a list of fulfillment actions, or a list of messages. | No |
| NP Standard | XNPWFSTD | Contains function activities that are specific to Oracle Number Portability. Use these activities in the implementation of your business processes. The following are examples of standard functions:
|
No |
| NP Lookup Code | XNPTYPES | Contains lookup types used for easy selection in workflow activities. This could be, for example, a list of fulfillment actions, or a list of messages. | No |
In general, you should use the SFM Standard and NP Standard function activities whenever possible, and only customize the Number Portability activities as absolutely necessary.
SFM Lookups and NP Lookups must be updated as you start to configure Oracle Service Fulfillment Manager. Run the Lookups Loader API to update these item types.
The Oracle Number Portability application is seeded with a number of fulfillment element types. The following table lists these predefined element types.
| Element Type | Description |
|---|---|
| BILLING_ GATEWAY | Refers to billing system gateway |
| DIRECTORY_ GATEWAY | Refers to directory assistance gateway |
| NRC_GATEWAY | Refers to the Number Registration Center gateway |
| SCP | Refers to the LNP database for all service control points |
| SP_GATEWAY | Refers to messaging gateways for remote systems of other service providers |
| SSP | Refers to signal switching point |
| STP | Refers to signal transfer point |