Attachment_2F_-_FBMS_BIO_Release_Notes_Examples_1.pdf

PDF 2 MB Posted

Attached to
DOI BIO FBMS Support RFI and Industry Day
Solicitation number
140D0425R0058
Issued by

About this file

These documents are the Department of Interior's Financial and Business Management System (FBMS) Business Integration Office (BIO) Monthly Release Notes for 2022, covering system updates, defects, and improvements across multiple functional areas including Acquisitions, Financial Assistance, Accounts Payable, Funds Management, Security, and other administrative systems from January through December 2022.

The release notes detail hundreds of technical modifications and enhancements, such as regulatory updates to PRISM, changes to vendor management processes, updates to reporting systems, improvements in energy and real property tracking, security role adjustments, and interface modifications. Key themes include preparing for S4HANA conversion, implementing Unique Entity Identifier (UEI) requirements, enhancing data reporting capabilities, addressing audit findings, and improving system security and user access controls. The monthly releases reflect ongoing system maintenance, compliance updates, and incremental improvements to the Department of Interior's integrated financial management platform.

View the file

Other files

File Type Posted
Draft_BIO_and_FBMS_Support_Services_IDIQ_PWS_3.docx DOCX document
Attachment_2L_-_FBMS_Software_Matrix_per_Release_1.pdf PDF
Attachment_2A_-_FBMS_SAP_Modules_1.pdf PDF
Attachment_2J_-_FBMS_Interfaces_Overview_1.pdf PDF
Attachment_1F_-_FBMS_Software_Matrix_per_Release_1.pdf PDF
Attachment_1C_-_FBMS_Governance_Structure_1.pdf PDF
Attachment_1D_-_FBMS_Interfaces_Overview_1.pdf PDF
Attachment_1B_-_FBMS_Development_Objects_1.pdf PDF
Attachment_2K_-_FBMS_Architecture_Diagram_1.pdf PDF
Attachment_2H_-_2025_Notional_Scope_Descriptions_1.pdf PDF
Attachment_1E_-_FBMS_Architecture_Diagram_1.pdf PDF
Attachment_2G_-_2025_Notional_Scope_Dashboard_1.pdf PDF
Draft_BIO_and_FBMS_Support_Services_IDIQ_PWS_1.docx DOCX document
Attachment_2C_-_BIO_Organization_Chart_1.pdf PDF
Attachment_1H_-_Travel_Authorization_Request_Form_1.pdf PDF
Attachment_2D_-_FBMS_Governance_Structure_1.pdf PDF
Attachment_1G_-_FBMS_Support_Labor_Categories_1.pdf PDF
Attachment_2I_-_Notional_Release_Plan_1.pdf PDF
Attachment_1A_-_FBMS_SAP_Modules_1.pdf PDF
Attachment_2B_-_FBMS_Development_Objects_1.pdf PDF
RFI_Instructions_and_Industry_Day_Registration_1.docx DOCX document
Attachment_2N_-_Table_to_Compute_Incident_Urgency_1.pdf PDF
Attachment_2E_-_Notional_Sprint-Release_Schedule_1.pdf PDF
Draft_BIO_Task_Order_Support_Services_PWS_v1_1.docx DOCX document
Attachment_2M_-_FBMS_Backup_Schedule_1.pdf PDF
Show all 25

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

R .J

A N

.2

DOI FBMS BIO Release Notes

Prepared for All DOI Bureaus:

BLM, BOEM, BSEE, BOR, DO, FWS, IA, NPS, OSMRE, and USGS

A N

.2

DOI FBMS BIO Release Notes

R.JAN.22

FINAL

Prepared for All DOI Bureaus:

January 21, 2022

A N

.2

R.JAN.22 Summary

Team Title Impacted Parties

Acquisitions and

Financial Assistance

D-05759 - AFA Defect - PRISM Regulatory Updates January ACQ PRISM users

Batch D-05718 - Automating the close of Anticipated Accounts for

Expired Funds at month end.

GTAS users for all Bureaus

CF - Accounts

Payable

D-05685 - Semi-Annual Interest Rate/CVFR Updated Accounts Payable

CF -

Controlling/Project

Systems (COPS)

D-05755 - This defect fixes a technical issue with the overhead calculation

The impacted parties are the bureaus that use the overhead calculation and in particular the CO Systems Accountants

CF - Funds

Management/General

Ledger

D-05762 - Removal of Duplicate Business Event Type Code

(BETC) from FBMS

All Bureau users reporting and reconciling cash postings

CF - Funds

Management/General

Ledger

D-05583 - The BLM L0777 Funds Commitment validation logic has been be updated to make the validation work correctly

Only BLM users with the AP_MOS role are impacted by this change

CF - Funds

Management/General

Ledger

D-05732 - Travel/PCS vendor down payment reversal issue Travel/PCS users with the TR_RO - TR Reviewing Official and

PCS_RO - PCS Reviewing Official roles are impacted

A N

.2

R.JAN.22 Summary

Team Title Impacted Parties

CF - Funds

Management/General

Ledger

D-05781 - DATA Act and GTAS updates for January reporting FWS GTAS user and BIO DATA Act users

CF - Funds

Management/General

Ledger

D-05779 - Update ABP Budget Address for IA and Availability

Address for USGS

IA reimbursable users within the EEO office and USGS Budget

Users

CF - Funds

Management/General

Ledger

D-05744 - Update Fund Type assignments to Budget Types based upon Treasury Posting models

Budget Offices recording sequestrations and Accounts

Receivable recording collections for EPL(Emergency Paid

Leave)

PROP - Energy D-05699 - Add New Energy Type for Propane in Lbs (new number 674)

New Energy Type to be used to record Energy Cost and

Consumption

PROP - Real Property D-05734 - Reversing RE Contract Postings Does Not update the obligation amount

Bureaus' Leasing and Budget Users

Portal D-05747 - Update Tableau Lock Out Error Message Text All Tableau Users

Security D-05576 - Due to an audit finding from Guidehouse, the Basis

Admin roles have been updated to remove SE06, SM30, SA38, SE16 and SE16N in ECC and SE06 from the other non-ECC ABAP systems. [BIO ONLY]

The BIO system admin team will be impacted by this change.

A N

.2

R.JAN.22 Summary

Team Title Impacted Parties

Security D-05567 - Auto-generated GRC Email Content Change [BIA

ONLY]

BIA

Security D-05780 - The technical role for all GrantSolutions AM organizations was updated for correct technical naming convention. [BIO only]

BIO Security Team is impacted by this change

Security D-05770 - New GRC Sub Process TAB_OHCM for Tableau

OHCM Site

BIA SPOC's and Tableau OHCM Site approver are impacted with this change

Security D-05614 - GrantSolutions User Role Data Report Issue Bureau SPOC's impacted with this change

Security D-05754 - The IDA_BUYAGRMT role is missing the IGF authorization object.

