02069
|
CICP Copy
|
Materiel Management |
AF |
New |
Change Request: New System Process
Description:
Problem: AF GFM-A CICPs operate on their contracts for about 5 years, then new contracts may be awarded to the existing contractor or to a new company. For those AF GFM-A CICPs already transacting in DPAS, this translates to starting over with new conversion spreadsheets and passing data validation and data load performed by the DPAS Implementation Team. DPAS does not have process(es) needed to copy existing production data to create new CICP entries for the new contracts. AF GFM-A team proposed an 'easy button' process to copy and paste existing data to create new CICP entries. The 'easy button' process is not a replacement for the current AF GFM-A DPAS Implementation process; its' an alternative to starting over with conversion spreadsheets. The new capability would leverage/reuse the existing catalog data in DPAS to reduce implementation time.
Recommended:
DPAS will provide a CICP copy capability to copy existing production data from the expiring contract to the new contract. The copy capability will provide the authorized user a data entry screen for the new contract number, DoDAACs, RIC, etc. The data entry screen would replace the existing data within the copy function.
Mission Critical:
Benefits:
New CICP copy capability would reduce AF implementation time, re-use data already in DPAS and reduce DPAS Implementation team time need to validate and reload data.
Frequency: Yearly
Users:
AF GFM-A DPAS ICP and Warehouse Modules; estimated users 500 |
02068
|
Receive ILS-S 1SI Transaction
|
MU |
AF: A4/HAF FH-AFHAF |
New |
Change Request: Process Improvement
Description:
Problem: Users currently have the ability to receive a part ordered against an asset once it's delivered from LRS. The issue is, when a customer gets the part and doesn't utilize the receive option within DPAS, it causes the ILS-S 1SH transaction to linger in the background in ILS-S creating a mismatch of data between the two systems.
Recommended:
Add the capability in DPAS to receive the ILS-S 1SI transaction (represents the customer signing for the part) to close the loop for M&U requisitions.
Mission Critical:
AFI 23-101 Para 5.4.11.5.4.
(Added) Ensure the shipping document is signed by the appointed organizational
custodian and clear the DPAS document control record accordingly. (T-1).
Benefits:
Maintenance personnel can close a work order without signing for the part. This new feature for DPAS/M&U requisitioning will put the onus on the Logistics community to close the loop for M&U requisitions.
Frequency: Daily
Users:
M&U requisitioning transactions are conducted daily by the AvSE community. |
02067
|
SQL Server Message Bus Transport
|
Enterprise |
Leidos |
New |
Change Request: Process Improvement
Description:
Our current messaging architecture requires RabbitMQ as a message bus for communications across DPAS. RabbitMQ being a Free and Open Source Software (FOSS) requires additional measures to be approved or configured in some environments including on-site installations. This presents challenges to implementing DPAS in those locations.
Recommended:
Implement the SQL Server message bus transport and add configurations to allow SQL Server to be used as the message bus over RabbitMQ. Though, RabbitMQ is the superior option, some locations don't require the throughput to justify the implementation costs. The SQL Server implementation is sufficient for these smaller locations and is already an approved portion of DPAS.
Mission Critical:
Benefits:
This will reduce the regulatory requirements and overall time spent in implementing DPAS for smaller locations leading to an easier installation.
Frequency: Hourly
Users:
This affects most stand-alone DPAS instances. |
02066
|
Accounting CFO Reports
|
PA,Materiel Management,FSM |
Leidos |
New |
Change Request: New System process
Description:
The DPAS enterprise accounting module produces accounting transactions that currently are not reported from the accounting service and database. The existing Materiel Mgmt. CFO reports are generated from inventory transactions within Materiel Mgmt., and do not provide for start/end dates or other report filters that would be beneficial for accounting users. This SCR moves the CFO Reports that DPAS produces (Summary and Detail) to the Accounting Service. This will enable provide for a single location for producing CFO reports.
Recommended:
Generate new CFO Summary and Detail Reports for the Materiel Management module as well as the Property Accountability module when it is transitioned to using the accounting service. Reports will be generated using the new Accounting infrastructure and codes, such as the new CFO Codes, new action codes, and GLACs. Requirements include a set of Reporting DB tables and background processes that utilize the Accounting Transaction table in the Accounting Service,
Mission Critical:
DOD Accounting Policies including DOD FMR 7000.14 and SFFAS-Statement of Federal Financial Accounting Standards
Benefits:
DPAS Accounting users will have meaningful, useful CFO reports generated from the enterprise DPAS accounting module that will support OM&S and Fixed Assets
Frequency: Weekly
Users:
The frequency of this report will depend on the user's individual requirements. Affected users include DPAS Accounting Users, to include multiple agencies and a growing number of users. |
02065
|
Add MyQueries to Unit Return and Stock Nbr Inquiry
|
Warehouse |
NSWC |
New |
Change Request: Process Improvement
Description:
Unit Return and Stock Nbr Inquiry does not have the option to select My Queries under Grid Options
Recommended:
Enable a end user to create and share frequently used query.
Mission Critical:
Benefits:
Eliminate the time consumption spent on selecting and moving columns within Unit Return and Stock Nbr Inquiry.
Frequency: Hourly
Users:
All Users |
02064
|
FAMIS-GF Interface
|
PA |
DISA |
New |
Change Request: New System Process
Description:
Requesting an agreement be setup between DPAS and the new FAMIS-GF system to mimic the FAMIS-WCF agreement with the exception of a new interface system code.
Recommended:
Requesting an agreement be setup between DPAS and the new FAMIS-GF system to mimic the FAMIS-WCF agreement with the exception of a new interface system code.
Mission Critical:
Interface needed in order to interface DISA General Fund Capital transactions from DPAS into the new FAMIS-GF accounting system.
Benefits:
Prevents the need of manual Journal Vouchers (JVs) to be completed every month.
Frequency: Monthly
Users:
|
02063
|
Add New Component to Existing HA
|
PA |
NSWC |
New |
Change Request: Process Improvement
Description:
If we have two end items in inventory under the same Custodian and the first end item needs be converted to a component to the second end item as the HA; the first end Item asset can only be changed to a cost or no cost component via transfer to an HA in a different Custodian from the current Custodian then transfer back to the original Custodian to the intended HA.
Recommended:
Enable a end user to convert an end item to a cost or no cost component without making multiple transfers to different Custodians.
Mission Critical:
Benefits:
Eliminate the time consumption spent on transferring assets and coordinating with other custodian to receive and transfer the asset.
Frequency: Weekly
Users:
All Users |
02062
|
Mapping assets to Authorizations
|
PA |
AF: VSCOS |
|
Change Request: Process Improvement
Description:
Problem: PA currently links asset to Auth LIN/TAMCN Master Key and does not identify which asset belongs to which Authorization Document Number. Assigning asset to Authorization Document Number only links asset to Auth LIN/TAMCN Master Key which connects to multiple Authorization Document Numbers. Users must manually edit Authorization Document Number within Obligation Doc Number text field resulting with typing errors or copy/pasting inconsistencies within field(s). This causes enterprise data integrity issues. (Please reference Word Document attachment for specific details)
Proposed Improvement: Add new column (auth_lin_tamcn_detail_ky) to Asset Master table. This allows the ability to tie asset directly to Authorization Document Number and alleviates the grouping of Authorization Doc Numbers
Recommended:
Suggested solutions:
1) Develop an Obligation Document Number drop-down list of available Document Numbers for Authorization LIN/TAMCN Master Key
2) Create a search results screen with Authorization Document Numbers for users to select and populate a new Authorization LIN/TAMCN Detail Key ID Field on the Asset Master
3) Introduce a search field within Obligation Document Number text field for Authorization Document Numbers
Mission Critical:
Department of the Air Force Instruction 24-302 VEHICLE MANAGEMENT
Benefits:
1) Allows accurate asset accountability improving data integrity
2) Solves asset grouping within Authorization Document Numbers
3) Solves Unit Type Code mapping issues
Frequency: Daily
Users:
This process improvement benefits DOD agencies and military services on a daily basis. |
02061
|
Master Issue List for Pick Plans
|
Warehouse |
NECC |
New |
Change Request: Process Improvement
Description:
The picking process in the Warehouse Module allows you to create a pick based on the unit issue process, which you can load a Master Issue List for a given order. We would like to preposition materials in containers using the Master Issue Lists without the unit issue process. These lists are much more user friendly than the SKO process, which has proven confusing and misleading on inventory.
Recommended:
Create an option from the Create Pick Plan menu to load a Master Issue List (MIL) template and/ or select a MIL to pick when building your pick plan.
Mission Critical:
Benefits:
This cuts out several steps for the end user in that we don't need to create multiple orders.
Frequency: Hourly
Users:
Anyone pre-kitting items would benefit from this change. |
02060
|
Role Specific User Profile Inquiry Last Log In Date
|
Enterprise |
AF |
New |
Change Request: New System Process
Description:
The User Review User Profile Inquiry report contains inaccurate and incomplete information. This makes it challenging for IO/AIO to effectively oversee user roles eliminate unnecessary roles and UICs and carry out a comprehensive annual user audit. The data provided in the report is not reliable which hinders the organization's ability to properly manage user profiles and ensure data accuracy. It is crucial for the accuracy and completeness of the report to be improved in order to support effective user management practices. The inaccurate information hinders the ability to effectively manage user profiles and ensure the security of the system. It is crucial to address this issue in order to maintain the integrity and efficiency of the system.
Specifically:
The "Last Login Dt" currently shows the same date/time for all roles and modules. It is necessary to have it display the last login date/time for each module along with the specific echelon linked to each role such as Site AUIC UIC MA Warehouse and so on. This will provide a more accurate overview of user activity within each module and role allowing for better tracking and management of user access and permissions. By implementing this change users will have a clearer understanding of when and where they last accessed the system enhancing security and accountability.
Recommended:
In order to maintain security and data integrity it is important to display the "Last Login Dt" for each module and echelon associated with the roles. This helps to track the activity of users and ensure that only active roles are being utilized. Additionally roles should be suspended when the associated role/echelon is not accessed for 30 days. For example if a user has an APO role in AUIC FE 2345 and FE1234 but does not access FE1234 for 30 days that specific role would be suspended to prevent any unauthorized access. This will apply to all Roles/Levels across all modules.
Mission Critical:
Each year IO/AIO is responsible for conducting a user audit and informing the DPAS PMO once it is completed. Monitoring roles and user access such as ensuring there is a separation of duties and preventing unauthorized access to MAs or warehouses is crucial for every agency. Unfortunately the current system tools used for this task are displaying inaccurate information making it difficult to effectively perform these important functions.
Benefits:
Displaying correct data is a baseline expectation for a data system. The last login date for each user identification code (UIC) gives the information needed for the Information Officer or Authorizing Official to decide if the UICs are still in use by the user. This helps them figure out if the UIC is necessary for the user to carry out their responsibilities and allows them to remove any UICs that the user is no longer actively using. By monitoring the last login dates the IO/AIO can ensure that access to resources is only granted to those who need it enhancing security and efficiency. To reduce the risk of unnecessary personal transactions within unassigned UICs it is important to deactivate them. When UICs are not actively assigned to individuals there is a higher chance of unauthorized access and misuse. By deactivating these UICs organizations can ensure that only authorized personnel have access to sensitive information and resources. This proactive approach helps in maintaining the security and integrity of the system ultimately reducing the potential risks associated with unassigned UICs.
Frequency: Daily
Users:
Unsure how many Agencies and IO/AIOs are in DPAS, but this will impact all of them. |
02059
|
Addition to Role Request Form
|
Enterprise |
AF |
New |
Change Request: Process Improvement
Description:
Role Request forms for all modules do not include a supervisor signature block. This means that without supervisor validation the Information Officer or Authorizing Official has no way to confirm that the user is truly authorized to request the role or Unit Identification Code (UIC). This lack of validation raises the risk of Segregation of Duties violations as well as the possibility of users gaining access to roles and locations that they should not have access to. It is important to ensure that proper authorization processes are in place to prevent these risks. The Air Force is facing a challenge as it centralizes IO/AIO processes in the new DAF DPAS FMO. When it comes to initial access packages the DD2875 requires supervisor approval to proceed. However for Role Updates only the Role Request form is submitted leaving no clear method to show supervisor approval for the user to obtain the requested role/UIC. This lack of clarity in the approval process could potentially cause delays and confusion within the system.
Recommended:
In order for a user to possess the roles/UIC update requested it is necessary to add a Supervisor signature block for approval. This can be done on an AF-specific RR form and the supervisor information does not need to be included in the User Review Inquiry information. This step ensures that the appropriate authority has reviewed and approved the request before any changes are made.
Mission Critical:
Per DPAS IO Guide 2024 Responsibility of IOs/AIOs. "You will verify that roles being assigned to the user do not conflict with other duties or actions in DPAS or other systems per Separation of Duties (SOD)."
Benefits:
In order to reduce the chances of Segregation of Duties violations it is important to make sure that users only have access to roles and locations that are appropriate for their responsibilities. This will help maintain data integrity within the Air Force communities using DPAS. By implementing these measures we can also improve the accuracy of the annual user audit ensuring that only authorized individuals have access to sensitive information.
Frequency: Daily
Users:
Impacts all AF users, potentially all DPAS users. |
02058
|
Role Specific User Profile Inquiry IO Information
|
Enterprise |
AF |
New |
Change Request: New System Process
Description:
The User Review, User Profile Inquiry, produces a report with inaccurate data. This inaccurate data restricts IO/AIO ability to accurately monitor user roles, remove unneeded roles, or perform the annual user audit. Specifically:
1. The "Created IO" field does not reflect the name of the IO/AIO that approved the role. It only displays the name of the first IO/AIO that approved any role for that user.
2. The "Established Dt/Tm" field does not reflect the date/time each role was established. It only reflects the date/time that the first role for each user was established.
3. The "Last Login Dt" reflects the same date/time for all roles and modules. Require it to reflect the last login date/time for each module and the echelon associated with each role (i.e., Site, AUIC, UIC, MA, Warehouse, etc).
Recommended:
1. DIsplay the name of the IO/AIO that approved each role in the "Created IO" field.
2. Display the date/time each role was established in the "Established Dt/Tm" field.
3. Display the "Last Login Dt" for each module and echelon associated with the roles. Additionally, suspend roles when the associated role/echelon is not accessed for 30 days. For instance, if a user has APO role in AUIC FE 2345 and FE1234, but does not access FE1234 for 30 days, that role would be suspended.
Mission Critical:
Each IO/AIO is tasked with performing an annual user audit and reporting completion to the DPAS PMO, and monitoring roles and user access (segregation of duties, access to unauthorized MAs or warehouses, etc.) is a critical function of each agency. Presently, the system tools that enable this task display erroneous information.
Benefits:
Ensure all DPAS user agencies and IO/AIOs are able to perform the annual user audit, ensure segregation of duties, and remove roles that may be in conflict.
Frequency: Daily
Users:
Unsure how many Agencies and IO/AIOs are in DPAS, but this will impact all of them. |
02057
|
Checkmarx Code Updates
|
Enterprise |
Leidos |
New |
Change Request: Policy/ regulatory
Description:
Recently the DPAS project has utilized Checkmarx code scans to identify potential vulnerabilities and improvements to the DPAS code base. These scans have provided insight into areas of improvement in the application.
Recommended:
The DPAS application should be updated to address potential security enhancements flagged by Checkmarx, including additional input validation and deprecation of unused legacy AIT code.
Mission Critical:
Remove potential security risks.
Benefits:
Applying recommended updates from Checkmarx will enhance application security and reduce the size of the app through sunsetting of legacy code.
Frequency: Hourly
Users:
Application Upgrade |
02056
|
Mass Update Maint Group ID with MU Setup Role
|
PA,MU |
AF: A4/HAF FH-AFHAF |
New |
Change Request: Process Improvement
Description:
Currently the only profile that can mass update the Maintenance Group Id to a stock number in the Catalog Manager role. However in order to maintain the data integrity of the DPAS catalog we limited who has access to the Catalog Manager role.
Recommended:
Recommend adding the Maintenance Group Id profiling through Mass Updates under the M&U Set-up role. Limit the edits to only the Maintenance Group Id data element under the 'CatalogMass Update Stock number to the M&U Set-up role.
Mission Critical:
This allows for the M&U Set-up role to make updates without requiring full access to the Catalog Manager role.
Benefits:
Data integrity for the catalog can still be maintained, but also provide the functional communities that use M&U to make edits as required.
Frequency: Daily
Users:
All M&U Set-up role users would be affected by this process improvement. |
02055
|
Add High Level Hierarchy to Tier Structure
|
Warehouse,Materiel Management |
Leidos |
New |
Change Request: Process Improvement
Description:
The DPAS Materiel Mgmt. and Warehouse Mgmt. applications were designed without Enterprise, Deptartment or Agency Tiers. As DPAS is deployed to more customers with some of those customer being Non-DoD, there is a need to add additional top level tiers. With the planned implementation of ICAMS for Account Mgmt, having an enterprise tier would be a benefit for managing customer support personnel accounts.
Recommended:
Add 3 top level tiers to Materiel Mgmt. and Warehouse Mgmt. applications. The tiers would be as follows: Enterprise (Customer Support), Department (DoD, Homeland Security), and Agency (Army, Navy, USCG (Non-DoD), etc.). Modify Enterprise Roll-up inquiries within these 2 modules to support the new tiers given the fact that catalog could be at a different tier levels.
Mission Critical:
Provides improvements to user account mgmt. within DPAS and ICAMS.
Benefits:
Provides for user access to be granted at the level required without continued update of user accounts when a new Logistics Program or Materiel Management Program for enterprise, department or agency level users.
Frequency: Daily
Users:
It is estimated that this will support approximately 200 users |
02054
|
NCE Single Asset Identification
|
MU |
AF: VSCOS |
New |
Change Request: Policy/ regulatory
Description:
System lacks ability to identify NCE Assets below NSN Level. Not all assets catalogued under a specific NSN are NCE. Therefore, system needs the capability to remove certain Make/Model/Serial numbers below the NSN-level from Nuclear indicator status.
Recommended:
Recommend adding toggle or NCE role with the ability to add/remove/edit Nuclear Indicator Status at the asset’s NSN/Make/Model/Serial number. Toggle/role should have ability to limit specific user to task ensuring proper NCE controls.
Mission Critical:
DAFI 24-302 VEHICLE MANAGEMENT AFI 63-125 NUCLEAR CERTIFICATION PROGRAM
Benefits:
Benefits of implementing change includes safety and movement of special weapons, proper accountability of nuclear support equipment mission sets, saving research time opening a work orders, potential improper maintenance actions on nuclear surety assets, and proper visual restriction of nuclear certified status.
Frequency: Daily
Users:
This process benefits DOD agencies and military services on a daily basis. |
02053
|
User Added Warehouse
|
Warehouse |
NSWC |
New |
Change Request: Process Improvement
Description:
Currently DPAS does not allow the user to add a warehouse. This feature is available to the DPAS Security, or they can be added via the DPAS implementation team. Both require the customer to open a ticket and send the paperwork to the DPAS Helpdesk. The recommended solution is incorporate the 'Add' action button to the user's version of the Warehouse AUD.
Recommended:
Modify the Warehouse Officer User role to include "ADD" for LPWHN04 - Warehouse.
Mission Critical:
Enables the user with the Warehouse Officer role to create DPAS warehouses without requiring DPAS support.
Benefits:
Improves and reduces the time to perform warehouse creations / re-alignments. Eliminates support from DPAS support, support or implementation teams.
Frequency: Monthly
Users:
The SCR applies to all users of the DPAS WM application. |
02052
|
Expanded Label Options
|
Warehouse |
NSWC |
New |
Change Request: Process Improvement
Description:
The current ICN label options work for an warehouse operation, but are not conducive for field operations. The majority of the items NSWC manages in WM are serialized items that are issued to the unit / individual. These items are returned when the mission is completed and are re-issued to support the next mission. NSWC requires more options similar to what the PA application offers. WIth SCR 01984 enabling warehouse physical inventories to be conducted by Asset Id, providing additional ICN label options and the ability print an Asset Id label would enable NSWC to label the majority of their items.
Recommended:
Provide additional label printing options similar to PA where the user has more label size options and can select the data elements to include on the label based upon the size of the label. When this SCR is ready to be programmed, NSWC will work with the DPAS developers to identify label size options, and what field options are desired.
Mission Critical:
Improves item marking which will facilitate better identification of the item which will reduce the time required to conduct physical inventories by the Unit / Individual.
Benefits:
The change will enable the PBO to be able to better communicate with the unit/individual what the item is. Current label size options limit what items can be marked to larger items. Supporting label sizes similar to what PA offers will enable more items being bar coded / pRFID enabled that will speed and improve PI accuracy.
Frequency: Daily
Users:
The SCR applies to all users of the DPAS WM application that are not able to utilize the current WM label sizes. |
02051
|
Warehouse Relocation
|
Warehouse |
NSWC |
New |
Change Request: Process Improvement
Description:
Currently DPAS does not allow the user with Warehouse AUD access to modify the Site the Warehouse is aligned. With re-organizations a common practice, the Warehouse AUD should permit the user to update the region / site the Warehouse is aligned. This change will allow the user to systematically make the change and eliminate a help ticket to the DPAS developers to make the change.
Recommended:
Add a Region drop-own to Warehouse AUD defaulting the value to the current Region, with the capability to select a different Region within the Warehouse's current Logistics Program. Enable the Site drop-down to permit the user to change the site the warehouse is aligned. When Region is changed, clear the Site drop-down forcing the user to select a new Site from a list the drop-down is populated that corresponds to the Region selected.
Mission Critical:
Enables the user to perform updates without requiring DPAS support.
Benefits:
Improves and reduces the time to perform an warehouse re-alignment. Eliminates support from DPAS support team.
Frequency: Daily
Users:
The SCR applies to all users of the DPAS WM application. |
02050
|
Receiving by Asset ID
|
Warehouse |
Leidos |
New |
Change Request: Process Improvement
Description:
CNIC does not have label printers available at their installations for the printing of an Inventory Control Number (ICN) label. As an alternative, they purchase Asset Id labels that are affixed to the item at time of receipt. DPAS WM provides for the capture of the Asset Id, but not during receiving. Using Inventory Update is labor intensive and does not represent the normal business flow for the receive and marking of an item.
Recommended:
Modify Warehouse Receiving to include Asset Id on the Receiving page where Serial Nbr and pRFID are present. DPAS can make it an optional display entry allowing the user to decide to display or not display the Asset Id filed on this screen, but it is considered essential to CNIC to be able to enter the Asset Id during the receiving phase.
Mission Critical:
Provides for a normal flow of a receipt allowing markings to be add during that phase.
Benefits:
It is estimated that this will save CNIC 3 minutes for every receipt.
Frequency: Daily
Users:
The SCR applies to all users of the DPAS WM application that utilize purchased labels to identify their items in the warehouse. This solution provides an efficient and effective method for entering the value. |
|