Difference between revisions of "V1.4 SP 20.0"
From FPDS-NG
(13 intermediate revisions by the same user not shown) | |||
Line 4: | Line 4: | ||
<tr><th width=30% align="center"><b>Description</b></th><th width=34% align="center"><b>Start Date</b></th> | <tr><th width=30% align="center"><b>Description</b></th><th width=34% align="center"><b>Start Date</b></th> | ||
<th width=34% align="center"><b>End Date</b></th></tr> | <th width=34% align="center"><b>End Date</b></th></tr> | ||
− | <tr><td nowrap>BETA Installation </td><td nowrap>Thursday June 13, 2013</td><td nowrap> | + | <tr><td nowrap>BETA Installation </td><td nowrap>Thursday June 13, 2013</td><td nowrap>Friday June 14, 2013</td></tr> |
− | <tr><td nowrap>Functional Qualification Testing </td><td nowrap> | + | <tr><td nowrap>Functional Qualification Testing </td><td nowrap>Tuesday June 18, 2013</td><td nowrap>Thursday June 20, 2013</td></tr> |
<tr><td nowrap>Installation in Production</td><td nowrap>Friday June 28, 2013</td><td nowrap>Friday June 28, 2013</td></tr> | <tr><td nowrap>Installation in Production</td><td nowrap>Friday June 28, 2013</td><td nowrap>Friday June 28, 2013</td></tr> | ||
</table> | </table> | ||
Line 16: | Line 16: | ||
<tr><td nowrap>NASA Specific Data Dictionary</td><td align="center">No</td></tr> | <tr><td nowrap>NASA Specific Data Dictionary</td><td align="center">No</td></tr> | ||
<tr><td nowrap>Use Case Summary</td><td align="center">No</td></tr> | <tr><td nowrap>Use Case Summary</td><td align="center">No</td></tr> | ||
− | <tr><td nowrap>Validation Rules</td><td align="center"> | + | <tr><td nowrap>Validation Rules</td><td align="center">Yes</td></tr> |
<tr><td nowrap>Reporting</td><td align="center">Yes</td></tr> | <tr><td nowrap>Reporting</td><td align="center">Yes</td></tr> | ||
<tr><td nowrap>ezSearch</td><td align="center">Yes</td></tr> | <tr><td nowrap>ezSearch</td><td align="center">Yes</td></tr> | ||
Line 28: | Line 28: | ||
<th width=18% align="center"><b>SPR #</b></th><th width=30% align="center"><b>Enhancement/Problem</b></th><th width=38% align="center"><b>Solution</b></th><th width=25% align="center"><b>Impact to Users and Integrators</b></th> | <th width=18% align="center"><b>SPR #</b></th><th width=30% align="center"><b>Enhancement/Problem</b></th><th width=38% align="center"><b>Solution</b></th><th width=25% align="center"><b>Impact to Users and Integrators</b></th> | ||
<tr> | <tr> | ||
− | |||
− | |||
− | <td> | + | <td style="width:95px" valign="center">FPDSIRB-192</td> |
+ | <td>FPDS-NG is incorrectly allowing selection of a 1-character or 2-character PSC Category on an Other Transaction Award or IDV and the records may be approved with such a value. | ||
+ | |||
+ | <td>FPDS-NG shall only display 4-character PSCs in the look-up screen and shall only allow 4-character PSCs to be validated and approved successfully on an Other Transaction Award or IDV. | ||
</td> | </td> | ||
Line 37: | Line 38: | ||
<tr> | <tr> | ||
− | |||
− | |||
− | <td> | + | <td style="width:95px" valign="center">FPDSHD-116158</td> |
+ | <td>It is reported that records are missing from FPDS-NG Standard Reports, but the data exists in the Award database. The records missing from reports are found to not have data in two of the tables containing vendor information about each record. The missing data in these tables has caused the records to not be included in the nightly refresh that would include them in the Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds. This does not impact the Data Archives as they are generated from the transactional tables. | ||
+ | |||
+ | Vendor information is saved to 4 different tables when an Award or IDV is saved in FPDS-NG: Vendor, Vendor Location, Socio-Economic Indicators, and Business Types. The issue has occurred because a server has thrown an exception that was not handled and data was not stored to all 4 tables for a given transaction. | ||
+ | |||
+ | <td>1. FPDS-NG shall not store partial information of the vendor while finalizing a contract. FPDS-NG shall store complete Vendor information in all four tables (Vendor, Vendor Location, Socio-Economic Indicators, and Business Types) on all final records. This will ensure that records appear in Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds. | ||
− | + | 2. The exception that has occurred to cause the issue shall be handled so that if the transaction cannot be completed with data in all 4 Vendor tables (Vendor, Vendor Location, Socio-Economic Indicators, and Business Types), then the transaction shall be rolled back and no partial entry shall be permitted.CWS will get the system error when the transaction rolls back. System shall throw an exception so that production operations team can perform the maintenance on the server. | |
− | |||
− | + | 3. FPDS-NG shall add a verification process to catch discrepancies in counts between the Award/IDV transaction tables and the Reports Repository from which Standard and Ad Hoc Reports are generated. (A verification check between the Reports Repository and the ezSearch index already exists). | |
− | + | 4. FPDS-NG shall perform a Data Management fix to populate the Vendor tables that are missing data so that the records shall become available in the Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds. | |
− | |||
− | |||
</td> | </td> | ||
<td align="center">No</td> | <td align="center">No</td> | ||
Line 57: | Line 58: | ||
<td style="width:95px" valign="center">FPDSHD-115807</td> | <td style="width:95px" valign="center">FPDSHD-115807</td> | ||
− | <td> | + | <td>FPDS-NG is incorrectly propagating the value for TOSA on an ‘update’ XML request when “Fair Opportunity/Limited Sources” is either ‘Competitive Set Aside’ or ‘Sole Source’. |
− | <td> | + | <td>FPDS-NG shall not propagate the value for TOSA from the IDV when “Fair Opportunity/Limited Sources” is either ‘Competitive Set Aside’ or ‘Sole Source’. |
</td> | </td> | ||
<td align="center">No</td> | <td align="center">No</td> | ||
Line 66: | Line 67: | ||
<td style="width:95px" valign="center">FPDSHD-115803</td> | <td style="width:95px" valign="center">FPDSHD-115803</td> | ||
− | <td>Atom Feeds are | + | <td>When the length of the “Maximum Order Limit” value is greater than ‘15’, the Atom Feeds are not displaying the value as expected. |
+ | |||
+ | <td> | ||
+ | 1. FPDS-NG shall display a validation rule on the IDVs indicating that the length of the “Maximum Order Limit” shall not exceed 20. The length includes the two decimal places. | ||
+ | |||
+ | Sample edit: <b>Length of the “Maximum Order Limit” shall not exceed 20. The maximum value allowable value is ‘999,999,999,999,999,999.99’.</b> | ||
+ | |||
+ | 2. Atom Feed requests (DoD and Public) shall display the “Maximum Order Limit” value as provided on the IDVs. The value shall be retrieved with two decimal places. E.g.: 99999999999999.00. | ||
+ | |||
+ | 3. The Data Validation Rules document for V 1.3 and V 1.4 shall be updated with the new validation rule. | ||
− | |||
</td> | </td> | ||
<td align="center">No</td> | <td align="center">No</td> | ||
Line 75: | Line 84: | ||
<td style="width:95px" valign="center">FPDSHD-114881</td> | <td style="width:95px" valign="center">FPDSHD-114881</td> | ||
− | <td>The validation rules for "Inherently Governmental Function" are firing when the "Product or Service Code" is | + | <td>The validation rules for "Inherently Governmental Function" are firing when the "Product or Service Code" is corrected from a 'Service' to a 'Product'. |
+ | |||
+ | <td>On the base document: | ||
+ | |||
+ | 1. FPDS-NG shall not fire 6M12, 6M13, 6M14 when the PSC is corrected from a Service to a Product. This applies to ‘Correct’ of the documents. | ||
+ | |||
+ | 2. FPDS-NG shall not fire 6M16 when the Date Signed is prior to 03/01/2012 and when the PSC is a Product. This applies to ‘Create-Update-Validate-Approve’ of the documents. | ||
+ | |||
+ | On the non-Change PIID modification done against a base (mod 0) document: | ||
+ | |||
+ | 1. FPDS-NG shall not fire 6M14 (6M15 shall continue to display) when the PSC is corrected from a Product to a Service, and when the Date Signed on the base document is earlier than 03/01/2012. This applies to ‘Correct’ of the documents. | ||
− | |||
</td> | </td> | ||
<td align="center">No</td> | <td align="center">No</td> | ||
Line 85: | Line 103: | ||
<tr> | <tr> | ||
− | <td style="width:95px" valign="center">FPDSHD-116863</td> | + | <td style="width:95px" valign="center">FPDSHD-116863-114046</td> |
− | <td>The | + | <td>FPDSHD-116863: The correction of “Contracting Officer’s Determination of Business Size” on the base documents is not being propagated to the modifications, as expected. |
+ | |||
+ | FPDSHD-114046: Novation modifications that were signed prior to 06/30/2007 are not retaining the user provided value for “Contracting Officer’s Determination of Business Size”. | ||
+ | |||
+ | |||
+ | <td>1. Correction of the value for “Contracting Officer’s Determination of Business Size” on the base (modification number = 0) documents shall propagate the value for all types of modifications, except: | ||
+ | |||
+ | i. Novation Agreement | ||
+ | |||
+ | ii. Rerepresentation | ||
+ | |||
+ | iii. Rerepresentation of non-Novated Merger/Acquisition | ||
+ | |||
+ | iv. Any modifications that are signed on or later than the above three modifications | ||
+ | |||
+ | 2. Correction of the value for “DUNS Number” on the base (modification number = 0) documents shall propagate the Vendor data (Vendor DUNS, name, address and socio-economic data) for all types of modifications, except: | ||
+ | |||
+ | i. Novation Agreement | ||
+ | |||
+ | ii. Vendor DUNS Change (Vendor socio-economic data and Contracting Officer’s Determination of Business Size shall propagate from the base) | ||
+ | |||
+ | iii. Any modifications that are signed on or later than the above two modifications | ||
+ | |||
+ | 3. When a Novation is submitted without changing the DUNS Number, a validation rule shall be displayed indicating that the DUNS Number should be changed. The sample validation rule is indicated here: | ||
+ | |||
+ | <b>The DUNS Number on the Novation modification must be different from that on the previous modification.</b> | ||
+ | |||
+ | </td> | ||
+ | <td align="center">No</td> | ||
+ | |||
+ | <tr> | ||
+ | |||
+ | <td style="width:95px" valign="center">FPDSHD-116533</td> | ||
+ | <td>FPDS-NG is incorrectly displaying an error when attempting to approve a ‘Change PIID’ Modification when it is the first Modification (New Base) after a Transfer Action. | ||
+ | |||
+ | <td>FPDS-NG shall allow a ‘Change PIID’ Modification to be successfully approved when it is the first Modification (New Base) after a Transfer Action and it has been validated successfully. | ||
− | |||
</td> | </td> | ||
<td align="center">No</td> | <td align="center">No</td> | ||
<tr> | <tr> |
Latest revision as of 16:47, 14 June 2013
Schedule
Description | Start Date | End Date |
---|---|---|
BETA Installation | Thursday June 13, 2013 | Friday June 14, 2013 |
Functional Qualification Testing | Tuesday June 18, 2013 | Thursday June 20, 2013 |
Installation in Production | Friday June 28, 2013 | Friday June 28, 2013 |
Document Changes
Documentation | Changes Required |
---|---|
XML Specifications | No |
Web Services | No |
Data Dictionary | No |
NASA Specific Data Dictionary | No |
Use Case Summary | No |
Validation Rules | Yes |
Reporting | Yes |
ezSearch | Yes |
Atom Feeds | Yes |
Online Help | No |
Computer-Based Training | No |
User Manual | No |
SPR Listing
SPR # | Enhancement/Problem | Solution | Impact to Users and Integrators |
---|---|---|---|
FPDSIRB-192 | FPDS-NG is incorrectly allowing selection of a 1-character or 2-character PSC Category on an Other Transaction Award or IDV and the records may be approved with such a value. | FPDS-NG shall only display 4-character PSCs in the look-up screen and shall only allow 4-character PSCs to be validated and approved successfully on an Other Transaction Award or IDV. | No |
FPDSHD-116158 | It is reported that records are missing from FPDS-NG Standard Reports, but the data exists in the Award database. The records missing from reports are found to not have data in two of the tables containing vendor information about each record. The missing data in these tables has caused the records to not be included in the nightly refresh that would include them in the Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds. This does not impact the Data Archives as they are generated from the transactional tables.
Vendor information is saved to 4 different tables when an Award or IDV is saved in FPDS-NG: Vendor, Vendor Location, Socio-Economic Indicators, and Business Types. The issue has occurred because a server has thrown an exception that was not handled and data was not stored to all 4 tables for a given transaction. | 1. FPDS-NG shall not store partial information of the vendor while finalizing a contract. FPDS-NG shall store complete Vendor information in all four tables (Vendor, Vendor Location, Socio-Economic Indicators, and Business Types) on all final records. This will ensure that records appear in Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds.
2. The exception that has occurred to cause the issue shall be handled so that if the transaction cannot be completed with data in all 4 Vendor tables (Vendor, Vendor Location, Socio-Economic Indicators, and Business Types), then the transaction shall be rolled back and no partial entry shall be permitted.CWS will get the system error when the transaction rolls back. System shall throw an exception so that production operations team can perform the maintenance on the server. 3. FPDS-NG shall add a verification process to catch discrepancies in counts between the Award/IDV transaction tables and the Reports Repository from which Standard and Ad Hoc Reports are generated. (A verification check between the Reports Repository and the ezSearch index already exists). 4. FPDS-NG shall perform a Data Management fix to populate the Vendor tables that are missing data so that the records shall become available in the Standard Reports, Ad Hoc reports, ezSearch, and Atom Feeds. |
No |
FPDSHD-115807 | FPDS-NG is incorrectly propagating the value for TOSA on an ‘update’ XML request when “Fair Opportunity/Limited Sources” is either ‘Competitive Set Aside’ or ‘Sole Source’. | FPDS-NG shall not propagate the value for TOSA from the IDV when “Fair Opportunity/Limited Sources” is either ‘Competitive Set Aside’ or ‘Sole Source’. | No |
FPDSHD-115803 | When the length of the “Maximum Order Limit” value is greater than ‘15’, the Atom Feeds are not displaying the value as expected. |
1. FPDS-NG shall display a validation rule on the IDVs indicating that the length of the “Maximum Order Limit” shall not exceed 20. The length includes the two decimal places. Sample edit: Length of the “Maximum Order Limit” shall not exceed 20. The maximum value allowable value is ‘999,999,999,999,999,999.99’. 2. Atom Feed requests (DoD and Public) shall display the “Maximum Order Limit” value as provided on the IDVs. The value shall be retrieved with two decimal places. E.g.: 99999999999999.00. 3. The Data Validation Rules document for V 1.3 and V 1.4 shall be updated with the new validation rule. |
No |
FPDSHD-114881 | The validation rules for "Inherently Governmental Function" are firing when the "Product or Service Code" is corrected from a 'Service' to a 'Product'. | On the base document:
1. FPDS-NG shall not fire 6M12, 6M13, 6M14 when the PSC is corrected from a Service to a Product. This applies to ‘Correct’ of the documents. 2. FPDS-NG shall not fire 6M16 when the Date Signed is prior to 03/01/2012 and when the PSC is a Product. This applies to ‘Create-Update-Validate-Approve’ of the documents. On the non-Change PIID modification done against a base (mod 0) document: 1. FPDS-NG shall not fire 6M14 (6M15 shall continue to display) when the PSC is corrected from a Product to a Service, and when the Date Signed on the base document is earlier than 03/01/2012. This applies to ‘Correct’ of the documents. |
No |
FPDSHD-116863-114046 | FPDSHD-116863: The correction of “Contracting Officer’s Determination of Business Size” on the base documents is not being propagated to the modifications, as expected.
FPDSHD-114046: Novation modifications that were signed prior to 06/30/2007 are not retaining the user provided value for “Contracting Officer’s Determination of Business Size”.
| 1. Correction of the value for “Contracting Officer’s Determination of Business Size” on the base (modification number = 0) documents shall propagate the value for all types of modifications, except:
i. Novation Agreement ii. Rerepresentation iii. Rerepresentation of non-Novated Merger/Acquisition iv. Any modifications that are signed on or later than the above three modifications 2. Correction of the value for “DUNS Number” on the base (modification number = 0) documents shall propagate the Vendor data (Vendor DUNS, name, address and socio-economic data) for all types of modifications, except: i. Novation Agreement ii. Vendor DUNS Change (Vendor socio-economic data and Contracting Officer’s Determination of Business Size shall propagate from the base) iii. Any modifications that are signed on or later than the above two modifications 3. When a Novation is submitted without changing the DUNS Number, a validation rule shall be displayed indicating that the DUNS Number should be changed. The sample validation rule is indicated here: The DUNS Number on the Novation modification must be different from that on the previous modification. |
No |
FPDSHD-116533 | FPDS-NG is incorrectly displaying an error when attempting to approve a ‘Change PIID’ Modification when it is the first Modification (New Base) after a Transfer Action. | FPDS-NG shall allow a ‘Change PIID’ Modification to be successfully approved when it is the first Modification (New Base) after a Transfer Action and it has been validated successfully. | No |