Users requesting IDA_BUYAGRMT role

Security D-05705 - The ZSE_FPPS_UPLOAD program needs to be enhanced to identify duplicate entries.

BIO Information Assurance

Security D-05764 - GrantSolutions UAM reconciliation report logic updated to address defect with identifying SAP IDs and spool results updated to display full email address.

Bureau SPOCs and GrantSolutions Bureau SMEs should be aware of this change

Sys Admin D-05788 - Encrypt the Connections from GRC application to

LDAP Servers

BIO Only

A N

.2

D-05759 - AFA Defect - PRISM Regulatory Updates January

Description PRISM Regulatory updates (Preapproved change#3):

1) FAR FAC, 2022-02 and 2022-03, effective 1/14/2022 and 1/1/2022 respectively

2) GSAR 54, effective January 3, 2022

3) DFARS 86, effective November 30, 2021

Impacted

Parties

ACQ PRISM users

Technical

Description

PRISM Clause Databases have been updated with most recent versions provided by Unison.

Team AFA Team

A N

.2

D-05718 - Automating the close of Anticipated Accounts for Expired Funds at month end.

Description Automate the existing month-end process of running Preclose for the Expired funds to close any anticipated account balances.

Impacted

Parties

GTAS users for all Bureaus

Technical

Description

BIO will create and maintain variants for each Bureau of all expired funds (to be updated each year end) for the Preclose transaction.

Team Batch Team

A N

.2

D-05685 - Semi-Annual Interest Rate/CVFR Updated

Description Treasury published the Jan-22 through Jun - 22 Prompt Payment interest rate at 1.625%. The Current Value of Funds Rate remained unchanged from last year at 1.00%.

Impacted

Parties

Accounts Payable

Technical

Description

Configuration was updated in Production to reflect the new Prompt Payment interest rate.

Team AP Team

A N

.2

D-05755 - This defect fixes a technical issue with the overhead calculation

Description During DEC closing (JAN 2022), the overhead calculation (OH) for FWS short dumped. After working with Padmarao, it was determined that a change to the code from the DEC release impacts OH only when multiple lines occur and the ordering of those lines is incorrect. SAP created a fix on 10/2021.

Impacted

Parties

The impacted parties are the bureaus that use the overhead calculation and in particular the CO Systems Accountants

Technical

Description

A DEC release code change by SAP resulted in a short dump when executing the OH calculation (CJ44 and CJ45). It was caused by a mismatch in line in an interim step leading to the posting that is non user facing. One of the sort statement resulted in mismatching the amounts( credit and debit ) of the line items.

OSS note 2950027 was applied to resolve this issue.

Team COPS Team

A N

.2

D-05762 - Removal of Duplicate Business Event Type Code (BETC) from FBMS

Description Remove duplicate BETC values COLAVDEC, COLAVINC, COLURDEC, COLURINC from availability per Treasury requirement.

Impacted

Parties

All Bureau users reporting and reconciling cash postings

Technical

Description

Team FM/GL Team

A N

.2

D-05583 - The BLM L0777 Funds Commitment validation logic has been be updated to make the validation work correctly

Description As part of the June 2021 release, we moved in a validation to ensure that GL Account 6100.252Z0 was only posted with Funds

Commitment Document Types L1 or L2 to allow BLM to accurately report their L0777 UDO distribution amounts in the BW Fund Status report. However, there was a bug in the validation program which caused BLM to incorrectly receive an error message when processing a

Seed Warehouse Funds Commitment (Doc Type SO/GL Account 6100.264S0). The validation program has been updated so the validation now functions correctly.

Impacted

Parties

Only BLM users with the AP_MOS role are impacted by this change

Technical

Description

The BIO AD team updated the validation program logic to resolve the bug in the program.

A N

.2

D-05732 - Travel/PCS vendor down payment reversal issue

Description When a Travel/PCS vendor down payment is reversed via transaction FBRA or FMFG_TC_REV_CHECKS, a duplicate Budgetary Ledger

(BL) document is being generated throwing off the over SGL 4610/4801 balances. We reported this issue to SAP and they provided a fix that we will be applying as part of this release.

Impacted

Parties

Travel/PCS users with the TR_RO - TR Reviewing Official and PCS_RO - PCS Reviewing Official roles are impacted

Technical

Description

SAP provided note 3133809 to resolve this issue.

A N

.2

D-05781 - DATA Act and GTAS updates for January reporting

Description FWS has a new fund that should report a Disaster Emergency Fund Code (DEFC) of "Z"

The remaining updates are for Program Activity crosswalks provided by the Bureaus for new/previously unused master data

Impacted

Parties

FWS GTAS user and BIO DATA Act users

Technical

Description

Update GTAS/DATA Act derivation rules (see attached word doc)

Continued on next page

A N

.2

D-05781 - DATA Act and GTAS updates for January reporting

GTAS/DATA Act Defect D-05781 RFC 8000031269

Update FWS PA by Functional Area change FF311* from 0006 FUELS MANAGEMENT to 0012

2022 DISASTER

SUPPLEMENTAL (P.L. 117-43) and adding FF321* 0012 2022 DISASTER SUPPLEMENTAL (P.L.

117-43), FF311*,

FF312*, and FF322* to 0013 2022 BIPARTISAN INFRASTRUCTURE LAW (P.L. 117-58)

FESK60000.000000 FESK60000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FESS60000.000000 FESS60000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FFRD40000.000000 FFRD40000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FFRF40000.000000 FFRF40000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FFRK40000.000000 FFRK40000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FFRT40000.000000 FFRT40000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FGOD90000.000000 FGOD90000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FGOF90000.000000 FGOF90000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FGOK90000.000000 FGOK90000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FGOS90000.000000 FGOS90000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FGOT90000.000000 FGOT90000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FHCK30000.000000 FHCK30000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FMBS50000.000000 FMBS50000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FRSK20000.000000 FRSK20000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FRSS20000.000000 FRSS20000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FSCK10000.000000 FSCK10000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

FSCS10000.000000 FSCS10000.ZZZZZZ 0012 2022 Bipartisan Infrastructure Law (P.L. 117-58)

BLM PA by Functional Area adding

L53260000.000000 L5326ZZZZ.ZZZZZ = 12 RPR DMG LND O&C FIRE

TRSP

L33110000.000000 L3311ZZZZ.ZZZZZ = 3 LAND ACQUISITION

PROJECT

LF3110000.000000 LF311ZZZZ.ZZZZZZ = 11 FUELS MANAGEMENT

LF3210000.000000 LF321ZZZZ.ZZZZZZ = 11 BURNED AREA

REHABILITATION

DO PA by USERTEMP3 (last 7 of fund) and Functional Area adding

D1125FR DS1100000.000000 DS11ZZZZZ.ZZZZZZ = 0002 Preparedness

Update USGS PA by AoF 5198 and 1618 by Funded Program adding

