|
Several scripts that must be run were combined into one script that runs all of them (ff_cust.sql). Instructions modified to reflect this new script. |
|
|
New program used to purge cancelled, closed, and lost projects from the system. |
|
|
For project classes with the Billing Source of Revenue Budget, modified the calculation so that the revenue budget for the created project line comes from the extended price on the quotation line. Modified to allow creation of projects from quotations with the status Won. Added Frequency, Total Cycles, and First Billing Date for the creation recurring billing project lines. |
|
|
The multi-client fulfillment capabilities of NDS can be implemented using Oracle's Row-Level Security/Virtual Private Database (VPD) capabilities available in Oracle Enterprise Server. This eliminates the need to maintain separate database schemas for each client, with the attendant costs of administration. Implementation of the virtual private database is instance wide. A separate schema is used to store and control the access for all other schemas in the instance. While configuring and using the virtual private database is fairly straightforward, migrating a separate-schema fulfillment system to a single schema presents some challenges. Careful treatment of the data is necessary to prevent data loss during the migration. It is recommended that the user contact NDS Professional Services for consultation before attempting the migration. |