Skip to Main Content

United States Department of Agriculture

Financial Shared Services

Additional Links
National Finance Center
Subscribe
About
Contact Us

FMS Release Results

FMS Results – Requests for Change (RFC)
September 1 – 30, 2018 (Emergency/Out-of-Cycle)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Production Date
33370

FMMI
Modify the Payment Request (STNFCA) and the Summary Schedule TAS/BETC (440) files to comply with Treasury Format.

FAS 9/7/2018
33224

Data Act
Implement the Data Act Dashboard. The dashboard will enable department leadership to define, analyze, collect and report on extensive amounts of financially related data.

ALL 9/14/2018
33539

Data Act
Update the field validation routine for the D2 File to change ‘FUNDING AGENCY OFFICE CODE’ and ‘AWARDING AGENCY OFFICE CODE’ to required fields.

ALL 9/28/2018

FMS Financial Systems Release Results
Requests for Change (RFC) - August 1 – 31, 2018 (Emergency/Out-of-Cycle)

Change Request (RFC) Description Agency Production Date
33425

CPAIS-PP
Allow CPAIS-PP to receive the correct FMMI Outbound data by completing the following:

  • Identify and send the correct credits
  • Prevent Good Receipts and Invoice Receipts submission of WE documents for 3-way match.

Consolidate the last line with the previous line to correct the Rule Based Account Assignment (RBAA) rounding issue.

ALL 8/24/2018
32188

GRANTS
Add missing fields (Funding Sub-Tier Agency Code, Funding Office Code, Awarding Office Code, Primary Place of Performance Congressional District (INC0063621), and Business Funds Indicator) in the CRM Agreement screen and update the CRM data extract for the DATA Act D2 File. As a result, data will be submitted to Treasury without agency intervention.

ALL 8/24/2018

FMS Financial Systems Release Results
Requests for Change (RFC) - August 1 – 31, 2018 (Emergency/Out-of-Cycle)

Change Request (AI) Description Agency Production Date
33265

GRANTS
Modify the Award Form to display the correct date of signature for the recipient signature. The recipient signature date was being overwritten by the final signature date of the agency official.

APHIS 8/17/2018
33560

FMMI
Modify the FNS Lockbox to reprocess items with correct postings and avoid using FB05 manually.

FNS 8/17/2018
33494

MoveLINQ
Correct the SAP error “FI/CO Interface: Balance in transaction currency” received when processing the 2016/2017 RIT vouchers in MoveLINQ.

ALL 8/24/2018
33461

GRANTS
Update the FNS AR Approver Role to be given authorization to reverse AR collection documents that are tied to GD Funds Commitments.

FNS 8/24/2018
32752

BSF
Modify BSF Report(s) to include the appropriate CI hierarchy once the user prints to PDF.

ALL 8/24/2018

FMS Financial Systems Release Results
Requests for Change (RFC) - August 10, 2018 (Scheduled)

Change Request (RFC) Description Agency Release Results
30322 Correct General Ledger (GL) posting for Lockbox Cash on Delivery (C.O.D.) collections against Revenue Source Code (RSC) 0100 to post to 5900000100 APHIS N/A
32147 Modify the CPAIS Personal Property Access Control Management View/Request Access form to allow manual entry into the Agency field. ALL N/A
32194 Populate Customer Name on the header text field of Food Safety and Inspection Service (FSIS) Lockbox documents. APHIS N/A
32630 Modify the Integrated Acquisition System (IAS) to Financial Management Modernization Initiative (FMMI) interface to not create an invoice in FMMI where the invoice amount is greater than the open amount of the Purchase Order (PO). ALL N/A
32837 Update the High-performance Analytic (HANA) Spending Detail Universe to include the Purchase Order Line Item Text field which is stored in SAP text tables. This will allow users to utilize the Interagency Agreement (IAA) number. ALL N/A
32998 Add new MCA Multiprovider Fields – Pay Plan, Grade & Emp Type. ALL N/A
33056 Add additional fields (PO Line/Item Number and Industry Key) to the HANA Spending Detail Universe and the corresponding Analytical/Calculation views in HANA. As a result, users will have the capability to conduct a comprehensive spending analysis and link the respective Logistic Invoice Verification (LIV) line item to the corresponding Purchase Order line item. ALL N/A
33101 Open the First, Middle Initial, and Last name fields of the Vendor Master record to allow the fields to be populated from the approved Pre-Approved Vendor (PVND) Request. As a result, the PVND request screen will open the supplemental traveler information for account groups Employee (ZEMP) and Invitational Traveler (ZINT). This is required as part of the PVND employee record maintenance process in association with the mLINQS System. ALL N/A
33113 Remove payment block on the customer record when a Pre‑Approved Vendor (PVND) Request Tax Identification Number (TIN) match is successfully matched as a 6,7, or 8. ALL N/A
33202 Modify the Lockbox Re-processor (transaction ZLBR) to prevent the timeout issue by placing an upper limit on the number of receivables that can be processed per check. ALL N/A
33229 Add Work Breakdown Structure (WBS) from the Cost Management Module to the Reimbursable Orders Report Output.  This will allow end users to see which Sales Orders had the WBS Element changed and to exclude them. ALL N/A
33257 Create Open Advance report to allow users to manage advance related transactions on the Overseas Management System (OMS) interface. The report will combine data from the Funds Commitment document, Vendor Master and Funds Commitment Consumption tables to provide a summary per funds commitment item of advance, liquidated and available amounts.  ALL N/A
33267 Create an agency role to access migrated historical travel relocation data in FMMI. ALL N/A
33336 Update BSF (Budget Status and Forecast Application) Process Chains to account for employee transfers across HROrg. by modifying the payroll process chains to “purge/zero-out” all payroll projections for current and future years when an onboard employee changes HROrg planning levels. ALL N/A
33352 Create the BOBJ_ADMIN roles for all agencies which will allow effective management of the BOBJ folders created by agency personnel by the functional administrators. ALL N/A
33363 Modify CPAIS-Personal Property (CPAIS‑PP) inbound to accommodate Budget Period length increase from 4 to 10 positions.  ALL N/A
33377 Update the Manual Collections Processor (ZMCP) to allow multiple Payment Numbers to be entered on the screen. MRP/FSIS N/A
33458 Update the sweep Program with the following checkboxes:
  • "Receiver Funded Program Same as Sender FP" - If the checkbox is selected, copy the sender funded program to the receiver funded program. If not selected, the receiver funded program will be FPDEFAULT.
  • "Receiver Funds Center Same as Sender FC" - If the checkbox is selected, copy the sender funds center to the receiver funded program. If not selected, the receiver funds center will be FN00000000.
  • "Receiver Functional Area Same as Sender FA" - If the checkbox is selected, copy the sender functional area to the receiver functional area. If not selected, the receiver functional area will be AGDEFAULT. Cancelled budget periods will be on the output option.
FNS N/A
33460 Create a new FNS security role and allow it to be assignable to FNS Users through GRC request. This role will allow the FNS users to see the ZARIFN_AR_OFFSET table in the FMMI Portal through a custom Z transaction. FNS N/A

FMS Financial Systems Release Results
Action Items (AI) - August 10, 2018 (Scheduled)

Change Request (AI) Description Agency Release Results
30066 Update the Corporate/Inspection Lockbox Re-processor to change the cash account on S2s (Suspense Documents) for Expenditure Refunds. APHIS N/A
32858 Update the Inspection Lockbox pre-processor to create a single S2 (Suspense Document) for the unassigned amount per check. FSIS N/A
32928 Add Federal/Non-Federal Indicator to the FNS Status of Funds Universe.  As a result, the FNS Status of Funds Universe will be able to support the FMMI, FSDW and GTAS reconciliation. FNS N/A
33107 Allow the customer name to display on the High-Performance Analytic Appliance (HANA) Accounts Receivable (AR). ALL N/A
33154 Modify the Shorthand Code (SHC) Publish Job (Modify ZFIX_SHC_PUBLISH_CHANGES Program) to publish only System-relevant SHCs. ALL N/A
33165 Update the Purchase Order Form in Web Portal to Include the 'Public Sector' tab. ALL N/A
33271 Update BOBJ to accept the Document Date when the data is converted/pulled from the HANA Federal Transaction Register (FTR) Universe. ALL N/A
33278 Update the SmartPay2 Payment Confirmation backfeed program (ZFISP_PAY_CONF_TO_SMARTPAY)  to properly record credit memo transactions in the detail lines of the payment. ALL N/A
33285 Modify Integrated Acquisition System (IAS) invoice receipts processing for 3-way match invoices with Goods Receipt to properly identify invoice lines with multiple account assignments. ALL N/A
33456 Update the FNS Sweep program to exclude cancelled budget periods to be moved onto another budget fund. Cancelled budget periods will instead be on the output option. The log errors will be added and made displayable when a scenario has not been executed, instead of short dumping. FNS N/A
33485 Split the amount calculations and send no more than two decimal places in the FMMI posting. FAS N/A

FMS CPAIS Personal Property v. 1.8 Release Results
Requests for Change (RFC) – August 3, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
33363 Modify CPAIS-Personal Property to accommodate the Budget Period length increase from 4 to 10 positions. ALL N/A

FMS CPAIS Personal Property v. 1.8 Release Results
Action Items (AI) – August 3, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
32147 Modify the Access Control Management View/Request Access form to allow manual entry into the Agency field. ALL N/A
33395 Update the functionality of the Save button on all tabs/screens within the Designate Manager Form. ALL N/A

FMS Grants Release Results
Change Requests (CR) – July 16, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
N/A There are no Grants RFCs in this Release N/A N/A

FMS Grants Release Results
Action Items (AI) – July 16, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
33326 Update the NIFA amendment workflow for the ‘Change in Program Manager’ amendment type to route work items to the Program Director. This amendment workflow will be followed when the amendment contains no additional changes aside from the change to the Program Manager. As a result, amendments will be routed to the correct approver and adhere to the initial requested workflow design. NIFA N/A
33327 Update CRM Award Face Sheet to include the correct reporting frequency based on the information maintained in the system. APHIS users will be able to view the reporting frequency on the face sheet. APHIS N/A
33328 Enable edit button for NRCS users to delete attachments uploaded to Collection Agreements in CRM. NRCS N/A
33329 Update the Agreement Item list screen to enable Expense Type column for FAS and NRCS claims. NRCS/FAS N/A
33332 Increase search result default number in the ezFedGrants External Portal to 10,000 for Applications, Opportunities, Claims, Reports, and Repayments. Users will now be able to see all associated instances in their search results. ALL N/A
33333 Update APHIS Financial and Performance Report correspondence so that GAOs receive all email notifications for reports assigned to their organization. APHIS with enterprise standard. APHIS Experienced PEGA issues during QA testing. Will migrate when ready.
33334 Fix the currency amount as a 2-digit decimal in Pega Claims so that claims no longer fail in communication between Pega and CRM. ALL N/A
33335 Update the Final Claim status to “Paid” from “Accepted for Payment Processing” in Pega as an enterprise solution. External users will now be able to view claim status as “Paid” in Pega. ALL N/A
33389 Remove the ability to submit claims through ezFedGrants for NIFA agreements. NIFA N/A
33390 Update the character limit to 5000 in the "News and Notes" section of ezFedGrants. As a result, users will be able to post news and notes by directly typing into the rich text box or copy/paste from a Word document or website. ALL N/A

FMS DATA Act Release Results
Change Requests (CR) – July 16, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
N/A There are no DATA Act RFCs in this Release N/A N/A