GX20SB00COM1600 0001 DAMAGE ASSESSMENTS

GX21LB00F92CP00 0003 OTHER RESTORATION

GX22LB00F922400 0003 OTHER RESTORATION change

GX20MN00COM51X1 from 0004 PROGRAM MANAGEMENT to 0003

OTHER RESTORATION

Update A: DEFC by Fund adding fund 22XF1125DI = Z

Remove BETC COLAVDEC, COLAVINC, COLURDEC, COLURINC from

Federal Fields

A N

.2

D-05779 - Update ABP Budget Address for IA and Availability Address for USGS

Description IA has begin processing EEO work for BIE and now needs the reimbursable fund type (RM0) to have funds center AAK10012* work with

RM0 funds the same as it does with AF0 fund types. The Budget Address on the expenditure side is not fund type specific but ABP is separated by fund type. Need to update both sender and receiver funds center rules for RM0 fund to use full funds center instead of replacing last six digits with "000000"

USGS fund XXXG519800 is using Functional Area GA1* which is not deriving the GA0000000.000000 value for Availability Control(AVC).

Added this fund to the new FY21 fund rule to derive the two digit Functional Area for AVC. This does not impact Budget Address. Once completed, will need to run AVC reinitialization for FY21 and FY22.

Impacted

Parties

IA reimbursable users within the EEO office and USGS Budget Users

Technical

Description

Update sender and receiver funds center rules in ABP for RM0 fund typeUpdate AVC rule for USGS fund

A N

.2

D-05744 - Update Fund Type assignments to Budget Types based upon Treasury Posting models

Description Allow the AR0 fund type to use the 4070 source of funds for collections using the Treasury Emergency Paid Leave (EPL) posting model.

Also, allow AR3 fund type to post temporary sequestration (URAR and for year-end URSR)

Impacted

Parties

Budget Offices recording sequestrations and Accounts Receivable recording collections for EPL(Emergency Paid Leave)

Technical

Description

Update Maintain Budget Type Attributes by assigning 4070 to AR0DDB and AR0MDB fund types. Also, allow AR3 fund type to post temporary sequestration (URAR and for year-end URSR)

A N

.2

D-05699 - Add New Energy Type for Propane in Lbs. (new number 674)

Description Added new energy type number 674 to ZENERGYTYPE table. Energy types used to represent units of measurement and conversion of those units to Green House Gas reporting when recording and reporting energy cost and consumption.

Impacted

Parties

New Energy Type to be used to record Energy Cost and Consumption

Technical

Description

Add energy type for Propane in LBS to ZENERGYTYPE. New number is 674.

Team Energy Team

A N

.2

D-05734 - Reversing RE Contract Postings Does Not update the obligation amount

Description While regression testing the lease obligation functionality for the December release system upgrade, the BIO Real Property (RP) team found a defect with Real Estate (RE) contract lease obligation. The RE contract obligates correctly when it is created, changed and posted for payment (RERAPP). However, when the contract has that posting reversed (RERAPPRV), the obligation does not update to add the funding back to the obligation on the contract after the reversal.

Impacted

Parties

Bureaus' Leasing and Budget Users

Technical

Description

An OSS Note (Note 3063785) has been applied to correct the issue and the fix moved to Production on 1/4/22.

Team RP Team

A N

.2

D-05747 - Update Tableau Lock Out Error Message Text

Description Update the text that is displayed when a user tries to access a visualization and gets a lockout message.

Impacted

Parties

All Tableau Users

Technical

Description

Below is the new updated text that the user will see when they get the lockout message while trying to access tableau visualization.

Thank you for trying to access a Tableau Server Visualization, however your account has been locked due to inactivity. Please send an email to: FBMS_HelpDesk@ios.doi.gov to be unlocked.

You will receive a confirmation email when your account is unlocked.

Team Portal Team

A N

.2

D-05576 - Due to an audit finding from Guidehouse, the Basis Admin roles have been updated to remove

SE06, SM30, SA38, SE16 and SE16N in ECC and SE06 from the other non-ECC ABAP systems. [BIO

ONLY]

Description Due to an audit finding from Guidehouse, the following Basis Admin roles have been updated:

ZT_X_GSS_BASIC_SERV_MONITORING - tcodes SE06, SM30, SA38, SE16 and SE16N were removed

ZT_X_BC_BASIS_ADMIN - tcode SE06 was removed

Impacted

Parties

The BIO system admin team will be impacted by this change.

Technical

Description

The following transactions were removed from the following Basis roles in the ABAP systems as a result of an audit finding from

Guidehouse.

ZT_X_GSS_BASIC_SERV_MONITORING - tcodes SE06, SM30, SA38, SE16 and SE16N were removed

ZT_X_BC_BASIS_ADMIN - tcode SE06 was removed

Team Security Team

A N

.2

D-05567 - Auto-generated GRC Email Content Change [BIA ONLY]

Description The email address in the footing of all automated GRC emails for IA's Training Coordinators needs to be updated from

"IA_FBMS_TRAINING_COORDINATORS@bia.gov" to "IA_FBMS_Training_Team@bia.gov".

Impacted

Parties

BIA

Technical

Description

Email template Z_RR_TC1_APP_USER is updated with new email address IA_FBMS_Training_Team@bia.gov

A N

.2

D-05780 - The technical role for all GrantSolutions AM organizations was updated for correct technical naming convention. [BIO only]

Description The technical role name associated with the business role T_GS_AM_ORG_DOI_ALL was associated with an end user role that represented all Announcement Module (AM) organizations within GrantSolutions.

A new technical role in the correct namespace for the BIO team was created. This ensures that the assignments for the BIO team members in production is consistent with the security controls strategy.

Impacted

Parties

BIO Security Team is impacted by this change

Technical

Description

ZTAX_GS_AM_ORG_DOI_ALL technical role built and the business role mapping for T_GS_AM_ORG_DOI_ALL updated to replace

YTAX_GS_AM_ORG_DOI_ALL with ZTAX_GS_AM_ORG_DOI_ALL and GrantSolutions x-reference table ZSE_GRC_GS_MAP updated as well.

A N

.2

D-05770 - New GRC Sub Process TAB_OHCM for Tableau OHCM Site

Description New GRC Sub-Process TAB_OHCM has been created under TAB9 process. This sub process will be used to setup GRC Tableau OHCM

Site roles and the workflow approvers for Tableau OHCM requests. Only BIA users are impacted with this change.

Impacted

Parties

BIA SPOC's and Tableau OHCM Site approver are impacted with this change

Technical

Description

New GRC Sub-Process TAB_OHCM has been created under TAB9 process. This sub process will be used to setup GRC Tableau OHCM roles and the workflow approvers for Tableau OHCM requests.

A N

.2

D-05614 - GrantSolutions User Role Data Report Issue

Description GrantSolutions User Role Data report out was including the GrantSolutions role(s) that were part of the GRC request but got rejected during the workflow approval process. The rejected GrantSolutions roles must be excluded from the report output.

Impacted

Parties

Bureau SPOC's impacted with this change

Technical

Description

GrantSolutions User Role Data report logic has been updated to exclude the Rejected GS roles in GRC request from the report output.

A N

.2

D-05754 - The IDA_BUYAGRMT role is missing the IGF authorization object.

Description The IDA Buyer Agreement Role, IDA_BUYAGRMT, was missing the IGF authorization object to indicate that it is a FEO (Federal

Employee Only) role only and thus did NOT trigger SoD risk Z1507 (Non-Federal Employee User Group vs. Inherently Governmental Roles

(H)).

Impacted

Parties

Users requesting IDA_BUYAGRMT role

Technical

Description

The BUY_AGRMT role was fixed by adding the Z_IGF authorization object with the value of FEO (Federal Employee Only).

A N

.2

D-05705 - The ZSE_FPPS_UPLOAD program needs to be enhanced to identify duplicate entries.

Description When uploading the FFPS report into GRC using the ZSE_FPPS_UPLOAD program, if there is a duplicate file the upload fails.

Impacted

Parties

BIO Information Assurance

Technical

Description

FPPS load program ZSE_IF2001_FPPS_UPLOAD is updated to to ignore duplicate FPPS IDs before loading into ZSE_FPPS_ACTIVE table

A N

.2

D-05764 - GrantSolutions UAM reconciliation report logic updated to address defect with identifying SAP IDs and spool results updated to display full email address.

Description The interface to load the GrantSolutions User Account Management (UAM) Announcement Module (AM) de-activated users data into

FBMS had a defect where the corresponding SAP ID was not populated as expected.

Since the SAP ID was not populated via the interface, the GrantSolutions AM automatic account deactivations report was not displaying all of the valid records and thus not all users were listed.

Bureau SPOCs will now see more data in the GrantSolutions AM automatic account deactivations report and can submit the GRC role removal request within the report. Thus the automatic role removal in the GrantSolutions AM module are reflected in the FBMS GRC system.

Impacted

Parties

Bureau SPOCs and GrantSolutions Bureau SMEs should be aware of this change

Technical

Description

The program logic was updated to include an additional condition so that the corresponding SAP ID could be populated after the initial concatenated GrantSolutions User ID and Bureau check. Spool file length was also increased to account for the full email length and this enables the BIO security team to identify the SAP ID for the GrantSolutions user and update the cross-reference table accordingly.

A N

.2

D-05788 - Encrypt the Connections from GRC application to LDAP Servers

Description When the connection is established from GRC application to LDAP servers the password was sent in clear text and DOI Security team has identified this as vulnerability and need to be remediated

Impacted

Parties

BIO Only

Technical

Description

Updated the connections from GRC application to LDAP servers to be encrypted.

Team Sys Admin Team

.F

E B

.2

DOI FBMS BIO Release Notes

R.FEB.22

FINAL

Prepared for All DOI Bureaus:

February 18, 2022

E B

.2

R.FEB.22 Summary

Team Title Impacted Parties

Acquisitions and

Financial Assistance

D-05761 - Custom report added to the BIO support team's xECM role to help troubleshoot user permission errors.

The BIO team who supports Content Server is impacted.

Acquisitions and

Financial Assistance

B-08689 - AFA - PRISM Award Period of Performance

Validations

Contracting Officers, Buyers, PRISM Agreements Officers &

PRISM Grants Specialists

Acquisitions and

Financial Assistance

B-09208 - AFA - Vendor Unique Entity Identifier (UEI) All users that work with Vendors in FBMS and GrantSolutions using DUNS

Acquisitions and

Financial Assistance

B-08690 - PRISM 7.4.11 Upgrade ACQ and FA PRISM users

Acquisitions and

Financial Assistance

D-02343 - AFA - Vendor address updates in PRISM PRISM users that lookup and make vendor assignments

Acquisitions and

Financial Assistance

D-05646 - AFA - GrantSolutions to SAP Award Interface

Technical Correction

Financial Assistance GMOs and GMS users

Acquisitions and

Financial Assistance

D-05636 - AFA - SAM Vendor POC data in FBMS is "cleaned up"

Users that look up Vendor POC data in the SAP Vendor Master

E B

.2

R.FEB.22 Summary

Team Title Impacted Parties

Acquisitions and

Financial Assistance

D-05739 - AFA - Update PO Mass Update program for

Buyers / GSP & GMS

Users that have can perform Purchase Order Mass Updates

Acquisitions and

Financial Assistance

D-05806 - AFA Defect - PRISM Regulatory Updates

January

ACQ PRISM users

Business Intelligence B-09380 - EMIS - UEI updates for EMIS reports FA and AP users

CF - Accounts Payable B-09218 - Add UEI to Custom MO Transaction Users Assigned the AP_MO Role

CF - Accounts Payable B-09277 - Update Payment Warehouse Report with UEI AP Users

CF - Accounts Payable D-05519 - Updated SAP Calendar with Juneteenth Holiday FBMS Users

CF - Accounts Payable D-05604 - Extension of Canadian Bank Account number FBMS MDM team, FBMS ACQ team, FBMS AP team.

CF - Accounts Payable B-09212 - UEI on Vendor Request Form MDM Team, Bureau users that request new vendors

E B

.2

R.FEB.22 Summary

Team Title Impacted Parties

CF - Accounts Payable D-05558 - Payment in Lieu of Taxes (PILT) reports were updated to address various inaccuracies identified by the

PILT Program Office (POB).

Only the PILT Program Office within the DOI Office of Budget

(POB) are impacted.

CF - Accounts Receivable D-05585 - AR - Automatic clearing by Invoice Reference AR Users who need the E564 clearing program

CF - Accounts Receivable D-05840 - AR - Changed NPS Remit address NPS AR Users

CF - Bio Employee Pay

Team

D-05831 - The 2022 IRS Income brackets and tax rates have been loaded for RITA processing

PCS Technicians and Reviewing Officials should be made aware of this change

CF - Controlling/Project

Systems (COPS)

D-05834 - OSM requested a new project mask to include fiscal year for grants at the end of the mask

OSM Project Systems users

CF - Funds

Management/General

Ledger

D-05644 - Batch roles updated to remove authorization to post to journal vouchers due to FY 2018 Notice of

Findings and Recommendations (NFR)

Primarily the O&M Batch team should be aware of this change since the batch roles were updated to exclude the posting authorization for the documents in the JV group.

CF - Funds

Management/General

Ledger

D-05816 - Update GTAS and DATA Act attribute values and crosswalks

GTAS and DATA Act data users

CF - Funds

Management/General

Ledger

D-05803 - OSM required Availability Control be set nine digit Funded Program for new Grant program