FMS DATA Act Release Results
Action Items (AI) – July 16, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
33349 Update the DATA Act Error Reports and Certification Reports to reflect the Treasury submission files and modify each error report to accurately show the elimination of "error free" records due to their matching records "with errors" in another file. ALL N/A
33350 Add accounting elements to the available objects on the File B Error Report to support researching of issues. ALL N/A
33351 Add accounting elements to the available objects on the File C Error Report to support researching of issues. ALL N/A
33378 Update the mapping for Financial Statement Data Warehouse (FSDW) adjustment records to use Budget Object Code (BOC) 2599 within HANA. This will allow adjustment records to attain Data Act readiness for Treasury consumption. ALL N/A
33402 Revise wording for FMMI quarterly agency Files A, B, C, and D2 agency notifications. ALL N/A
33465 Correct the data overflow error caused by mismatch on the field length between the HANA model and the data values. ALL N/A

FMS CPAIS Real Property Release Results
Requests for Change (RFC) – June 8, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results

33262

Increase the Subledger field to 50 positions. As a result, users will not receive an error or a subledger screen when attempting to query records with statuses greater than 34 characters.

All

 

32399

Create a role for Forest Service (FS) to utilize the information in Corporate Property Automated Information System Real Property (CPAIS RP) for Housing and Urban Development (HUD) reporting. This change will allow users to query property records, but only enter or modify the HUD form for specific data. No actual property record data can be entered or modified.

All

 

32694

Update the Disposal Hold Expiration Date field to display a date, which is the Published Date + 30 days. This will change properties that are suitable and available from having a 60 day holding period.

All

 

FMS CPAIS Real Property Release Results
Action Items (AI) – June 8, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (AI) Description Agency Release Results

32836

Modify the HUD forms (Main Menu and Details) to display the Org Code in the Org Field instead of the Agency Bureau Code.

All

 

33149

Update the Owned Property, Maintain Property and Property Explorer forms with the following:

  • Save building records that are not Office records regardless of the location of the cursor on the form.
  • Update the Building forms on the Utilization Tab, Personnel Count Workspace, to save building records that are not an OFFICE record regardless of the location of the cursor on the form.

All

 

33150

Update the Maintain Housing and Urban Development records to perform exports per the CPAIS standard.

All

 

33153

Update the Government Services Administration Assignment functionality as follows:

  • Ensure history records are created when mandatory fields are changed on GSA assigned records on the Maintain Property form.
  • Populate charge records in the Charge block on the GSA Assignment form.
  • Modify the Property ID field LOV (List of Values) on the GSA Assignment form so that the list does not include DISPOSED buildings. The list should only include EX% buildings.

All

 

FMS Results – Requests for Change (RFC)
May 1 – 31, 2018 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Production Date

33205

CPAIS-PP

Modify the FMMI to Corporate Property Automated Information System (CPAIS) Outbound Interface to pick up all relevant records in FMMI that should be transmitted to CPAIS Personal Property. This will enhance the Interface code to strengthen its ability to extract the correct records.

ALL

5/11/2018

33004

FMMI

Prevent overwriting the original Salesperson information on the Communication tab of the Purchase Order (PO), and restrict it to only the Miscellaneous Object Submission Tool (MOST) process. Also, the Header Changes information will provide the information as to who last modified the PO.

FS

5/18/2018

Included in the May Release

33438

FMMI

Establish a new Business Area (FB00) under the Farm Production and Conservation umbrella in the Financial Management Modernization Initiative (FMMI) system. This will allow for the immediate processing of FB50 (GL documents), and will serve as the agency that services (NRCS, RMA and FSA).

FPAC

5/23/2018

33354

moveLINQ

Allow the moveLINQ field ‘Amount Subject to Tax’ versus the ‘Taxable Amount’ field to be included in the daily, weekly, and bi-weekly files and reports being transmitted to the National Finance Center (NFC). As a result, the outbound taxable amounts to the NFC will be accurate and NFC will be able to remit federal and state taxes.

ALL

5/23/2018

FMS Release Results – Action Items (AI)
May 1 – 31, 2018 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (AI) Description Agency Production Date

33422

Grants

Add new Catalog of Federal Domestic Assistance (CFDA) values to NRCS.

NRCS

5/1/2018

33123

FMMI

Apply OSS notes 2541250 and its prerequisite note 2271715 and OSS Notes 2605322 and 2630203 into all environments.  This will prevent further FM issues and erroneous BL document postings.

ALL

5/4/2018

33405

FMMI

Allow the standard Inbound Intra-Governmental Payments and Collections (IPAC) Processing program to return the correct Logistical Invoice (LIV) document number when posting to a Purchase Order (PO) by applying the SAP OSS Note 1494939 to the system. As a result, the IPAC process will return the FI document associated to the LIV instead of the Budgetary Ledger (BL) document, allowing the LIV to be cleared automatically. 

ALL

5/4/2018

33200

FMMI

Modify the selection of Request records on the FS Billing Global Report to select requests based upon the date of the last action taken on a request, rather than the original creation date. Also, modify the retrieval of billing document number on request with "POST" status to retrieve the billing document from the database record in FMMI, by searching table BKPF using the Request number.  As a result, the Forest Service Billing Global Report will not have missing request entries and the request items on the report with “POST” status will have a billing document number.

FS

5/18/2018

Included in the May Release

33419

FMMI

Update the Availability Control (AVC) derivation to group Commitment Items 100-1400 to "Labor" and all the rest to "ALLOBJECTS" for all Fund Centers starting with FNA (the first 3 positions of the Funds Centers). Also, change the level of control for all Fund Centers starting with FNA at the first 3 characters to facilitate better reporting.

FNS

5/18/2018

FMS Financial Systems Release Results
Requests for Change (RFC) – May 11, 2018 (Scheduled)

Change Request (RFC) Description Agency Release Results
30967 Prevent the creation of Sales & Distribution (SD) Order by Reference. This will eliminate the risk of creating SD orders with reference and creating inaccurate balances in 4210. All  
31530 Update the High-Performance Analytic Appliance (HANA) Sales Order History Report Advances column to include debit memo cancellations for non-advance type Sales Orders, credit memos, and Treasury Confirmations (TC). All  
31587 Modify the HANA Sales Order History report to not show activity on blocked Sales Order lines. All  
32368 Create new Block Reason Codes "NM" No Match and “TM” TIN Matched for Vendor Customer Maintenance. All  
32871 Convert the FMMI BI/BOBJ Payroll Universe to an ECC/Real Time report. All  
32972 Implement Grantor Billing (GTR Billing) and the Financial Management Modernization Initiative (FMMI) FMUSFGA table as an extract. This will enable FNS to relate Automated Standard Application for Payments (ASAP) transactions to the invoice and the cash transaction. FNS User Acceptance Sign-Off was not received. Change will be moved once testing is complete.
33036 Remove the PO Box from the SD & FI bills. This data will be replaced with the customer service e-mail address for all correspondence. APHIS  
33115 Modify the Intra-Governmental Payments and Collections (IPAC) bulk file to default the Description field from the header text of Purchase Orders (POs) if the Logistical Invoice (LIV) contains no long text. NIFA  
33125 Create a Spending Payroll Detail Report in the HANA Payroll Universe to capture current year data. All  
33163 Adjust Overseas Management System (OMS) interface to handle situations when Department of State (DoS) issues a credit transaction where the credit amount exceeds the disbursement recorded against the referenced Funds Commitment Number (FCN). This occurs because DoS issues a credit referencing a single FCN against expenditures that were recorded against multiple FCNs. These postings are rejected by FMMI because credit exceeds expenditure on the FCN. FAS  
33205 Modify the FMMI to Corporate Property Automated Information System (CPAIS) Outbound Interface to pick up all relevant records in FMMI that should be transmitted to CPAIS Personal Property. This will enhance the Interface code to strengthen its ability to extract the correct records. All  
33207 Enhance the Overseas Management System (OMS) Interface Reconciliation report. This report is a 3-way reconciliation between the daily file records received from the Department of State, FMMI accounting documents and a monthly treasury report file. Requested improvements are:
  • Add a second "Show discrepancies only" option to only list discrepancies between treasury report and accounting documents
  • Add ability to record notes and a checkbox indicating that a discrepancy has been investigated.
FAS  
33208 Adjust the reprocessor program for Overseas Management System (OMS) interface to allow user to make data corrections to multiple records at one time. FAS  
33212 Add Functional Area to the Master Data mass upload process. All  
33283 Update File A and File D2 DATA ACT fields with DATA Act Information Model Schema (DAIMS) 1.2 mandate changes. All  

Back to Top

FMS Financial Systems Release Results
Action Items (AI) – May 11, 2018 (Scheduled)

Change Request (AI) Description Agency Release Results
32336 Prevent the <Create Date> and <Created By> columns from being overwritten by <Updated Date> and <Updated By> in FSDW. All  
32932 Create List of Values for Standard General Ledger (SGL) Account field in the HANA Spending Detail universe. This will allow the SGL Account field in the HANA Spending Detail universe to refresh, preventing it from spinning, locking up Webi, and forcing users to shut down via Task Manager. It will also, reduce the time it takes for unique SGL values to load. All  
32959 Modify the Unliquidated Obligation (ULO) system assurance process to include a date variable to reflect the correct out of balance. All  
32973 Correct the Funded Program CP6 field in the High-performance Analytic (HANA) universes to display the correct value when CP6 is blank. All  
33002 Correct the Expenditures Field on the Status of Funds Project-to-Date Report to be displayed with the proper sign. This will prevent doubling the Expenditures amount when manually calculating the Available Authority amount. All  
33059 Update the Role ZCR00UFBFP:BI_BP_FUND_PLANS description from Office of Civil Rights (OCR): Budget Planning Fund Org Data for Reports & Planning to Assistant Secretary for Civil Rights (ASCR): Budget Planning Fund Org Data for Reports & Planning to conform with other ASCR Budget Status and Forecasting (BSF) roles. ASCR  
33104 Prevent the inclusion of commitment item 4100 on the Unbilled Amount field within the Sales Order History report. All  
33120 Remove text "No Title Provided" from the Balance Voucher Adjustment System (BVAS) & Miscellaneous Object Submission Tool (MOST) self-registration screen. FS  
33128 Modify the Dashboard Feed for Forest Service Fleet Equipment Department (FED) (formerly Equipment Management Information System (EMIS)) to capture inbound statistics that accommodate parallel processing. FS  
33161 Update the Forest Service Billings Report header information to reflect any changed amounts on the Billing request. This will ensure that the header data is updated when changes are made and when reports are run. FS  
33162 Modify PLCE program to prevent any items that were deleted prior to approval of the PLCE (Program Loan Cost Expense) PO from being shown on the PLAS (Program Loan Accounting System) back feed file. FS, RD  
33167 Modify the Employee Name Inquiry Table (NEMP) to FMMI interface to only concatenate the employee middle initial in the Vendor Name field if there is a middle initial present on the input record. If no middle initial is present, only perform the concatenation on employee first name and last name. This change will be performed on each of the following activities:
  • Vendor create
  • Vendor edit
  • Customer created
  • Customer edit
As a result, the extra space between the first and last names in the Vendor Name field will be removed.
All  
33178 Add a validation to the system that will issue an error message if the baseline date of an open vendor invoice is older than a given number of days. This validation will apply to any open unreversed invoice that references a Prompt Pay Act (PPA) relevant vendor. The validation will be invoked when the document is posted as well as if the posted document is changed. All  
33183 Modify the Sales Order (SO) mass upload program to allow only numbers, decimals and commas in the Amount field. APHIS  
33209 Improve the email notification for processing files for Overseas Management System (OMS) interface. There are two error conditions which are not properly communicated back to the end user.
  • When the FMMI OMS Application Programming Interface (API) fails to start, all records in a file will fail, but the email notification is incorrect. Exception handling for this condition must be added to the OMS business layer in Mulesoft to ensure that the correct message is returned to the file processor.