OSM Grant and Budget users

E B

.2

R.FEB.22 Summary

Team Title Impacted Parties

CF - Funds

Management/General

Ledger

D-05678 - FM/GL Update GTAS file format to include

Budget Object Class and header line for Treasury

All Bureaus, All GTAS files

CF - Funds

Management/General

Ledger

D-05859 - GTAS and DATA Act updates for February and known March reporting data

GTAS users and BIO Data Act users

CF - Funds

Management/General

Ledger

B-09370 - Automating the close of Anticipated Accounts for

Expired Funds at month end.

GTAS users for all Bureaus

CF - Funds

Management/General

Ledger

D-05710 - New spool role BS_ACRRV allows users to display the results of the accruals reversal job (F.81)

Senior Financial Accountants

CF - Funds

Management/General

Ledger

D-05857 - Update CARS Suffix Derivation for

XXXR56241X

GL Accountants and Cash Accountants

PROP - Energy D-05699 - Add New Energy Type for Propane in Lbs (new number 674)

New Energy Type to be used to record Energy Cost and

Consumption

E B

.2

R.FEB.22 Summary

Team Title Impacted Parties

PROP - Inventory D-04562 - Fixed Issue causing material descriptions to not print on Receipt Forms

BLM Seed Warehouse only

PROP - Real Property D-05804 - Personas Defects to Real Estate Objects Bureau Real Property Users

Reporting (BW/EMIS) D-05665 - The SAP Audit log user activity report Extraction was failing from the XP1 System

BIO Only

Reporting (BW/EMIS) B-09385 - B4HANA and BOBJ Upgrades - Release Notes Bureau users

Reporting (BW/EMIS) B-09384 - BPC 11 Upgrade BPC Users

Security D-05828 - FPPS report was inappropriately flagging new users for deactivation and was missing the FBMS start date and program was updated.

FBMS Bureau SPOCs

Security D-05830 - The role description for the GrantSolutions Grants

Management Officer role was updated to include the certification requirement.

The FBMS Training coordinators and GrantSolutions account controllers must be aware of this update and policy requirement.

Security D-05818 - UAR Requests are generating multiple roles for the same Business Role assignment for all FBMS users and is resolved with an OSS note from SAP to fix the code.

BIO only

E B

.2

D-05761 - Custom report added to the BIO support team's xECM role to help troubleshoot user permission errors.

Description The user account management process for Content Server (also known as xECM) is based off the user's SAP Suite on HANA (SoH) role assignment, which is also mapped to a Content Server group. The content server group manages the user's permissions within Content

Server.

When a Governance, Risk and Compliance (GRC) request is provisioned that contains any SoH roles that are mapped to Content Server, an interface is triggered to complete the subsequent user account management provisioning steps in SoH and Content Server.

In some instances, the interface fails and this report displays the discrepancies between the SoH and xECM assignments. The BIO xECM support then can notify the BIO security team to manually re-execute the interface and resolve the discrepancies. Thus, the user is authorized to execute the permissions as expected per the SoH roles.

Impacted

Parties

The BIO team who supports Content Server is impacted.

Technical

Description

Transaction code ZSEC_COMPARE_CSGRP in ECC, Compare CS Group and ECC Role, added to xECM_BusAdmin xECM Business

Administrator, role.

E B

.2

B-08689 - AFA - PRISM Award Period of Performance Validations

Description Four new validations are added to the PRISM to SAP Award interface which verify that on "PO Lines by Dollars", the Line item Period of

Performance (PoP) dates are within the range of the overall PO Header PO Period of Performance dates.

Ex: Overall PO Header PoP Begin Date: 03/01/2022, PO Header PoP End Date 09/30/2022

This user story was migrated to the Production SAP system on 2/4/2022, but the validations will not be activated until Friday 2/18/2022 to allow communication via the Acquisition SIG and R.FEB.22 release notes.

Impacted

Parties

Contracting Officers, Buyers, PRISM Agreements Officers & PRISM Grants Specialists

Technical

Description

PoP dates validation. Added the below 4 messages for this validation:

The literal "Line" after CLIN identifies the PO Line item.

ZFBMS1:900 CLIN "Line" PoP Start Date mm/dd/yyyy is before PO PoP Start Date mm/dd/yyyy

ZFBMS1:901 CLIN "Line" PoP Start Date mm/dd/yyyy is after PO PoP End Date mm/dd/yyyy

ZFBMS1:902 CLIN "Line" PoP End Date mm/dd/yyyy is before PO PoP Start Date mm/dd/yyyy

ZFBMS1:903 CLIN "Line" PoP End Date mm/dd/yyyy is after PO PoP End Date mm/dd/yyyy

E B

.2

B-09208 - AFA - Vendor Unique Entity Identifier (UEI)

Description The transition in SAM.GOV (System for Award Management) from the Dun and Bradstreet Universal Numbering System (DUNS®), to the Unique Entity Identifier (UEI), will take place on April 4, 2022. The BIO's began the transition on Feb 4, 2022 by moving the UEI

Project into the Production system and populating Active Vendor data with the SAM.gov assigned UEI numbers.

Significant information is available on "The BIO Hub".

https://doimspp.sharepoint.com/sites/os-biohub

Impacted

Parties

All users that work with Vendors in FBMS and GrantSolutions using DUNS

Technical

Description

Technical updates to SAP were implemented in R.DEC.21 to support the UEI data elements. A series of updates have been applied to

PRISM over the past months including one on the weekend of Feb 4, 2022 to support UEI. GrantSolutions updated logic to work with the

FBMS Interfaces using UEI and move it to their Production system on the weekend of Feb 4, 2022 (though GrantSolutions will not convert to using UEI until the weekend of April 3, 2022).

The BIO update numerous programs to store, utilize and report UEI data.

https://doimspp.sharepoint.com/sites/os-biohub/Release%20Notes/Forms/AllItems.aspx?id=%2Fsites%2Fos%2Dbiohub%2FRelease%20Notes%2FRelease%20Notes%20Images&viewid=114b8011%2D87c1%2D4db7%2Db618%2De3ae637d4d0e

E B

.2

B-08690 - PRISM 7.4.11 Upgrade

Description PRISM 7.4.11 Upgrade Adding UEI to Vendor records, Vendor addresses, Vendor tab on documents, and FPDS Pullback tab.

IAA Form - missing Header and Footer fields is resolved and the fields are now available under the Form Fill in.

Impacted

Parties

ACQ and FA PRISM users

Technical

Description

Current PRISM version will be updated to the latest available version of 7.4.11.266The update also includes:

7.4.11.266 Web Patch3

7.4.11 DB Patch 4

7.4.11.236 Patch 1

PRISM update to add UEI on vendor records and documents via the DUNS to UEI Utility and Script.

E B

.2

D-02343 - AFA - Vendor address updates in PRISM

Description This is a technical correction to the SAP to PRISM Vendor Interface (IF030) involving the PRISM mailing zip code not supporting a size over

10 characters since the SAM zip code in FMCCRTVENDORPOC could be up to 35 characters.

Impacted

Parties

PRISM users that lookup and make vendor assignments

Technical

Description

This is a technical correction to the SAP to PRISM Vendor interface included updating program stored procedures..

E B

.2

D-05646 - AFA - GrantSolutions to SAP Award Interface Technical Correction

Description When a Financial Assistance user is in the GrantSolutions GMM module and presses "Save and Verify", the GrantSolutions to SAP Award interface (IF1908) is run. The interface uses standard SAP functionality to control the SAP validations which invokes record locks during the process. The interface sends a return code back to GrantSolutions so that it knows to either display any errors or allow continuation of processing. Prior to this program change, the interface sends the return code to GrantSolutions before the interface is 100% complete ending processing. Sometimes when processing an award with a large number of PO lines and/or a PR with a large number of PR Lines, the GMO will get an error message saying "GS2SAP is still processing". We hope that this technical correction will eliminate the "G2SAP is processing ...." error message.

Impacted

Parties

Financial Assistance GMOs and GMS users

Technical

Description

This technical correction changes the timing of when the interface sends the return code to GrantSolutions. With this technical correction, the interface sends the return code to GrantSolutions a few moments later after the program has completed releasing locked records. For small awards (less than 50 award lines) there should be no noticeable difference in processing times. For awards with over 50 lines, there it may appear to take a few seconds more to process.

E B

.2

D-05636 - AFA - SAM Vendor POC data in FBMS is "cleaned up"

Description SAM data has been received into FBMS for over 10 years and we never designed a process to maintain Vendor POC types that are no longer maintained by a vendor. When a vendor updates their SAM registration, SAM.gov sends the most recent data to FBMS while also retaining historical data in SAM.gov. A vendor may choose to no longer identify certain POC types, but the FBMS update program had no logic to identify the changes. All active POC data is in FBMS. Any historical data can be accessed in SAM.gov. When a vendor SAM.gov registration expires or the vendor deletes their SAM.gov registration, FBMS retains the last active POC data.

Impacted

Parties

Users that look up Vendor POC data in the SAP Vendor Master

Technical

Description

A vendor entry in the SAM.gov file contains all of the active vendor POC data that a vendor provides to SAM.gov. When a vendor update is received, this technical correction first deletes all of the existing POCs for that vendor and then recreates the data based on the latest file information. This approach along with some other "housekeeping" logic changes reduces the total SAM Vendor POC file from approximately

21,000,000+ entries to approximately 6,000,000+ entries.

E B

.2

D-05739 - AFA - Update PO Mass Update program for Buyers / GSP & GMS

Description Transaction CO/COR/AGO Mass Update" has been updated to also allow mass updates of the Buyer on Acquisition Awards and the Grants

Specialist / Grants Management Specialist on Financial Assistance awards. Two additional selection criteria have been defined to "Update

Buyer" and "Update GSP / GMS".

Users with the role ACQ_MSUPD can now perform mass updates to the assigned buyer. Users that need to update Financial Assistance awards must have role ACQ_MSUPD and also one of several other roles that provide authorization to update Financial Assistance awards.

Impacted

Parties

Users that have can perform Purchase Order Mass Updates

Technical

Description

Two additional selection options are added to allow update to a Buyer or update to a GSP / GMS. Based on the selection (Buyer) or (GSP /

GMS), the program restricts the "New Buyer" or "New GSP / GMS" by Bureau and role. For example, if a NPS user is performing a mass update of a Buyer, the user will only see NPS Buyers available for data selection.

E B

.2

D-05806 - AFA Defect - PRISM Regulatory Updates January

Description PRISM Regulatory updates (Preapproved change#3):

1) FAR FAC, 2022-02 and 2022-03, effective 1/14/2022 and 1/1/2022 respectively

2) FAR FAC, 2022-04, effective 1/26/2022

3) GSAR 55, effective January 20, 2022

4) DFARS 87, effective December 30, 2021

Impacted

Parties

ACQ PRISM users

Technical

Description

E B

.2

B-09380 - EMIS - UEI updates for EMIS reports

Description Added Vendor UEI information in the below EMIS reports:

• General Customer Query – Restricted - X0CUSTOMER_SC_Q999

• General IPAC Query - WARM02_SP_Q001

• FA Awards IMATS Extract - WFAM08_SK_Q007

There are few more reports which inherited the Vendor UEI fields and these new fields will be available to use in the reports.

Impacted

Parties

FA and AP users

Technical

Description

Added the following two fields in the Vendor and Customer master and in the reports:

1. SAM UEI

2. SAM EFT Indicator

Team BI Team

E B

.2

B-09218 - Add UEI to Custom MO Transaction

Description Added UEI or EFT Indicator number fields to the search vendor pop-up.

Impacted

Parties

Users Assigned the AP_MO Role

Technical

Description

Added UEI field for vendor search for MO Webdynpro PO

E B

.2

B-09277 - Update Payment Warehouse Report with UEI

Description The Payment Warehouse Report output was modified to include UEI and EFT Indicator fields.

The search help available on the input screen was also modified to allow for searching by UEI.

Impacted

Parties

AP Users

Technical

Description

Added fields UEI and EFT Indicator to the ALV report 'Payment Warehouse Report'. Get the data from table LFA1 and display on the report.

E B

.2

B-09277 - Update Payment Warehouse Report with UEI (Cont)

E B

.2

B-09277 - Update Payment Warehouse Report with UEI (Cont)

E B

.2

D-05519 - Updated SAP Calendar with Juneteenth Holiday

Description Update SAP Factory Calendar for newly enacted legislation making June 19th (also referred to as Juneteenth, Freedom Day or

Emancipation Day) a federal holiday. This setting is a part of SAP calendar master settings and is required to ensure programs/processes that associate working days and non-working days.

Impacted

Parties

FBMS Users

Technical

Description

Added Juneteenth to the calendar configuration.

E B

.2

D-05604 - Extension of Canadian Bank Account number

Description Multiple bureaus have reported a limitation in FBMS that prevents the MDM team and other FBMS interfaces from loading the full Canadian bank account number. The FBMS BIO AP team isolated the configuration and adjusted the length of Canadian Bank Accounts from 10 digits to 12 digits. Bureaus can now modify current records and pay all Canadian accounts using the normal payment run and not be forced to manually enter these payments in ITS. The main bureaus impacted by this production issue were NPS, FWS and USGS although all bureaus are now up and running on ITS.

Impacted

Parties

FBMS MDM team, FBMS ACQ team, FBMS AP team.

Technical

Description

Country specific bank details were modified in SPRO. All changes were tested in RD1 and RQ1 and marked as ready for release. In addition, the BIO AP team worked with and conducted an addition test with ITS to ensure the transmission would pass all validations.