When a corrupted file is uploaded to the drop box, the Mulesoft flow fails before reaching the field validation code, and no email notification is sent. An email notification stating that the file has been rejected should be sent to the end users.
FAS  
33214 Modify the 'Save' function of the Budget Status and Forecast (BSF) Personnel Allocations layout to prevent extra records from being included in the selection/processing. All  
33270 Modify the Account Statement customized program logic summary section to reflect correct signage ('+ or ‘- ‘) for interest and penalty APHIS  
33316 Correct instances where a failed ASAP draw could result in the processed draw and the correction of a duplicate record. FNS Quality Acceptance testing was unsuccessful. Will move once all testing is complete.
33318 Change the PI file parameters to create a unique file name independent of the time stamp and update the processing option to add a Unique Message ID. This will prevent PI files from being overwritten when more than one file is created within the same second. FNS  
33321 Modify ZFII_CPAIS_UAI_INBOUND program to process file names that begin with "CPPP_TO_FMMI_UAI_CHG". All  
33396 Add new AMS sales office FGIS and assign to Sales Area AM00 to facilitate billing for GIPSA/AMS merger. GIPSA, AMS, APHIS  

Back to Top

FMS Results – Requests for Change (RFC)
April 2-30, 2018 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Production Date
33085 FMMI
Associate Commitment Item 3298 with General Ledger account 6900003298 for Document Type YF Transaction Model/Transaction Variant YF/07. This will enable agencies to post an accrual to expense non-productive cost liquidating pre-paid advance.
All 04/26/2018
32872 FMMI
Modify the System for Awards Management (SAM) Interface to use the Taxpayer Name Field and perform a data fix for those vendors already updated by the SAM to FMMI interface. This will allow the Taxpayer Consent Name to be used as the vendor name in FMMI, rather than the Legal Business name, increasing the accuracy of the TIN matches for FMMI SAM sourced vendors.
All 4/27/2018
33015 BI
Prevent the occurrence of invalid characters in the outbound Open Hubs – APHIS Cost Management System (ACMS) Business Intelligence (BI) extract.
APHIS 04/03/2018
33184 FMMI
Change the Funds Control Level on FSIS’s Fund FI0003739R Accredited Labs from the Work Breakdown Structure (WBS) level to the third character of their Funds Center. This change will allow FSIS to meet their reporting needs.
FSIS

04/21/2018

33241 FMMI
Update AVC assignments related to First Four Position of Funds Center for FS0000CMCM/BP1821 and assignments related to Functional Area FS0000FDFD/FS0199GTGT for BPs 18XX forward.
FS 04/21/2018
33380 GRANTS
Update the mitigation control roles for Food Safety & Inspection Service (FSIS) agency with a new mitigation control monitor F-ID. As a result, the agency will be able to apply their controls to a processing request with Segregation of Duties (SoD) risks.
FSIS 04/26/2018
33264

GRANTS
Resolve the issue regarding miscalculated cleared amount in the SF-425 warning in the ezFedGrants External Portal. The error message and reference of ClearedAmount field on UI is correct, but this field is miscalculated in the activity in some scenarios. This change will update the SF-425 – “ClearedAmount” field calculation to fix the error and reference the “Reimbursement Payments”.

All

Request was included in the April Grants Release

4/27/2018

Back to Top

FMS Grants Release Results
Change Requests (CR) – April 13, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (AI) Description Agency Release Results
33254 Incorporate new NIFA opportunity template on Grants.gov. (NIFA Capacity Grants Opportunity Template (2018+)) into ezFedGrants. As a result, Pega objects referencing the old template have been updated to reference the new template. NIFA  
33260 Add ability for APHIS internal users to edit all roles within the Partners section of the Agreement screen without having to create an amendment to change. As a result, APHIS is now aligned with the enterprise solution and can edit Partners on active agreements with the exception of the Grant Recipient partner. APHIS  
33286 Add capability for NIFA Opportunity Approvers to remove/delete attachments that were submitted by NIFA Opportunity Processors. NIFA Approvers are only able to delete their own attachments and cannot delete attachments from Processors due to privileges set up in the Pega NIFA Grantor application. NIFA  
33303 Modify the Special Instructions to include a Notes field on the A/R Claim line item to provide a reason for upward or downward adjustment of claim amounts. FNS  

Back to Top

FMS Grants Release Results
Action Items (AI) – April 13, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (AI) Description Agency Release Results
33080 Update list of users with “Updated” value in their Pega profile ContactID to match the Partner ID sent from CRM. As a result, affected users will no longer have issues accessing reports that are assigned to them by their GAO. All  
33203 Remove duplicate records from all work tables and add constraints to prevent duplicate records from generating in the future. As a result, only one record is displayed for each opportunity, claim, report, repayment, access request, and eSig transaction. All  
33236 Update the Contact USDA page label in the ezFedGrants External Portal from Grantor Helpdesk to ezFedGrants Helpdesk. Update agency name for NIFA in the Agency field dropdown and add Agency field instructions into the dropdown bar to resolve alignment and user interface (UI) issues. All  
33304 Prevent amendments saved in "draft" from appearing on future amendments. FNS  
33305 Create additional validations when releasing a GAD header and GAD line items to prevent blanks sent to ASAP in relevant fields. FNS  

Back to Top

FMS DATA Act Release Results
Change Requests (CR) – April 13, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (AI) Description Agency Release Results
33302 Add new Federal Shared Service Provider (FSSP) clients (Nuclear Waste Technical Review Board (NW00) and Vietnam Education Fund (VE00)) and merge current FSSP clients (US Institute for Environmental Conflict Resolution (RE00) and (Morris K Udall Scholarship Foundation (UD00)) into UD00. All  
33357 Update the ECC/BW Portal Welcome page to HANA Reporting and BPMS Models users to from receiving erroneous account lockouts. All Emergency CR successfully implemented with the regularly scheduled release.

Back to Top

FMS DATA Act Release Results
Action Items (AI) – April 13, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (AI) Description Agency Release Results
33173 Add the PIID and FAIN Award IDs to the HANA Spending Detail Report to make it available for adhoc reporting purposes. All  
33291 Correct the misspelling of column H (Sub Account Code) and J (Adjustments To Unobligated Balance Brought Forward_CPE) in the DATA ACT File A Certification Report. All  
33325 Remove zero dollar records from the ARS splitter job that are erroneously passed to the Data Act Repository. All  

Back to Top

FMS CPAIS Personal Property v. 1.7 Release Results
Action Items (AI) – April 6, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (AI) Description Agency Release Results
32155 Update the Budget Object Code (BOC) table and drop-down list to contain all BOCs. Also display the Min Max Amount and Effective Dates. All  
33127 Prevent the Variable Depreciation field from being populated with the Budget Object Class Useful Life on the Staging and Property forms. As a result, the field will be blank. All  
33130 Ensure a Budget Object Code (BOC) on Non-Tradition Assets with Conversion as the acquisition status can be modified. All  
33324 Update the FMMI to CPAIS loading routine to properly handle the processing of $0 records. All  

Back to Top

Requests for Change (RFC) March 3 - 31, 2018 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Production Date
32708 CPAIS – Personal Property
Modify FMMI – Add Accounting Element “Long Functional Area” to be part of the Inclusion or Exclusion criteria on the ZCPAIS_PARAM table.
All 03/13/2018
32086 GRC
Update the GRC MSMP workflow to prevent GRC requests from having risks without mitigation control.
All 03/23/2018
32826 EzFedGrants
Display the "ASAP Recipient ID" in the Pega organization search result.
NIFA 3/23/2018
CR was included in the February Grants Release.
32778 PEGA
Allow PEGA the capability to have applications and supportive documentation stitched together in the PDF format for exporting purposes.
NIFA 3/23/2018
CR was included in the February Grants Release.
30279 FMMI
Allow account numbers on detail screen of the Point of Sale System (POSS) Re-processor to be modifiable.
FS 3/23/2018
CR was included in the February Grants Release.

Back to Top

Action Items (AI) March 3 - 31, 2018 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Production Date
33187 FMMI
Change the Email Address and Name 2 field on the AMS sales office FV10.
AMS 03/13/2018
33309 FMMI
Change Sales Office FVF1 and FVF2 with the following customer service information:
Phone Number: 866-308-3240
Email: SCIServiceCenter@ams.usda.gov
AMS 03/13/2018
33310 FMMI
Update the mitigation control role for the Food and Nutrition Service (FNS) agency with a new Mitigation Control Monitor F-ID. As a result, FNS will be able to apply their controls to a processing request with Segregation of Duties (SoD) risks.
FNS 3/23/2018
32431 FMMI
Populate Treasury Checks with Street 5 from the FMMI Master Table Address.
All 3/23/2018
CR was included in the February FMMI Release.
33319 FMMI
Allow the Commitment String field (FMUSFGA-FMCMMTSTR_9) to populate on all FMRES (Funds Commitment Documents) in ECC. As a result, downstream BI/HANA reports will be accurate.
All 3/23/2018
33384 FMMI
Update the processing of Write Off transactions by removing the extra negative sign at the end of the amount field. As a result, the DAILY_FS_TSRM_OUTBOUND production job will not fail and the FMMI.FS.NRM.TSRM.OUTBOUND.D20180319* output file will be created.
FS 03/27/2018
33385 FMMI
Modify the processing of Write Off transactions to remove the extra negative sign at the end of the amount field. As a result, GL account 1410008999 will be placed back on the V_T8G17 table to classify GL accounts for document splitting and the range will be updated to include the GL account to process PACS IDocs.
All 03/28/2018

Back to Top

Requests for Change (RFC) February 5 - March 2, 2018 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Production Date
31553 FMMI
Modify the Sales Order Overhead Program (ZFI_OH_COST_ALLOC) to resolve issues that Forest Service (FS) and Working Capital Fund (WCF) are having with posting overhead.
All 02/16/2018
33218 FMMI
Update the ACRWS program in FMMI to eliminate all special characters from text fields before generating the file to send to ACRWS.
All 02/23/2018
33124 Grants
Modify the Grant Award Document (GAD)/Letter of Credit (LOC) Spreadsheet to update the future month "Current Amount" fields to include draft amounts and validate simultaneous submissions of GAD & LOC amendments where one is dependent on the approval of the other.
FNS 02/27/2018

CR was included in the January Release.
33160 Grants
Allow the GAD/LOC Spreadsheet to display a warning message when sum of previously approved amendments do not match the Item Total Disbursement (ITD) amount.
FNS 02/27/2018
31610 FMMI
Modify the Management Accounting Structure Codes System (MASC) payroll interface to remove logic check to post regardless of Shorthand Code (SHC) status for the following document types (AC, AR, and DO for Administrative Billings and Collections (ABCO)) (CA for CAPS) and (ZA, ZF and ZP for Payroll Accounting System (PACS)). This will prevent deactivated SHC from being used within the Payroll process, causing the entire Payroll document and accruals to reject. It will also improve performance time of the processor working the rejects after each payroll and accrual run and ensure the payroll activity is posted as quickly as possible.
All 03/02/2018

CR was included in the February Release.
32686 FMMI
Provide the ability to deactivate and reactivate short hand codes via Mass Upload. Note: Updated SHC Mass Upload Template is available in FMMI Help.
All 03/02/2018

CR was included in the February Release.

Back to Top

FMS CPAIS Personal Property v. 1.6 Release Results
Action Items (AI) – February 23, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (AI) Description Agency Production Date
33246 FMMI
Implement a file filter that will check the lock status of a file before it picked up by the file Ingestion process. The lock status of the file will indicate if the file is being written to by another process. This will help prevent the application from picking up files that are still in the process of being transferred, resulting in files failing.
All 02/05/2018
32440 FMMI
Allow the Document Type Description and the Commitment Item Description to be available on the HANA-Federal Transaction Register[unx] version. Also, change the name of the document type column from "DT" to “Document Type". This will allow users to input the column "DT" as the key when doing a search on Document.
All 02/15/2018

CR was included in the February Release.

Back to Top

FMS CPAIS Personal Property v. 1.6 Release Results
Action Items (AI) – February 23, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Production Date
32030 Add a new table to the Oracle Database to ensure that the Inspection and Operational data are maintained in separate tables. Also, modify the Inspection and Operational data tabs on the Property form so the odometer readings can be managed correctly and separately between the Operational and Inspection Data. All
32324 Update the APO_ID_RG LOV in the Property module to display the First Name before the Last Name. Also, update the database table “ACCOUNTABLE _PROPERTY_OFCRS” to correct the first/last name fields that are reversed. All
32393 Prevent the Property form from forfeiting an Asset ID if a user begins a Property record and does not save it. This will allow unsaved property record IDs to be available for the next successfully saved record. All
32536 Allow data displayed in the acquisition amount field to be displayed in the Original Acquisition Amount field when a Traditional asset is disposed. This will prevent the acquisition amount from changing to $0 after an asset is disposed. All
32983 Combine all Receipt records into one Receipt record for all Staging records. Also, modify the nightly CPAIS load process to update the single existing receipt record (do not create additional Receipt records). This will allow Property Managers to create Assets from the Staging Area Records that have multiple receipt records. All

Back to Top

FMS CPAIS Personal Property v. 1.6 Release Results
Requests for Change (RFC) – February 23, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Production Date
32936 Allow users the ability to query data on the Property form. All fields needed to perform a query were not available. Update will add the query to the Acquisition Amount field on the Property form to allow users the ability to query by the dollar amount. Users will also be able to run a report by range. All
32937 Correct the Accept button actions when transferring assets within the same agency. Currently users are forced to do accounting adjustments when transferring within the agency. They agency will be able to change the accounting at any time. All
32976 Add an ‘Orig Acq Cost’ field to the Property Form which will allow Property Managers the ability to manually enter cost/value data for non-traditional assets (assets not purchased).   This new field will fulfill the property management needs and allow the accounting requirements for purchased assets to be unchanged.  All
32982 Modify the Property form to not require the accounting code. This will allow Property Managers to complete non-traditional assets which do not have acquisition cost and do not require accounting codes. All

Back to Top

FMS Financial Systems Release Results
Action Items (AI) – February 9, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (AI) Description Agency Production Date
32112 Modify the Integrated Acquisition System (IAS) back feed interface to send cancelled transaction status to IAS. This will allow IAS to receive the accurate status of the payments and reversals after the daily Treasury Confirmation job. All
32328 Correct Personally Identifiable Information (PII) data appearing in Financial Management Modernization Initiative (FMMI) system All
32343 Restrict general access to GS02-sets/tables in the Governance Risk and Compliance (GRC) system. Also, create a separate role with GS02 and assign it to a permanent Log Access Authority (LAA) ID which will be assigned to the Security team. All
32431 Populate Treasury Checks with Street 5 from the FMMI Master Table Address. All Did not receive User Acceptance Testing signoff. Will move to production when testing is complete.
32440 Add the Document Type Description and the Commitment Item Description fields to the High-Performance Analytic Appliance (HANA) Federal Transaction Register (FTR). All
32860 Allow the HANA View to pull “POSID” from the PRPS table instead of the “PSPNR” field. This will allow the WBS Element in the HANA Transaction Register to pull correct information. All
32864 Remove the FNS Business Process (B)P Contacts Universe data limit FNS
32875 Update the Financial (FI) Mass Upload Program to enable processing of miscellaneous cash postings using Work Breakdown Structure (WBS)s without re-rendering the background input screens during “Page downs” causing Business Partner (BP) fields to become blank and returning “Blank budget period is not allowed in FM area USDA” errors for MRP, NRCS and FS. All
32908 Fix Overstated 2018 Pay Period 20 Projections in the Budget Status and Forecast (BSF) application. This change will only return Pay Period 20 once (in this case, 2017) allowing the correct Cost of Living Adjustment (COLA) rate to be applied. All
32916 Align Budget Status and Forecast (BSF) Employee Action Panel skewed rows to make it easier to identify specific employees. All
32917 Correct the Budget Status and Forecast (BSF) Planning Function to not display Allocation Percentage > 100% error when the Panel shows 100% allocation. This will allow planners to input Year-to-go allocation percentage by individual employees as well as Pay period “BSF Personnel Allocation panel”. All
32933 Change the Date fields to 'Date' data type in the 3 High-Performance Analytic Appliance (HANA) Universes (HANA Spending Detail Universe, HANA Sales Order History universe, and HANA Status of Funds universe. All
32984 Fix Duty Station State Code field in the Position Management System Online Data Store Object (PMSO DSO) for the FMMI Budget Status and Forecast (BSF) application for state codes that are less than or equal to 99. All
33005 Update program ZMM_BP_GLOBAL_REP to change the extract for the FS Billing system to pick up the correct status from the custom table ZXX_FMMI_BSTATUS.  This will ensure an additional incorrect status is not being picked up and displayed in the output. FS
33023 Modify the Miscellaneous Income System (MINC) extract to loop through all payment documents which are applicable to the invoice and include them in the 1099 extract table. All Did not receive QA signoff. Will move to production when testing is complete.
33041 Change the way the System for Awards Management (SAM) Interface assigns the Vendor Account Group to foreign vendors. This will prevent foreign vendor records from incorrectly being registered as non-foreign and failing in the SAM interface due to missing/invalid region. All
33042 Change logic used to determine Payment Method Supplement for OMS disbursements. This will prevent incorrect PMS from causing cash reconciliation issues. FAS
33049 Ensure the Posting Period is open for posting in Class ZCL_IM_GLT0_AFTERSPLIT_VAL to prevent agencies from posting to Cash account 1010980000 in period 13. All
33055 Update Funds Commitment Documents to include a new field for entering a special period for posting period 13. This is needed as part of the A-11 Compliance tasks. All
33111 Exclude documents from the Business Objects (BOBJ) Open Advance report with no outstanding balance.  This will allow the agencies to run the report without seeing funds commitments with no unliquidated balance. All
33128 Modify the dashboard feed for Forest Service Fleet Equipment Department (FED) (formerly Equipment Management Information System (EMIS) to capture inbound statistics that accommodate parallel processing. FS Did not receive QA signoff. Will move to production when testing is complete.
32841 Modify Role descriptions ZAM00DIISR:ES_INTRFC_SUM_REP to read AMS instead of NRCS. This change will enable the Governance Risk and Compliance (GRC) requestor to pick the correct role while creating the GRC request. AMS
32848 Prevent the Health and Human Services (HHS) interface program from appending “DHHS” to the beginning of the agreement number in the invoice and credit memo document reference field. FSIS
32975 Update the short description of the “ZQP46DGREG:CR_FNS_REGION6_SWRO” role to read “FNS-PROGRAM SWRO: Org Structure Indicator”, instead of “FNS-PROGRAM SERO: Org Structure Indicator”. This change will enable the Governance Risk and Compliance (GRC) requestor to pick the correct role while creating the GRC request. FNS
33000 Update the multi-threaded processing model in Mulesoft for processing Overseas Maintenance System (OMS) files for the same obligation, within the same thread, to prevent transactions from failing due to another transaction having a lock on the Fund Center (FC) document.  This will prevent OMS duplicate postings. FAS
33033 Allow users to select “Application of Funds” from the list of values in the HANA Spending Detail Universe. Department Wide
33050 Populate the debit credit code with '1' for non-taxable amounts greater than zero.  This will correct vouchers with only non-taxable amount vouchers from being recorded as credits in ECC thus causing negative amounts on W2's for employees. Department Wide
33095 Send reject records from FMMI when the Centrally Billed Account (CBA) Number is blank on third party payments to US Bank. Also, populate the Treasury Vendor Code on Earmarked Funds Commitment lines for the agency portion of FICA and HITS. Department Wide
32926 Summarize the detailed payroll transaction data within the AHIS Cost Management System (ACMS). APHIS

Back to Top

FMS Financial Systems Release Results
Requests for Change (RFC) – February 9, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Production Date
30589 Apply the initial date and timestamp status to the Pre-Approved Vendor (PVND) Request Record when the request is saved/submitted. All
32575 Update the APHIS Cost Management System (ACMS) spending extract to include GL4700 and doc type "GR" in order to capture the EzFedGrants Funds Pre-commitment. APHIS
32686 Provide the ability to deactivate and reactivate short hand codes via Mass Upload. All Did not receive QA signoff. Will move to production when testing is complete.
32872 Modify the System for Awards Management (SAM) Interface to use the Taxpayer Name Field and perform a data fix for those vendors already updated by the SAM to FMMI interface. This will allow the Taxpayer Consent Name to be used as the vendor name in FMMI, rather than the Legal Business name, increasing the accuracy of the TIN matches for FMMI SAM sourced vendors. All Requirements need to be revisited due to IRS compliance. Future release to be determined.
32900 Limit user access to the master data and sub-folders in the Enterprise Resource Planning Central Component (ECC) system on the BOBJ Ad-Hoc Reports. Also, restrict user access to certain folders to prevent the modification of agency level reports. RD
32958 Update Overseas Maintenance System (OMS)Interface to liquidate only the amount of the advance that is being processed against the down-payment.

FAS  
33010 Modify the Centrally Billed Account (CBA) third party invoices payment file which are paid directly to vendor (US Bank-1100929885, document type 4P) to include the Travel Authorization Number (TANUM) and SEQUENCE NUMBER in Record 22 of the payment request file. This modification will allow the TANUM-SEQUENCE number to automatically map to US Bank's bank statement. All  
33061 Add Tcode RSUSR003 to Business Intelligence (BI) role. This will allow the security team to check the status of standard SAP accounts across the landscape, and produce reports against those ids for audit purposes. FMS  
33087 Modify logic in the OMS Re-processor report ZFI_OMS_REPROCESS to allow the Note field to be edited directly in the ALV (ABAP List Viewer) list without having to execute a function like Manual Complete or Reject. FAS  

Back to Top

FMS Results - Requests for Change (RFC)
Grants - February 9, 2018 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Production Date
33124 Modify the Grant Award Document (GAD)/Letter of Credit (LOC) Spreadsheet to update the future month “Current Amount” fields to include draft amounts and validate simultaneous submissions of GAD & LOC amendments where one is dependent on the approval of the other. FNS
33141 Part 1 of the NIFA Mini Project. Updates will include provisioning and the creation of text objects to replace static objects on the Nature of Award. Part 2 is expected for the April Grants Release. All

Back to Top

FMS Results - Action Items (AI)
Grants - February 9, 2018 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Production Date
33159 Ensure the Funds Commitment is automatically created when the first amendment of a new GAD is approved, specifically for GADS without LOCs. FNS

Back to Top

FMS DATA Act Release Results
Requests for Change (RFC) – January 25, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
33028 Create a new Webi report to provide visibility for D2 file activity. This will serve as a source for tracking D2 files through the Business Warehouse (BW) system as well as provide a status in real time showing the process stages of all D2 inbound files. All  
33090 Update File C with Smart Pay processing (Fleet Expense Transactions) for FI Vendor Invoices. Also, include those invoices with amounts greater than or equal to $2,500 as the first reportable event in File C, report as Transactions Obligated Amount (TOA), and generate various General Ledger account balance by Award ID. Those invoices with an amount less than $2, 500 will be excluded from File C processing. All  
33091 Update File C processing to include Real Estate expenses paid on behalf of an employee as reportable, when the specified requirements are met. All  
33092 Report Fiscal Year Beginning Balance for certain Standard General Ledger (SGL) accounts (e.g. 487x, 488x, 497x, 498x, etc.) as $0 in File B and C. Balances in these SGL accounts are transferred to 4801 or 4901 as part of the year end close program. As a result, balances in these SGL accounts at Program Activity and Budget Object Code (BOC) levels need to be reported under corresponding General Ledger (GL) account in which those SGL accounts are closed. All Request did not receive User Acceptance Testing (UAT) Signoff. CR will be migrated to production once UAT signoff has been obtained.
33093 Modify the A-C Inbound Error Report to provide an indicator that notifies a user if a record contains an error with "Y" and identify warnings with a "W". This will allow the users to know the difference between Treasury warnings and critical failures. All  
33171 Update File C Error log tracking and reprocessing (referred as delta process capability) on an ongoing basis during quarter end processing. Also, allow for delta processing so errors that are to be updated/fixed can be done without processing the entire file. All  

Back to Top

FMS DATA Act Release Results
Action Items (AI) – January 25, 2018 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
33144 Eliminate obligations and follow-on activity documents related to the funds commitment document with Travel document types (XO). This will ignore FC documents with document type XO and all of the associated follow-on documents, preventing users from seeing errors that cannot be resolved due to those fields not being available for document type XO. All  
33156 Derive the business area based on the 4th & 5th characters of the Program ID Number. This change will prevent Customer Relationship Manager (CRM) records that are interfaced into Business Warehouse (BW) from missing the business area which causes D2 processing issues such as missing documents in the final file to Treasury. All  
33157 Disable “Legal Entity Zip Last4” validation rule in the Business Warehouse (BW). Treasury has changed this to a soft error therefore allowing records without the final 4 digits of the zip code to pass. All  

Back to Top

FMS Grants (includes PEGA) Release Results
Requests for Change (RFC) – December 15, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
33068 Add a link to the External PEGA Portal page called "Training/Guidance" that will take the user to the page: www.nfc.usda.gov/ezFedGrants when clicked. ezFedGrants  
33124 Modify the Grant Award Document (GAD)/Letter of Credit (LOC) Spreadsheet to update the future month “Current Amount” fields to include draft amounts, and validate simultaneous submissions of GAD & LOC amendments where one is dependent on the approval of the other. FNS Testing was impacted by QA Refresh. CR will be included with the February Production update.

Back to Top

FMS Grants (includes PEGA) Release Results
Requests for Change (RFC) – December 15, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
32517

Add agency dropdown to EzFedGrants Helpdesk Form in the external portal. All Agencies  
32904 Remove duplicate applications and add constraints to the affected tables (NIFA and APHIS application tables as well as their related tables if needed). NIFA, APHIS  
32953 Remove child entries without the associated parent record in the partner address table (BUT020) to prevent the error message from displaying when processing files from Systems, Applications, Products in Data Processing (SAP) and Customer Relationship Manager (CRM). NIFA  
32979 Update the nightly job that sends Enterprise Resource Planning Central Component (ECC) clearing documents to Customer Relationship Manager (CRM) for ezFedGrants documents to not store erroneous table entries in the Trigger Table for Grantor Notification to CRM. All Agencies Testing was impacted by QA Refresh. CR will be included with the February Production update.
32981 Update the Sales Order Creation Interface to populate the Period of Performance Start and End Dates on the Sales Order Header in Enterprise Resource Planning Central Component (ECC). NRCS  
32996 Create a new property in the application data tables to be used specifically for querying the “Descriptive Title of Applicant’s Project” field. Searches will be limited to the first two hundred characters of the field value to allow for optimal performance while executing searches. All Agencies  
33040 Update the calculation for the Total Agreement Amount in the Agreement Overview to display the correct amount regardless of the order by which a user enters the financial amounts for an agreement. This update will correct the Total Agreement Amount calculation to display the full amount of the agreement regardless of how the agreement information is entered. All Agencies  
33045 Update the Application Workflow to ensure the status is updated to "Withdrawn" and the flow is cancelled after the Signatory Official choses to withdraw In Pending Signature status. All Agencies  
33048 Update methods ZCL_ES_CLWR_SEARCHRESULT2_IMPL=>EH_ONFORMCLICKED and ZCL_ES_GCL_UTIL=>VALIDATE_BEFORE_CREATE to read valid Claim related data. ness Server Page) error when creating a Claim for Agreement 6000525. FAS/td>  
33057 Update the Closeout Notifications for APHIS, NRCS, and NIFA to correct grammatical errors in the body of the emails. APHIS, NRCS, NIFA  
33063 Allow for the population of the authority table to occur, even when the Agreement automatically fills its instrument type after program selection. All Agencies  
33081 Update the Reassign Report work item functionality in PEGA to not include Signatory Officials (SO)s as an option to reassign to. All Agencies  
33082 Prevent the email templates for reports, claims, and repayments from adding agency partners that does not exist to the work party, preventing an item from being stuck in workflow due to a Party ID error. All Agencies Testing was impacted by QA Refresh. CR will be included with the February Production update.
33083 Hide the “Skills” section in PEGA when users request access. Once the user has been assigned a role, the “Skills” section would be visible in their account, allowing the user to use their PEGA account. All Agencies  
33108 Correct the erroneous ASAP Batch Number that is being assigned to the disbursements/invoice reference field. NIFA

Testing was impacted by QA Refresh. CR will be included with the February Production update.
33135 Update the FAS Cooperative Agreement, FAS Joint Venture, and FAS Cost Reimbursable ezFedGrants Award Forms to correct the total amounts on the cover sheet. FAS

 
33136 Add a validation to the Property Reporting Schedule when generating Final Reports to prevent erroneously setting the schedule value to "None". All Agencies

Moved to Production on 01/12/2018
33137 Update the FAS Award Form to correctly retrieve the Recipient Signatory Official’s last name and display it on the form in a manner that does not truncate the value.

FAS

 
33159 Ensure the Funds Commitment is automatically created with the first amendment of a new GAD is approved, specifically for GADS without LOCs.

FNS

Testing was impacted by QA Refresh. CR will be included with the February Production update.

Back to Top

Requests for Change (RFC) December 1-31, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
33067 FMMI
Support the Grants Oversight and New Efficiency (GONE) Act in Customer Relationship Manager (CRM) by completing the following:

  • Add Completed status to FNS Grant Award Document (GAD) User Status field.
  • Enhance Mass Closeout Tool to allow user to set or reverse Completed status.
FNS 12/12/2017
33110

FMMI
Aggregate the data in the Open hub process to only allow one record to generate for the key when two files are processed for an agency on the same day containing the original FAIN and correction to the FAIN.

All Agencies 12/5/2017
33188 FMMI
Modify the ATF Account Statement and the Activity Report customized program logic to take into account both Commitment Items (9800 & 9402) in the overhead calculations.
APHIS 12/5/2017
33139 FMMI
Exclude specific GTAS fields from existing lines during the amendment process to prevent FMMI from changing these fields. As a result, the amendment can be processed normally regardless of whether or not the GTAS information was included when the authorization was created.
All Agencies 12/5/2017
31904 FMMI
Change the address of US Bank Lockbox 979099 from ‘USDA, NFC - FMMI COD Collections‘ to ‘USDA OCFO Financial Management Collections‘.
All Agencies 12/19/2017

FMS Results – Requests for Change (RFC) November 1-30, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
33060 FMMI
Implement OSS Note 99775 via FBV4 to allow users to do a mass upload change of the posting date, period, or fiscal year on parked and FI documents. This will allow documents to post when the budget period is not open.
All 11/3/2017
31427 ACRWS
Replace the current Automated Cash Reconciliation Worksheet System (ACRWS) with ACRWS Redesign system. The redesign ACRWS system will import daily General Ledger (G/L) and Treasury data to determine if a Statement of Difference (SOD) exists by Agency Location Code (ALC) and by Accomplish Month/Year.  The ACRWS reconciliation tool will provide an automated and manual process to import input files. 
All 11/14/2017
31827 FMMI
Allow new data extracts to the Food and Nutrition Service (FNS) drop box on a daily basis in the pipe delimited format to enable automated reconciliation for the Automated Standard Application for Payments (ASAP) Disbursements.
FNS 11/17/2017
32389 FMMI
Resolve issues with the ECC Reimbursable Orders Report (ROR). This change will lump all activity on an unblocked order line but keep the blocked order line on the report and display the order value for that line.
All 11/29/2017
33112 FMMI
Modify the Forest Service (FS) custom allocation program (ZFME_ALLOCATION_POST) to attain the correct Budget Period to be used on the sender accounting string when posting the allocation documents.
FS 11/29/2017

FMS Release Results – Action Items (AI) November 1-30, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted.

Change Request (RFC) Description Agency Release Results
33027 EZFedGrants
Allow the Budget Party Contribution (BPC) section on the Amendment screen to be in sync with the values from the Detailed Budget List. This will prevent users from processing overdue claim due to incorrect amounts displayed/stored on the BPC section of the agreement/amendment.
APHIS 11/3/2017
32988 Grants
Update Web User Interface (WebUI) validations to enforce all FNS custom validations on the “Do you want to save your changes?” pop up. Also, allow the de-obligation of a Grant Award Document (GAD) line item when a separate GAD line item is for a cancelled fund.
FNS
Previously included in the October Release
11/3/2017
32986 FMMI
Update code logic to send BDOC (Business Document) to Enterprise Resource Planning Central Component (ECC) when multiple auto-amendments are triggered on the same GAD (Grant Award Document) or GLR (GAD/LOC Relationship) simultaneously.
FNS 11/3/2017
33062 BSF
Remove ABAP programs from Planning Sequence in the Process Chain. This will allow production BSF chains to complete successfully.
All 11/3/2017
33033 HANA
Allow users to select “Application of Funds” from the list of values in the HANA Spending Detail Universe.
All 11/9/2017
33050 FMMI
Populate the debit credit code with '1' for non-taxable amounts greater than zero. This will correct vouchers with only non-taxable amount vouchers from being recorded as credits in ECC thus causing negative amounts on W2's for employees.
All 11/9/2017
33095 FMMI
Send reject records from FMMI when the Centrally Billed Account (CBA) Number is blank on third party payments to US Bank. Also, populate the Treasury Vendor Code on Earmarked Funds Commitment lines for the agency portion of FICA and HITS.
All 11/9/2017
32926 Summarize the detailed payroll transaction data within the APHIS Cost Management System (ACMS). APHIS 11/9/2017
33122 mLINQ
Update the mLINQ Outbound program with the following:
  1. Allow the Outbound program to abend if the T3330 Cluster is in the inbound directory.
  2. Allow the Outbound process Daily Tax Report to have the total at the bottom of the report.
  3. Modify GLID file to use the run date instead of the process date in the outbound file.
Additionally, the EARN monthly will populate the Beginning Date of Travel field for the Outbound process with the schedule date.
All 11/14/2017
33133 FMMI
Update FSDW program to use optimization techniques when determining memory size and the number of records that can be retrieved when selecting from FMUSFGT. This will prevent the program ZFIO_FSDW that runs for beginning balance from failing with run time memory errors.
All 11/17/2017
33065 FMMI
Delete the FMABPDERIVE rule 78 for de-obligation of VW, unexpired, and prior year Funds Commitments.
FNS 11/29/2017

FMS Grants (includes PEGA) Release Results - Requests for Change (RFC) – November 9, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
32763 Add Obligated Amount and Disbursed Amount to the Automatic Standard Application for Payment (ASAP) Overview Section on the Agreement screen.
NIFA  
32778 Implement PDF Stitching to support applications received via Grants.gov and the creation of PDF packages. The stitched PDF will generate after receipt of the application from Grants.gov and will be automatically attached to the PEGA application. When that application is approved to create an agreement, the stitched PDF will transfer to Customer Relationship Manager (CRM) as an attachment to the agreement. NIFA Implementation has been delayed. Will be implemented once development and testing is completed.
32826 Display the "ASAP Recipient ID" in the Pega organization search result. NIFA Implementation has been delayed. Will be implemented once development and testing is completed.

FMS Financial Systems Release Results - Requests for Change (RFC) - November 9, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
32295 Update the Master Record with the following:
1. Add a comment field to the first screen of the customer master record (T-code XDO2) and link it to the audit trail.
2. Add the Pre-approved Vendor (PVND) request number (vendor or customer) to the Master Record to allow it to populate on the comments field and link to the audit trail.
This will all VCM to quickly look up a PVND request number for research and have history of any changes made to the vendor or customer master repord.

Department Wide  
32389 Resolve issues with the ECC Reimbursable Orders Report (ROR). This change will lump all activity on an unblocked order line but keep the blocked order line on the report and display the order value for that line. Department Wide Did not receive agency signoff. Will migrate once approved.
32647 Create USDA standard roles that are comparable to SAP specific roles to provide developers access to the BSF+ tool. FMS  
32663 Perform modifications to Budget Status and Forecastings (BSF) to increase the dropdown box for filtering data in the planning layout to show up to 5,000 records. Department Wide  
32678 Add standard “Save Template” and “Load Template” buttons to the Web Application Designer (WAD) for the Budget Status and Forecasting (BSF) Adjustment Detail Report (ZWBF_ZMBF_OP01_W2). This change will also add a dialog box pop-up when users click these buttons to warn them that comments may/will be lost with changes to the layout. Department Wide  
32686 Implement changes that will allow Agencies to change the status of their Shorthand Codes (SHC) en masse for up to 23,000 records at one time. Department Wide Will be implemented in a future release.
32754 Modify employee Within-Grade Increase (WGI) rate in Budget Status and Forecasting (BSF) to take effect in the same pay period (PP), instead of the following PP. Department Wide  
32782 Update the backfeed process to load all Sales Organization GP00 Customers into the GIPSA Internal Billing System GIPSA  

FMS Financial Systems Release Results Action Items (AI) – November 9, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
31013 Create new configuration for United States Standard General Ledger (USSGL) account '199500' in accordance with the Federal Financial Accounting Technical Release (FFATR) - transaction Codes 'C613' and 'C615'. This will clarify the difference between permanent and temporary removal of General Property, Plant, and Equipment (GPP&E) from service.
Department Wide  
31344 Enable the ZPVND program to include Financial Management Service (FMS) Comment Text Lines 1-5 on emails for all request record status values (REJECTED, ON HOLD status, NEW, APPROVED, RESUBMIT and REVIEW).
Department Wide  
31348 Modify Natural Resource Manager Grants and Agreements (NRMGA) outbound interface program to correctly select Interagency Agreement (INTR) transactions. This change will update the logic to send one transaction record for every invoice on the disbursement document with an NRMGA-related Purchase Order or Funds Commitment. FS  
31403 Modify the Automated Trust Fund (ATF) Account Statement program to have the ability to process multiple Sales Orders without causing duplicates. APHIS  
31734 Update the Miscellaneous Income (MINC) extract program (ZAPX_MINC_EXTRACT) to correct the determination of penalty interest. With this change, the extract will determine the correct Commitment Item on the Penalty Interest line by reading the General Ledger (GL) account which is configured for penalty interest postings. The Commitment Item configured on that account item will be used to determine the penalty interest line on the TI document.
Department Wide  
31810 Modify hard edit for Pre-Approved Vendor (PVND) Create requests to prevent it from affecting PVND Change requests. When performing a PVND Change Vendor, this change will not perform the duplicate checking logic to place a hard edit when there are other vendors with matching TaxID, ACCT TYPE, INDUSTRY, and BANK ACCT#. Department Wide  
31918 Create a system Batch ID for the Interagency Agreement (INTR) payment run, automate the run, and add the INTR Batch ID to the Availability Control (AVC) bypass derivation. This will prevent the LIV invoices that are created by the INTR process for Accounts Receivable (AR) documents from rejecting with AVC errors. Department Wide  
32110 Modify code to post invoices with correct amounts to prevent Rule Based Account Assignment (RBAA) rounding issues that caused the Natural Resource Manager Grants and Agreements (NRMGA) application and FMMI to be out of sync.
OSEC  
32113 Modify the invoice posting logic for the Electronic Travel System 2 (ETS2) inbound interface to round the Rule Based Account Assignment (RBAA) split lines to the same amounts as advance line amounts, to avoid any clearing issues. Department Wide  
32410 Update the Marketing and Regulatory Programs (MRP) Customer Account Statement program (ZRFKORD11_MRP) such that transactions with $0.00 balances do not show in the file sent to Broadband Collection and Analysis System (BCAS). MRP Agencies  
32561 Modify the Purchase Order Mass Upload to return the WBS from the Purchance Requisition (PR) that is referenced.
Department Wide  
32586 Implement a change to allow requests that have been submitted for review in Miscellaneous Object Submission Tool (MOST) to appear in any of the Reviewer’s User Work List (UWL) in addition to being visible in the global report. FS  
32628 Redesign the PC1 Agency User Information System SUIM Reporter Roles to restrict access only to their specific Agency users. This will prevent Agencies from viewing other Agency users' information. FMS  
32655 Enable updates to Reimbursable Order No Advance (RONA) Sales Orders by adding Systems, Applications, Products in Data Processing (SAP) Note 2218853 to production. This will prevent the display of ‘(FMFG621) Cannot Change Trading Partner Fields’ error message when users try to update the Sales Orders.
Department Wide  
32666 Modify the Budget Status and Forecasting (BSF) application to perform Out Year Within-Grade-Increase (WGI) forecasting.
Department Wide  
32705 Update the description for the "ZWC00DXFLD:BOBJ_ACCESS" role to read “WCF: Access to BOBJ for WCF Agency ONLY". This change will enable the Governance Risk and Compliance (GRC) requestor to identify the correct role to be picked during the GRC request process. WCF  
32721 Modify Personnel Reconciliation in Budget Status and Forecasting (BSF) to identify employees who have terminated employment, retired, or passed away.
Department Wide  
32730 Configure dynamic benefit percentage for vacancies in the Budget Status and Forecasting (BSF) application to allow for accurate vacancy dollar projections. Department Wide  
32757 Allow only single value for HR Org value in the Budget Status and Forecasting (BSF) Employee Action Panel and display an error message if pattern is used for selection. This change will modify all "input" layouts where HR Org is used as an input variable. Department Wide  
32820 Remove the validation on Health and Human Services (HHS) document number for Food Safety and Inspection Service (FSIS). This will ensure the document does not reject for document number unless the document number on the file does not match what is populated in the Funds Commitment Document Header Text field.
FSIS  
32821 Update the Marketing and Regulatory Programs (MRP) Customer Account Statement program (ZRFKORD11_MRP) to perform a sort of the charges and the receipts by customer reference number, document number, and document line before printing.
MRP Agencies  
32831 Remove Billing Document Transfers (RV document type) doc condition from Step ZCA4 Budgetary Ledger (BL) area.
Department Wide  
32841 Modify Role descriptions ZAM00DIISR:ES_INTRFC_SUM_REP to read AMS instead of NRCS. This change will enable the Governance Risk and Compliance (GRC) requestor to pick the correct role while creating the GRC request.
AMS  
32848 Prevent the Health and Human Services (HHS) interface program from appending “DHHS” to the beginning of the agreement number in the invoice and credit memo document reference field
FSIS  
32975 Update the short description of the “ZQP46DGREG:CR_FNS_REGION6_SWRO” role to read “FNS-PROGRAM SWRO: Org Structure Indicator”, instead of “FNS-PROGRAM SERO: Org Structure Indicator”. This change will enable the Governance Risk and Compliance (GRC) requestor to pick the correct role while creating the GRC request.
FNS  
33000 Update the multi-threaded processing model in Mulesoft for processing Overseas Maintenance System (OMS) files for the same obligation, within the same thread, to prevent transactions from failing due to another transaction having a lock on the Fund Center (FC) document. This will prevent OMS duplicate postings.
FAS  
33033 Allow users to select “Application of Funds” from the list of values in the HANA Spending Detail Universe.
Department Wide  
33050 Populate the debit credit code with '1' for non-taxable amounts greater than zero. This will correct vouchers with only non-taxable amount vouchers from being recorded as credits in ECC thus causing negative amounts on W2's for employees.
Department Wide  
33095 Send reject records from FMMI when the Centrally Billed Account (CBA) Number is blank on third party payments to US Bank. Also, populate the Treasury Vendor Code on Earmarked Funds Commitment lines for the agency portion of FICA and HITS.
Department Wide  
32926 Summarize the detailed payroll transaction data within the AHIS Cost Management System (ACMS).
APHIS  

FMS DATA Act Release Results – Requests for Change (RFC) October 27, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
32833 BI
Prevent the funds commitment and the purchase order (PO) documents from posting without the Award or Vendor ID on the Obligation.
All  
32966 Data Act
Update the DATA Act system with the following enhancements:
  • Prevent GL accounts that begin with 487X, 488X, 497X, 498X and 4902 from having beginning balances. This is required to properly capture balances by BOC.
  • Ensure the balances net to zero within each fiscal year for all prior years and should not report any beginning balance for these accounts. Also, ensure beginning balance amounts for the aforementioned accounts do not pass.
  • Ensure File B agrees to File A at the GL Account level for accounts 48XX and 49XX. Additionally, ensure File B agrees with File C.
  • Create a file and store the Front End Adjustments that were entered into FSDW for cash adjustments, etc. to ensure that they are available for audit purposes.
These enhancements are required to perform an efficient 4th Quarter Data Act Reporting rating.
All  

Back to Top

FMS Financial Systems Release Results – Action Items (AI) October 26, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
33079 CPAIS PP
Correct the error received on the Physical Inventory Report when vehicle records are missing related vehicle data.
All  
33062 BSF
Update the Budget Status of Funds Planning Sequence to allow the Process Chains to complete successfully. Process Chains were experiencing extended processing times due to increased data volume.
All  
33073 BI
Update the fields “TOTALREC “and “TOTALFETCH” to the correct the data type and length/size. Also, correct the data store object (DSO) to accept records and allow files to load.
All  

Back to Top

FMS DATA Act Release Results – Requests for Change (RFC) October 19, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
32870 Implement the Easy Query ad hoc tool that will improve and enhance the sorting, searching and reporting operations in the Reporting of IPAC Transactions for Agriculture (RITA) System. Department Wide  
32971 DATA Act
Enhance the A-C inbound process so that the data is aggregated at the correct level.
ALL 10/19/2017

Back to Top

FMS Financial Systems Release Results – Action Items (AI) October 2-6, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
32899 FMMI
Modify the current (AVC*) control specific for Fiscal Year (FY) 2018 and future years. The change will provide Farm Service Agency (FSA) an improved way to monitor their budget from a higher level of funded program (grouping Work Breakdown Structure (WBS) element on a 2nd level), to provide more flexible operation on AVC rule.
FSA 10/2/2017
33026 FMMI
Block non-A-11 Compliant Commitment Items and GL Accounts, create new GL Accounts as replacements, and implement changes to GL Account Derivations to derive postings to new Accounts. This will prevent agencies from posting accruals and other activities that are not A-11 Compliant, improving FMMI Budget Object Class Processing.
ALL 10/5/2017
32325 FMMI
Enable GL configuration SK CR_UP to allow all fund types in order to complete the transfer from budget clearing (12F3845) to the proper accounting. (Note: This CR was previously included in the November Financial Services Release)
ALL 10/6/2017
33031 FMMI
Add two new Budget Document Types and Budget Types to enable the system to post properly. This change will create a new Doc Type CTCY and Budget Type CTCY which will post to 4392 for the current year posting and, a new Doc Type CTPY and Budget Type CTPY which will post to 4393 for the prior year posting. AMS received a mandate from Treasury requiring them to record capital transactions into certain accounts. This is the posting set up of budget types to allow them to transfer the money in and out by prior year and current year.
APHIS 10/6/2017
33032 FMMI
Add new GL Model for AMS to record Capital Transfer in to TAS (Treasury Account Symbol) 122814. Change the GL accounts for the posting to DR1010/CR5756 and DR5993/CR2985.
ALL 10/6/2017
33034 FMMI
Add an additional derivation step to derive XX budget period for control purposes where the Funds Center is FS1503, FS1504, or FS1506 and the first 2 of Budget Period is >= 18. This will allow FS to enter FY18 budget documents to several funds that are part of their cost pool.
FS 10/6/2017

Back to Top

FMS CRM Release Results - Requests for Change (RFC) September 27, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
32922 CRM
Update Customer Relationship Manager (CRM) Order Data Universe to include the “Grant Award Document Effective End Date” as an available field.
Department Wide  

Back to Top

FMS CRM Release Results - Action Items (AI) September 25, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
32931 CRM
Change FNS Grantor Clearing Notification Program to unlock billing line.  This fiscal year end change will prevent having limits on the total number of locks on the Grantor Billing Document line items and the validation from causing clearing document notifications to be skipped when they are included in a run where the final entry has I_stop_item = ‘X’.
FNS  

Back to Top

FMS CPAIS Real Property Release Results – Requests for Change (RFC) September 22, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
32530 Update the CPAIS Real Property to comply with the mandated Federal Real Property Profile (FRPP) data dictionary requirements provided by Government Services Administration (GSA). Department Wide  

Back to Top

FMS CPAIS Real Property Release Results – Action Items (AI) September 22, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
32522 Update the Government Share O&M script to isolate the zero annual operating cost calculation and the non-zero calculation. This change will prevent the Government Share O&M job from prorating the amount based on the annual operating cost when the annual operating cost is zero. Department Wide  
32722 Exclude Wareyard Size data from Building Square footage calculations. Department Wide  
32834 Modify the Facility Master Plan form to enable the Gross Square Foot (GSF) field to correctly display the GSF amount for USDA Owned and Trust buildings and the Total Rentable SF for all buildings. Also, modify the code for the FRPP Explorer form to display the GSF amount for USDA Owned buildings and the Total Rentable SF for Leased, State and Foreign Owned buildings in the Square Footage fields on their respective FRPP form tabs. Department Wide  
32862 Update the Buildings form (all versions) to enable query criteria (with operators) to be entered into the Total Rentable SF and Total Usable SF fields. The Owned Property, Maintain Property and Explorer-Property forms will be updated. Department Wide  

Back to Top

FMS Financial Systems Release Results - Requests for Change (RFC) September 21, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
32952 FMMI
Update the Debt Write Off and Cash Collections Processor security role authorizations to be able to reference a Funds Commitment (doctypes FNS Grants Award Document (GD) & Vendor Prepay Obligation (VO)) when clearing an accounts receivable invoice. This change will prevent users from receiving the error “You are not authorized to use earmarked fund 910000xxxx.”
Department Wide  

Back to Top

FMS Financial System Release Results - Action Items (AI) September 19-29, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
32952 FMMI
Add Value types 50, 51, 58, 61, 65, 81, 82 and CO to object Specify Value Types for Inclusion in Obligations. This will prevent the error message “No Value Types are Customized” when running FMFG_RPT_E_UNFILLED (Sales Order Adjustments). This program is required for closing out certain Sales Orders for year-end process.
Department Wide  
32150 FMMI
Reinstate valid Accounts Payable which will enable FMMI to post in Cancelled Budget Periods by creating a new Vendor Invoice doc type CP posting to 6800/2960 before the budget period is cancelled. This will also post to BL accounts 4350/4208 in the cancelled BP at the time of reversal of the Vendor invoice.
FMS  
32952 FMMI
Update the Debt Write Off and Cash Collections Processor security role authorizations to be able to reference a Funds Commitment (doctypes FNS Grants Award Document (GD) & Vendor Prepay Obligation (VO)) when clearing an accounts receivable invoice. This change will prevent users from receiving the error “You are not authorized to use earmarked fund 910000xxxx.”
Department Wide  
33020 FMMI
Change the Currency field WRBTR in table ZCPAIS_EXCEPTION to data element DMBTRV, which allows negative values to be displayed/ maintained using SM30. This will prevent the run time error display when users open the ZCPAIS_EXCEPTION table in maintenance view.
Department Wide  
31927 FMMI
Create two new Doc Type/Budget Types (TIFP and TOFP) to allow FS the ability to transfer in and out for prior and current authority. This will be valid for Fund Types DB, SB, and UYSVB and will be available to all Budget Coordinator Roles. Also, allow FS to perform the function of the ETTF budget entry with Fund Type DB and NB.
FS  
32096 FMMI
Update postings for investments, Treasury Account Symbol (TAS) 12X5205. This will add entries to reduce the discount, premium, and amortization to $0 on the matured securities to allow intragovernmental differences to clear.
Department Wide  
32859 FMMI
Modify the Interface program Protracts lookup to ECC to accommodate 6-digit budget year. This will allow Protracts FMMI web service interface to accept 6-digit budget period while performing transaction lookup especially for funds availability checks.
Department Wide  
32990 FMMI
Apply New Validation rules to prevent posting to non-A11 compliant budget object classes (commitment items) as part of the FMMI Object Class Processing Improvements, and new substitution rules for Commitment Item ACRL. Create new Commitment Items to be part of the FMMI Object Class Processing Improvements. This will allow the budget object class to be in compliance.
Department Wide  
33014 FMMI
Prevent users from bypassing the Park/Post check on Purchase Orders.
Department Wide  
32997 FMMI
Modify FY2017 yearend configuration for the year end close process and apply the latest SAP notes for yearend close program to improve year-end performance.
Department Wide  
32905 FMMI
Add a new Posting Model for General Ledger Transaction Model/Transaction Variant YE/UE (Year End Journal Voucher/Unfunded Employment). This new posting model will be able to post Accrued Liability to reimburse Treasury for judgments that will be paid with the following fiscal years appropriation.
Department Wide  
32096 FMMI
Update postings for investments, Treasury Account Symbol (TAS) 12X5205. This will add entries to reduce the discount, premium, and amortization to $0 on the matured securities to allow intragovernmental differences to clear.
Department Wide  

Back to Top

FMS Financial System Release Results - Action Items (AI) September 11, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
32969 FMMI
Update FMMI to post the correct Budget Ledger (BL) posting and Commitment Check errors.
ALL  

Back to Top

FMS FSDW Release Results - Requests for Change (RFC) September 8, 2017

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
32551 Add "Preliminary Budget and Accrual Reconciliation" and "Consolidated Budget and Accrual Reconciliation" Reports to the BOBJ canned reports in the FSDW. Department Wide  
32840 Exclude Entry Type “ET” from the Abnormal Balance Report and Trial Balance Comparative Reports located under Trial Balance Reports. Department Wide  

Back to Top

FMS FSDW Release Results – Action Items (AI) September 8, 2017

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
32131 Update the FSDW security reports to display the Home Agency when there are no users selected. Department Wide Did not complete testing. Will migrate to production when testing has been completed.

Back to Top

FMS DATA Act Release Results - Requests for Change (RFC) September 5, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
32967 DATA ACT
Ensure the Award Description field is populated and contains the entire description on all Data Act reports.
ALL  

Back to Top

FMS Grants Release Results - Requests for Change (RFC) August 11, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results or CR Implementation Date
32502 Implement the Harmonized Data Model (HDM) that will provide access to all ezFedGrants data for adhoc reporting NIFA 8/11/2017

Back to Top

FMS Grants Release Results – Action Items (AI) August 1-7, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Production Date
32887 Add ‘Draft Finalized’ and ‘Cancelled’ as available amendment statuses for NIFA Grants Specialists. NIFA 8/1/2017
32892 Update the CreateApplication stage (the initial stage in the enterprise application workflow) and add a utility to save the application work objects retrieved from Grants.gov.. APHIS 8/7/2017

Back to Top

FMS Grants Release Results - Action Items (AI) August 11, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
32681 Adjust the Grantor Clearing Notification Program to send back the accurate cleared amount for a draw regardless of any other draws being invoiced/cleared on the same document. As a result, the system will be able to do the following:
  • Create multiple draws on the same claim, ensuring at least one is a negative draw
  • Save/release draws so all draws are invoiced together
  • Clear invoice
  • Run Grantor Clearing Notification program to update CRM with Enterprise Resource Planning Central Component (ECC) document details
  • Ensure that clearing document amounts are showing correctly
ezFedGrants  
32740 Update the email template for active agreement & active amendment emails to ensure the template is enterprise/agency agnostic, and update APHIS workflow configuration to trigger an email at the point of approval for an agreement & an financial amendment. APHIS  
32741 Amend Food and Nutrition Service (FNS) custom logic to look up the original invoice, which is tied to a Grantor Billing Document in ECC, and successfully reverse it when the open amount is reduced to $0. FNS  

Back to Top

FMS Grants Release Results - Requests for Change (RFC) August 11, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
32482 Allow Natural Resources Conservation Service (NRCS) to utilize ezFedGrants for Grants Management. This change will prevent the need for using their existing paper based processes. ezFedGrants  
32567 Create Maintenance View for Food and Nutrition Service (FNS) custom tables/views. This change will allow for editing of tables without requiring the user to debug. FNS This CR was not ready for implementation. It will migrate when testing is complete.
32667 Modify the Application for Federal Assistance (SF-424) in Grants.gov to allow editing of Section 19. As a result, agencies will be able to identify when an application is from a Single Point of Contact (SPOC) state. APHIS  
32736 Allow the SF-LLL and Certification Regarding Lobbying attachments to be an optional attachment based on the dollar amount. This change will allow award recipients to determine if the submission is needed. APHIS  
32737 Enable APHIS to populate the Agency Grants Management Officer (AGMO) as a grants specialist contact on an agreement. This change will allow AGMO to be listed as a grants specialist for some agreements, giving APHIS more resources to process agreements. APHIS  
32738 Update the Notice of Award (NOA) to include DUNS to the recipient box. This change will prevent the need to search for the DUNS separately. APHIS  
32739 Update the recipient search in customer relationship manager (CRM) to display PEGA external ID is a field in the resulting the contact list. APHIS  
32744 Enable print functionality for Animal and Plant Health Inspection Service (APHIS) Applications. This change will allow the user to export the APHIS applications to a Portable Document Format (PDF) and print. APHIS  
32747 Update Pega Opportunity screen logic to allow an AGMO to be named as the administrative contact for an opportunity. APHIS  
32785 Allow the Catalog of Federal Domestic Assistance (CFDA) Title on the Application Screen (Section 11 of the SF-424) to populate and pass to PEGA instead of the Program Title. This change will prevent information from being misrepresented to the applicant in ezFedGrants by adding a field to store the CFDA and populate the data. APHIS  
32796 Add logic to the Payment Management System (PMS) substitution rule on the clearing document to handle an input in XREF1 field which will derive PMS F1 and in turn Agency Locator Code (ALC) 12350001. This change will allow ALC derivation 12350001 for clearing documents of A/R invoices cleared by a LOC Offset. FNS  

Back to Top

FMS Grants Release Results - Action Items (AI) August 11, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
32681 Adjust the Grantor Clearing Notification Program to send back the accurate cleared amount for a draw regardless of any other draws being invoiced/cleared on the same document. As a result, the system will be able to do the following:
  • Create multiple draws on the same claim, ensuring at least one is a negative draw
  • Save/release draws so all draws are invoiced together
  • Clear invoice
  • Run Grantor Clearing Notification program to update CRM with Enterprise Resource Planning Central Component (ECC) document details
  • Ensure that clearing document amounts are showing correctly
ezFedGrants  
32740 Update the email template for active agreement & active amendment emails to ensure the template is enterprise/agency agnostic, and update APHIS workflow configuration to trigger an email at the point of approval for an agreement & an financial amendment. APHIS  
32741 Amend Food and Nutrition Service (FNS) custom logic to look up the original invoice, which is tied to a Grantor Billing Document in ECC, and successfully reverse it when the open amount is reduced to $0. FNS  

Back to Top

FMS Financial Systems Release Results – Requests for Change (RFC) August 11, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results or CR Implementation Date
32244 Update the Disbursement File that is transmitted to US Bank via the U.S. Treasury to include the Travel TA number. CFO 8/11/2017

Back to Top

FMS Financial Systems Release Results – Action Items (AI) August 2-11, 2017 (Emergency)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results or CR Implementation Date
32797 Increase the size of the D2 Award Description field to prevent the truncation of entries in excess of 240 characters. FMS 8/11/2017
32888 Update the ECC to CRM clearing interface to only send back amounts of newly cleared invoices instead of the aggregate amounts. NIFA 8/2/2017
32903 Add ALC 12360037 to the T880 Table and redirect all transactions from ALC 59000003 to ALC 41800000. FS 8/2/2017
32907 Update the A-C Error Report to display decimals in the amount field. Also, correct the Ending Period of Performance to show the correct data rather than an error code. FMS 8/1/2017
32911 Update the D2 process chain to execute on the 3rd and 18th day of each month. FMS 8/10/2017
32921 Update the File C validation process for 48 and 49 series SGL account to contain either a FAIN or PIID. When this information is missing a “soft error” is sent to the agencies for error remediation. FMS 8/7/2017

Back to Top

 

FMS Financial Systems Release Results – Requests for Change (RFC) August 11, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted

Change Request (RFC) Description Agency Release Results
30890 Modify the Grouping key in the Company Code Data area to default to Z0 and the default Dunning Procedure on the Forest Service (FS) Pre-Approved Vendor (PVND) customer request to 1006 regardless of what is entered on the PVND request. FS  
31156 Update FMMI Prompt Pay calculation of FI invoice due dates for the IAS receipt elimination. This change will allow  FMMI Prompt Pay calculation to consider Goods Acceptance date in Penalty determinations, resulting in accurate due dates on FI invoices. Also, it will prevent incorrect penalty payments. Department Wide  
31231 Modify View mode of the Shorthand Code (SHC) list display in order to display published dates and published times for SHCs that have been published to Management Account Structure Codes (MASC). FMS  
31385 Update External Manufacturer field to capture the origin vendor from the Employee Name Inquiry Table (NEMP) when employee vendor records are interfaced into FMMI. As a result, the Employee Vendor Master record will now show ‘NEMP’ in External Manufacturer field instead of a blank field in display mode. FMS  
31798 Modify the Electronic Travel System 2 (ETS2) interface program to validate the Funds Reservation Number (FRN) and the Document Control Number (DCN) against the FMMI SHC for all new authorizations. This change will prevent invalid accounting. FAS  
31928 Create entries in the Change Log for Vendor Display (XK03) when requested fields are changed in the System for Award Management (SAM) to FMMI Interface. This change will allow the SAM to FMMI interface to enable an audit trail on the federal tab. FMS  
32084 Modify Dashboard Report to capture stats for FS Fleet Education Department (FED) Inbound and Outbound.  As a result, the user can view interface execution results. FS  
32101 Modify FMMI to automatically place a payment block on a customer master record when the TIN match code returned from the IRS is "not" 6, 7, or 8. FMS  
32103 Modify the SAM to FMMI interface (ZMMI_SAMVENDOR_LOAD) to eliminate special characters. Department Wide  
32138 Modify the SAM vendor create/update routines to use the Legal Business Name from the SAM interface record as the Vendor Master Name (LFA1-NAME1). This change will accurately assign vendor names for Sole Proprietor Vendors. Department Wide  
32267 Implement Natural Resources Conservation Service (NRCS) Strategic Operational Analytics and Reporting (SOAR) Release 2. NRCS  
32277 Remove the Remit-To field from the SAM/Central Contractor Registration (CCR) vendor custom search ZCCR1 results. In addition, update the output layout with the following:
  • Add column for Industry after Group column
  • Add column for Commercial and Government Entity (CAGE) code after DUNS+4 column
  • Remove Remit-To column
    This change will only allow the Mailing record in the resulting fields when a user double clicks the resulting line entry.
Department Wide  
32294 Modify the FMMI default setting for Service/Value-based Purchase Orders (PO), to leave the Goods Receipt box "unchecked". This change will prevent errors from occurring when users attempt to create a Service/Value Based PO and multiple invoices are posted to the PO. Department Wide  
32352 Update the Cost Management Processor role to include new Transaction Codes (Tcode) KJH1/2/3 (Create/Change/Display WBSE Group). Department Wide  
32660 Perform modifications to Budget Status and Funds (BSF) to allow the Administrator to manage system messages for the user community. The messages will be viewable by users within the BSF Application. Department Wide  
32661 Perform modifications to BSF to allow users to view forecast data for an entire year. This change will allow users to plan future year budgets accordingly. Department Wide  
32693 Modify FMMI to map document type XP data contained in the document header text field to the Payee Id field of the Standard Payment Request (SPR) files for the moveLINQ implementation. Department Wide  
32728 Create new Key Figures columns in the APM Allotment Status Report to replace the existing columns which no longer hold significant business meaning to Farm Service Agency (FSA) reporters. This change will enable users to save and reload user-specific display settings and filter criteria. FSA  
32800 Replace the VADAR roles with OMS roles to allow the capability to process documents. As a result, the security roles will be traded for OMS, allowing users to post documents to clear the invoices. FAS  
32801 Update the Overseas Maintenance System (OMS) Re-processor to allow the re-try function for records that were marked as manually completed. FAS  
32802 Modify the OMS Application Programming Interface (API) to replace the original business process assignment record when performing the re-processing function. As a result, the re-processor will only have one record for the initial OMS record. FAS  
32803 Modify OMS to exclude processing non-disbursement records received in the daily interface file. As a result, the skipped records will not be treated as an expenditure when users attempt the reconciliation process. FAS  
32804 Create a notification to be emailed to FMMI.OMS@aphis.usda.gov with a summary status after processing the OMS daily file. FAS  
32814 Adjust the Mulesoft OMS logic so that operating allowances with "76" in characters 3-4 are treated the same as the ones with "71". This change will prevent the 76 number series from being processed as a funds reservation and correctly identify it as a funds commitment, so the obligation amount will not be updated.  FAS  
32815 Adjust the OMS Re-processor program to allow a correction to the Post-to-code value. This change will enable users to identify the vendor that is going to be used in expenditures. FAS  

Back to Top

FMS Financial Systems Release Results – Action Items (AI) August 11, 2017 (Scheduled)

All CRs were implemented successfully unless otherwise noted

Change Request (AI) Description Agency Release Results
30490 Update logic to verify that each Rule Based Account Assignment (RBAA) line on the Invoice Receipt line contains a matching line item on the Goods Receipt document. This change will prevent Integrated Acquisition System (IAS) from receiving the M8 Account Assignment Error. FS  
30837 Modify the User Exit (EXIT_SAPLFMFR_004) when there is an advance on the funds commitment, to ensure the following exists before it is set to complete:
  1. Liquidation of Advance
  2. Refund of Advance
  3. Billing to Customer and reverse the down payment request This change will allow the Funds Commitment and Budgetary Ledger to update accurately
Department Wide  
30943 Update system assurance validation logic which compares header amount and sum of line item amounts in Process Integration (PI). This change will prevent POSS Interface file from abending. FS  
31422 Change Marketing and Regulatory Programs (MRP) and Food Safety and Inspection Service (FSIS) Customer Statement to display a "+" sign for debits and a '-' sign for reversals. MRP & FSIS  
31796 Perform all vendor updates to the mailing record and partner vendors. Once all updates are completed, pass through all vendor records again to perform the block/unblock where necessary.  This change will bypass the conflict where the vendor update process still has a lock on the vendor master when the block/unblock in XK05 is initiated, and remove the purchasing block from active vendors. Department Wide  
32077 Establish new United States Standard General Ledger (USSGL) account 4360 and related transactions in FMMI. Department Wide  
32102 Modify NEMP interface to ensure the link between employee vendor number and corresponding customer number is properly established with a vendor number starting with ‘4XXXXXXXXX’. This change will ensure users can search for customers by vendor number and Social Security Numbers (SSN). Department Wide  
32168 Update re-processor programming as necessary to map the line text information to the text field on payments that are going into parked status when coming from the Incident Business System (IBS). This change will allow parked documents to update accurately. FS  
32252 Update the HANA Trial Balance to provide results for "Accounttype" when it is added to the Results Objects. This change will prevent the error message display when users attempt to add an additional object to the HANA Trial Balance. Department Wide  
32280 Update the program for the Billing Process Global Status Report, Approver Billing Process Detailed Report, and Requestor Billing to display the report output in the same format and provide accurate data. This change will allow reports to filter data based on what the user entered on the selection screen and not by any conditions in the backend. FS  
32496 Remove the error message "This function is obsolete" from the Billing Process Global Report (ZMM_BP_GLOBAL_REP) by replacing the call of the obsolete Function Module (FM) with the updated FM. This change will prevent error messages from appearing at bottom of the BVAS report screen. FS  
32501 Implement Systems, Applications, and Products (SAP) note to update cloud upgrade sorting issue with budget period assignment. This change will allow the Funds Management (FM) Deriver Table to be in alphabetical order. Department Wide  
32560 Optimize the performance on the Miscellaneous Object Submission Tool (MOST) global report to reduce runtime. FS  
32579 Add logic to the Cooperative Research, Education, and Extension Management System (CREEMS) error message to show that the PO was marked for deletion. This change will allow the interface to identify/locate the PO by the CREEMS award number when the interface sends a transaction to de-obligate/modify the PO amount. NIFA  
32602 Update code to correct logic in the Invoice Processing Platform (IPP) invoices to resolve missing data issue. Department Wide  
32611 Add Commitment Item 1109 to Rate Calculations for BSF. This change will calculate the salary rate and benefits percentage.  Department Wide  
32652 Modify the Create Program Loan Cost Expense (PLCE) Invoice function module to add COMMITs after PARK function. As a result, when the approver attempts to retrieve the document for approval, it is available. RD & FSA  
32675 Modify Allocation Percentage for BSF when an employee switches Human Resources (HR) Organizations to zero-out old forecasts. As a result, the planning recalculation will be accurate. Department Wide  
32676 Modify Personnel Projections to ensure HR Organization is after pay period (19 B Projection) for BSF. As a result, When a user runs the Personnel Projections by Account Assignment or the Budget Status of Funds report on a prior year, projections will display for 19B (last pay period of year). Department Wide  
32700 Create Future Year Initialization for Vacancies for BSF. As a result, Future Year initialization process will take into account any vacancies during projection calculation. Department Wide  
32701 Modify the FMMI to PLCE Interface to remove the run-time error when the Project Number is '---' to avoid exception errors when running the PLCE backfeed. RD & FSA  

Last Updated / Reviewed: October 03, 2018