E B

.2

D-05604 - Extension of Canadian Bank Account number

E B

.2

B-09212 - UEI on Vendor Request Form

Description UEI now shows on Vendor Request Form if needed for emergency ZMAN record request made prior to updating to ZDOM record created from SAM

Impacted

Parties

MDM Team, Bureau users that request new vendors

Technical

Description

Added logic for check SAM Unique Entity Identifier and SAM Electronic Funds Transfer Ind for both create and change options.

E B

.2

B-09212 - UEI on Vendor Request Form (Cont)

E B

.2

D-05558 - Payment in Lieu of Taxes (PILT) reports were updated to address various inaccuracies identified by the PILT Program Office (POB).

Description Several non-formatted PILT comparison reports needed updates to the order of columns (should be Current Year (CY) then Prior Year (PY)).

Additionally, the reports should use amounts paid in the year, not amounts calculated for the year. The following reports had errors corrected as specified:

In the three (3) Certification-Comparison reports (Compare by County GT; Compare by County LT; Compare by State, the order of "Total

Federal Payments", "Total Acres", "PILT 69045 After Admin", and "PILT Population" pairs of Key figures were corrected so that each pair is consistent with Current Year (CY) then Prior Year (PY). The misspelling of the word "Payements" has been corrected in the "Total Federal

Payments % Change" Key Figure title. The "PILT Final" amounts (CY and PY) now display the Paid amounts, not the Calculated amounts.

The “General PILT Query – Final Results” (Multiple and Single Scenario versions) had the misspelled word Deffered, which was corrected to read Deferred, in the the Deferred 6902 Adjustments and Deferred 6904 Adjustments columns.

Several formatted PILT reports were identified as using an incorrect "base scenario" for comparison. The common logic for the reports was changed to determine and select the base scenario as the last prior scenario with paid amounts, not simply the last scenario created. The following reports were updated with this correction: Certification – Compare by State; County Check Acreage; County – Check Federal

Payment; County - No Acreage; County - No Payment; County - Population Zero; Prior Year Payments by County.

Impacted

Parties

Only the PILT Program Office within the DOI Office of Budget (POB) are impacted.

Technical

Description

The following changes are completed for PILT reports. No BW Data Loads are involved for these reports.

1.Order of Key Figures: Key figures in report layout will have CY first, followed by PY.

2.Misspelled column names were corrected (Payements, Deffered are misspelled).

3.In comparison reports, for Actual Scenarios, Reports should compare Selected Actual Scenario(Actual Scenario selected on prompt screen) with Last Paid Actual Scenario (Previous Actual Scenario with amount paid > 0$). For Predicted scenario , selected Predicted scenario has to be compared with its Base scenario.

E B

.2

D-05585 - AR - Automatic clearing by Invoice Reference

Description The E564 Clearing program is not able to clear groups of documents by invoice reference. due to the invoice reference being blank on the original invoice but populated on the collections.

Impacted

Parties

AR Users who need the E564 clearing program

Technical

Description

We updated the program to move the document number to the invoice reference if the invoice reference is equal to Blank or "V".

Team AR Team

E B

.2

D-05840 - AR - Changed NPS Remit address

Description Changed the phone number on the NPS remit address

Impacted

Parties

NPS AR Users

Technical

Description

Changed the phone number on the NPS remit address

Team AR Team

E B

.2

D-05831 - The 2022 IRS Income brackets and tax rates have been loaded for RITA processing

Description IRS published the 1040-ES form for 2022. Per the FTR the income brackets and tax rates outlined on form 1040-ES are used for RITA

(Relocation Income Tax Allowance) calculations. The ZRITA_FEDTAX custom table has been updated with 2022 values.

Impacted

Parties

PCS Technicians and Reviewing Officials should be made aware of this change

Technical

Description

The ZRITA_FEDTAX custom table has been updated with 2022 values.

Team BIO Employee Pay Team

E B

.2

D-05834 - OSM requested a new project mask to include fiscal year for grants at the end of the mask

Description OSM requested a new project mask to include fiscal year for grants at the end of the mask. The existing mask is in the following format

(SG.XXX.XX.XX) . It shall be extended to SG.XXX.XX.XX .XX.

Impacted

Parties

OSM Project Systems users

Technical

Description

The existing mask is in the following format (SG.XXX.XX.XX) . It shall be extended to SG.XXX.XX.XX .XX.

E B

.2

D-05644 - Batch roles updated to remove authorization to post to journal vouchers due to FY 2018 Notice of Findings and Recommendations (NFR)

Description Due to an FY2018 Notice of Findings and Recommendation regarding posting to journal voucher (JV) document types, the authorization to post to the document types is restricted to a new authorization group, JV. Roles were previously updated and released for October 2020 but several batch roles were missed in the migration of the changes.

The batch roles BA_ASAP Batch role for Mult ASAP Prgms - ZB*_SAP (All), BA_CBS Batch role for CBS Interface, BA_CCD Batch role for Program FII_CCARD_FILE_UPLOAD (CEN) IF44, BA_FBCS Batch role for

ZARI_FEEBACS_INVPOST and BA_PODS Pods Batch Processing were updated, re-tested and validated that they were included in the migrated changes.

This change will ensure that for future audit samples for JV related document types, they can be cleanly extracted from the system.

Impacted

Parties

Primarily the O&M Batch team should be aware of this change since the batch roles were updated to exclude the posting authorization for the documents in the JV group.

Technical

Description

For the roles below, authorization object F_BKPF_BLA was updated to include the valid values except for JV and DP00, specifically add

9999, TRAV, ZADV, ZLAW, ZPCS, ZTRV. Roles were transported to ensure all child roles were included.

BA_ASAP Batch role for Mult ASAP Prgms - ZB*_SAP (All)

BA_CBS Batch role for CBS Interface (Ref)

BA_CCD Batch role for Program FII_CCARD_FILE_UPLOAD (CEN) IF44

BA_FBCS Batch role for ZARI_FEEBACS_INVPOST (G

BA_PODS Pods Batch Processing (includes DP00).

E B

.2

D-05816 - Update GTAS and DATA Act attribute values and crosswalks

Description Continued mapping new master data to appropriate Program Activities for DATA Act reporting as well as new funds to Disaster Emergency

Relieve Codes (DEFC). Also made updates to Category B Apportionment Detail mappings. These mappings are considered part of the Anti

Deficiency Act (ADA) level of budget control and also crosswalk the MAX Budget system to the SF133. Additionally they help with mappings of the Program Activity and DEFC.

Impacted

Parties

GTAS and DATA Act data users

Technical

Description

Update A: DEFC by Fund adding 22XR06801W = Z

Create three new Apportionment Cat B Detail rules for Infrastructure Law

A: assign 6022 to Appt. Cat. Prog. Code BIL(Infrastructure) Condition FA(5) = AIF11

A: assign 6023 to Appt. Cat. Prog. Code BIL(Infrastructure) Condition FA(5) = AIF31

A: assign 6024 to Appt. Cat. Prog. Code BIL(Infrastructure) Condition FA(5) = AIF32

Update FWS PA by Functional changing FA FRS3425 description from RECREATIONAL ACCESS PROJECTS to SPORTSMEN AND

RECREATIONAL ACCESS

Update BLM PA by Functional Area changing FA description L3311 from LAND ACQUISITION PROJECT to LWCF_GAOA adding L3331* 0004 LWCF_GAOA_MGT changing L5325* from 0006 REPAIR OF DAMAGED LANDS to 0012 SCDF - FIRE TRESPASS changing L5326* from RPR DMG LND O&C FIRE TRSP to SCDF - FIRE TRESPASS changing LF311* from FUELS MA to NAGEMENT to FIRE EMERGENCY SUPP, P.L. 117-43 changing LF321* from BURNED AREA REHABILITATION to FIRE EMERGENCY SUPP, P.L. 117-43

E B

.2

D-05803 - OSM required Availability Control be set nine digit Funded Program for new Grant program

Description OSM has a new Grant program where they are required to keep funding separated by Budget Fiscal Year. The fund being used is a no year fund and is already in use as XXX. The solution moving forward is that the fiscal year will be digits eight and nine of the funded program so they can be separated.

Using the condition of the first eight digits will control budget at the first nine digits. Conditions will be created for SG210IL2 and SG210IL3 since the funding is available until 2036 (prevents future maintenance.

Impacted

Parties

OSM Grant and Budget users

Technical

Description

Update AVC derivation rules

E B

.2

D-05678 - FM/GL Update GTAS file format to include Budget Object Class and header line for Treasury

Description Apply SAP Notes 3046908 Add BOC to GTAS and 3100521 Add FORMAT=B to header

The FBMS transaction will remain the same from a user perspective but the additional field Budget Object Class (BOC) will be added to the end of each line in the file. Treasury will use the header line "FORMAT=B" to determine which file format is being used by each Agency in order to use the correct translation for Edits and Validations.

Impacted

Parties

All Bureaus, All GTAS files

Technical

Description

Apply SAP Notes 3046908 Add BOC to GTAS and 3100521 Add FORMAT=B to header

E B

.2

D-05859 - GTAS and DATA Act updates for February and known March reporting data

Descriptio n

Continued mapping new master data to appropriate Program Activities for DATA Act reporting as well as new funds to Disaster Emergency

Relieve Codes (DEFC). Also made updates to Category B Apportionment Detail mappings. These mappings are considered part of the Anti

Deficiency Act (ADA) level of budget control and also crosswalk the MAX Budget system to the SF133. Additionally they help with mappings of the Program Activity and DEFC.

Impacted

Parties

GTAS users and BIO Data Act users

Technical

Descriptio n

Continued on the next page

E B

.2

D-05859 - GTAS and DATA Act updates for February and known March reporting data

L72300000.000000 L7230ZZZZ.ZZZZZZ = 0006 DONATIONS

L72100000.000000 L7210ZZZZ.ZZZZZZ = 0006 DONATIONS

L72200000.000000 L7220ZZZZ.ZZZZZZ = 0006 DONATIONS

L72400000.000000 L7240ZZZZ.ZZZZZZ = 0006 DONATIONS

L72500000.000000 L7250ZZZZ.ZZZZZZ = 0006 DONATIONS

L72600000.000000 L7260ZZZZ.ZZZZZZ = 0006 DONATIONS

L72700000.000000 L7270ZZZZ.ZZZZZZ = 0006 DONATIONS

L72710000.000000 L7271ZZZZ.ZZZZZZ = 0006 DONATIONS

Update USGS PA by AoF 5198 and 1618 by Funded Program

GX22MN00F92LO00 = 0003 Other restoration

GX22SB00C2GBN00 = 0001 Damage assessments

GX22SB00C2GEB00 = 0001 Damage assessments

GX22SB00C2GLF00 = 0001 Damage assessments

GX22SB00C2GML00 = 0001 Damage assessments

GX19SB00C2GDA00 = 0001 Damage assessments

GX19SB00C2GKR00 = 0001 Damage assessments

GX22SB00C2GHD00 = 0001 Damage assessments

GX22SB00C2GPM00 = 0004 Program management

GX22SB00COM16X1 = 0001 Damage assessments

Update IA PA by USERTEMP3 (last 7 of fund) and FA

A1125DR AF3000000.000000 AF3ZZZZZZ.ZZZZZZ = 0012 2022 Disaster Supplemental

(P.L. 117-43)

FWS PA by Functional Area

FFRK70000.000000 FFRK70000.000000 = 0012 2022 Bipartisan Infrastructure Law (P.L.

117-58)

FFRS40000.000000 FFRS40000.000000 = 0012 2022 Bipartisan Infrastructure Law (P.L.

117-58)

FRSS30000.000000 FRSS30000.000000 = 0012 2022 Bipartisan Infrastructure Law (P.L.

117-58)

FSCD10000.000000 FSCD10000.000000 = 0012 2022 Bipartisan Infrastructure Law (P.L.

117-58)

BOR PA by USERTEMP3 (last 7 of fund)

R068080 0008 2022 DISASTER SUPPLEMENTAL (P.L. 117-43)

R4081XD 0801 FACILITY OPERATION

R4081XE 0802 FACILITY MAINTENANCE & REHABILITATION

Worked with Kim S and Laura N from POB to update Cat B Detail codes for Fire/Disaster Relief/BIL

Time of Reporting rules

A: assign 6012 to Appt. Cat. Prog. Code adding F290 and F231 and removing F460 and F561

A: assign 6013 to Appt. Cat. Prog. Code remove F290 and F231

A: assign 6015 to Appt. Cat. Prog. Code remove F581

A: assign 6018 to Appt. Cat. Prog. Code remove F690 and F690 replace with F4, F5, and F6

Create A: assign 6020 to Appt. Cat. Prog. Code Disaster Relief conditions AF3DR1, F311, DRP31

Create A: assign 6021 to Appt. Cat. Prog. Code Disaster Relief conditions AF3DR2, F321, DRP32

Create A: assign 6022 to Appt. Cat. Prog. Code BIL(Infrastructure) conditions AIF11, F102, F111, I111, DIP10

Create A: assign 6023 to Appt. Cat. Prog. Code BIL(Infrastructure) conditions AIF31, F312, DI312, DIP31

Create A: assign 6024 to Appt. Cat. Prog. Code BIL(Infrastructure) conditions AIF32, F322, DI322, DIP32

Create A: assign 6025 to Appt. Cat. Prog. Code BIL(Infrastructure) conditions LF342, PF341, DIP34

A: DEFC by Fund adding 22XR0787ZR = X,…

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .