Attachment_2B_-_FBMS_Development_Objects_1.pdf

U.S. Department of the Interior

FBMS Support Services IDIQ / BIO Task Order Support Services PWS

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Master Data BW D9

Accounts Payable BW D9

Account Receivable BW D9

Controlling BW D9

Funds Management BW D9

General Ledger BW D9

Project Systems BW D9

Sales and Distribution BW D9

Charge Card BW D9

Labor BW D9

Special Ledger BW D9

GWA Recon BW D9

Cash Recon BW D9

Acquisition R/3 BW D9

Acquisition PRISM Contracts Awards BW D9

Acquisition PRISM Requisitions BW D9

D2 History BW D9

Fleet Measurement Forecast Calulate Key Figures BW D9

Asset PP MY

Fleet Operations BW D9

Fleet Measurement and Analysis FL D9

Workload and Workforce Planning BW D9

Hyperion BW D9

Financial Assistance Funding Opportunity BW D9

Financial Assistance Awards BW D9

Financial Assistance FAADS BW D9

Master Data for Real Estate BW MY, D9

Real Estate BW D9

Acquisition ME51N BW D9

Centralized Audit Logging Repository BW D9

Centralized User Master Repository BW D9

FWS FAIMS report replacement FM D9

Material Inventory FM D9

FAIRS Reporting - BW Extractor Aviation D9

BW Energy Reporting Requirements BW D9

Rpt for Bus- Objects Planning and Consolid. (BPC) BW D9

GSA Vehicle Reconciliation Report BW D9

BW Report for Government furnished housing BW D9

HR Mini-master BW D9

BW Cube to report from BOR Attribute table BW D9

GovTrip Legacy Data Warehouse BW D9

Land Records Report BW D9

Share Balance OSM FA D9

FBMS ARRA Transactions - OMB Recipient Reporting T FA D9

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

FRPP XML File Generation RP D9

"AFR-Balance Sheet - includes GFRS Modules 2,3" BW D9

"AFR-Statement of Net Cost - includes GFRS Modules BW D9

"AFR-Statement of Changes in Net Position - includ BW D9

AFR-Statement of Budgetary Resources BW D9

"AFR-Statement of Custodial Activity - includes GF BW D9

AFR-Schedule of Spending BW D9

Note 2: Fund Balance with Treasury BW D9

"Note 3: Investments, Net" BW D9

"Note 4: Accounts and Interest Receivable, Net" BW D9

"Note 5: Intragovernmental Loans and Interest Rece BW D9

Note 6: Loans and Interest Receivable BW D9

"Note 7: Inventory and Related Property, Net" BW D9

"Note 8: General Property, Plant, and Equipment, N BW D9

Note 10: Assets Analysis BW D9

Note 11: Debt BW D9

Note 12: Federal Employee and Veteran Benefits BW D9

Note 13: Contingent Liabilities and Enviromental a BW D9

Note 14: Liabilities Analysis BW D9

Note 15: Leases BW D9

Note 17: Costs and Exchange Revenue by Responsibil BW D9

Note 18: Statement fo Bedgetary Resources BW D9

Note 19: Reconciliation of Net Cost of Operations BW D9

Note 20: Earmarked Funds BW D9

Note 21: Liability for Capital Transfer to the Gen BW D9

Note 22: Fiduciary Activities BW D9

Inter-Bureau Matching Report BW D9

Pre- and Post-Elimination Report BW D9

AFR-Intergovernmental Reconciliation File BW D9

AFR-Account Relationships Analysis Template BW D9

AFR-Financial Statement Line Item Variance Analysi BW D9

AFR-Distributed Offsetting Receipts Reconciliation BW D9

AFR-Statement of Budgetary Resources to SF-133 Var BW D9

"GFRS Modules 4,6 - Financial Report Notes" BW D9

Energy Charge Card Reason Code Report BW D9

Application of Funds FM D9

Funds FM D9

Functional Areas FM D9

Fund Centers FM D9

Cost Centers CO/PS D9

Vendors Open Docs AP D9

Open Receivable Customer Master Data Conversion SD D9

WBS Elements CO/PS D9

Derivation Tables FM D9

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Reimbursable Agreements SD D9

Final Cost of Reimbursable Agreements SD D9

RRB for Reimbursable Agreements SD D9

Collections Against Reimbursable Agreements SD D9

Non-Reimbursable Open Receivables AR D9

Non-Acquisition Open Obligations AFA D9

Standing Work Orders RP D9

Summary Invoices AP D9

GL Accruals GL D9

FM Budget Upload FM MY

G/L Summary Account Balances GL D9

Employee Customer Master Record Conversion LB D9

Contracts Load to Prism AFA D9

Credit Card Hierarchy Upload CC D9

Create SD Billing Documents SD D9

ZCARDMASTER Upload CC D9

Vendor Master Extract for PRISM AFA D9

UPC Table and Initial Load PP D9

Legacy Acq. Obligations to PRISM AFA D9

HR MiniMaster Organizational Hierarchy Reassignmen HR D9

Conversion of Costs for AUCs CO/PS D9

Functional Location FL D9

Standing Work Orders FL D9

Maintenance History FL D9

Asset Master PP D9

Convert Non Employee to HR Mini Master HR D9

HR Organization Management Conversion HR D9

Personnel Data Sheet Conversion TRAVEL/PCS D9

Fleet Master FL D9

Maintenance Plans FL D9

FA Awards to PRISM FA D9

Business Entities RP D9

Buildings and Structures RP MY

Land RP D9

Congressional Districts FL D9

Rental Contracts RP D9

Supporting Documents for Reimbursable Agreements SD D9

Convert Fee Schedule for Customer Master Records SD D9

Costing Sheets CO/PS D9

Rental Objects RP D9

Convert Attachments to Property Records RP D9

Material Master Conversion IM

Inventory Transaction Conversion IM/AFA

Energy Utility Meter Conversion RP D9

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Charge Card Master Data Maintenance CC D9

Revenue Recognition - Earned Unbilled SD D9

Revenue Recognition- Sales Order Value SD D9

Fleet Allocation - ZD Table Development FL D9

Treasury-IPAC SD D9

Treasury - 1099 AP D9

Validation Table Maintenance FM D9

Validation Table User Exit FM D9

Derivation Table Maintenance FM D9

Billing Limit SD D9

Business Area Validation User Exit CO/PS D9

Check WBS Element on Order SD D9

Adding Empty Milestone to Sales Order SD D9

Charge Card Custom Front End To Reallocate Costs CC D9

Vendor Validation DUNS Number AFA D9

Mass Transfer of Assets PP D9

Mass Update to Non-Account Fields in Asset PP D9

Additional Fields for Travel PCS TRAVEL/PCS D9

Open & Close Posting Periods GL D9

Automatically Create Funded Program from WBS Elmts CO/PS D9

Sales Order Amendment Tracking SD D9

Additional fields for PO AFA D9

CUA/AD Integration GL D9

Transaction for PSS Table Maintenance AP D9

Auth Check by Bureau when creating Billing Docs SD D9

Project and WBS Security Validation CO/PS D9

FM Enhancements & Validations GL D9

Validation After Document Splitting FM D9

Park and Post JV Validation GL D9

Expired Account Assignment Validation FM D9

Un-Liquidated Obligation Accrual JV and Report GL D9

Stewardship and Heritage Assets GL D9

Calculate Overhead on Obligations FM D9

Additional Asset fields PP D9

Asset and Equipment Master Sync FL D9

RITA Calculation TRAVEL/PCS D9

Funded PR for MO (AutoChoice) AFA D9

Budget Overhead Control FM D9

ABP Budget Version BADI FM D9

ABP Budget Version Enhancement FM D9

CLERK/SUPERVISOR functionality AP D9

PCS Personnel Data Sheet TRAVEL/PCS D9

Fleet Allocation - Custom Screens FL D9

Fleet Allocation - Fleet Logic Development FL D9

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Fleet Allocation - Fleet Accrual FL D9

Display Payment Proposal by Business Area AR D9

Enhancement for FM Actuals AP D9

Utilization tables update program FL D9

TVARVC variables update program FM D9

Catch up invoice load program AP D9

Zcard Admin Update CC D9

Fleet Data Correction Program FL D9

SPS Summary AP D9

Prevent Reversal of ABP Budget Doc FM D9

Wrapper Program for Treasury Confirmation Reproces AP D9

Mass Check Reversal AP D9

Check Create and Transfer AP D9

Mass Locking & Unlocking SAP Users SEC D9

Maintain SAP Business Workplace Substitute Table AFA D9

Enhancements to Measuring Points and Measuiring Do RP D9

Manual Accrual and JV Upload Program GL D9

Enhancement to Asset Master Standard Fields PP D9

Customer Master Search AR D9

Enhancement to Restrict Multiple Standing Orders RP D9

Validations for MIRO Documents AFA D9

Report Writer Authorization Checks AR D9

Allocate Open Commit & Oblig for Complex Projects FM D9

Additional RE Fields for Land RP D9

Additional RE Fields for Business Entities RP D9

Additional RE Fields for Building and Structures RP MY

Additional RE Fields for Rental Objects RP D9

Preventative Maintenance Due Notifications FL D9

Custom Fields-Header and Line item AFA D9

Maintain Acct Assignment derivation rules for IBIS AR D9

Control Timing of Commitment During PR Process AFA D9

Derive Funding Information from WBS on RE object FM D9

Automate Create/Synch Asset to RE Objects RP D9

Additional RE Fields for Rental Contracts RP D9

Additional Sales Order Fields SD D9

Auto populate Cost Center for USGS FM D9

GSA Rent Bills Rent Difference Posting Program AP D9

PR Security Enhancement AFA D9

Auto JV For Purchased Assets on Reimbursable Agrm SD D9

Real Property Structure and Authorizations AP D9

CPO Acceptance PP D9

Feebacs clearing by Item Text AR D9

FUNDS COMMITTMENT ASSIGNMENT RULE FM D9

Zcard_MAA Audit Trail cleanup CC D9

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Manually Set Status of IDOC for Deletion SD D9

Transaction to Delete PR lines that will not be aw AFA D9

Treasury Confirmation BADI for check numbering AP D9

FM Posting Date Pop-Up Screen AP D9

POD Reconciliation Entry AR D9

Mass Changes for Fleet Records FL D9

Mass Change of Real Estate Objects RP D9

Justification of Vehicles FL D9

Workorder FM Attributes Validation FM D9

Split Treasury payment files into multiple files AP D9

Inbound IPAC enhancement for Treasury Payments AP D9

Enh Vendor Master to include FIPS Codes for CPATAX BPI D9

Standard Collections Enhancement AR D9

Sec to prevent CO from receiving goods & receipts AFA D9

Exclude expense overhead calculation on accruals CO/PS D9

FWS Reversion of funds on grant de-obligations FM D9

FWS Safety Margin and Reversion Ledger Report FM D9

Default cost center from Workorder or RE objects FM D9

Maintain Taxable Travel Expense TRAVEL/PCS D9

DOI specific checks on the Sales Order SD D9

Lock/Deactivate Inactive users SEC D9

STIG Compliance Enhancement SEC D9

Automate User Provisioning SEC D9

Distribution Model Maintenance CC D9

POD interfaces deletion program AR D9

User Exit to Support GRC SPM Module SEC D9

Vendor Maintenance BAPI SD D9

Vendor Maintenance SD D9

FM Document Journal Enhancement FM D9

Enhancement to the Program to Exclude Invoices fro AP D9

Mass changes for utilization cost structure FL D9

Work Order Custom Fields RP D9

RtPM Database SEC D9

AMD Generate Fleet SD Bill Aviation D9

AMD Cost reallocation from DOI IAA Aviation D9

DATA Act File C Enhancement FM D9

AMD AUR application Aviation D9

AMD AUR Life Cycle Transaction Aviation D9

AMD AUR file upload utility Aviation D9

AMD Maintain Pricing Schedule Aviation D9

AMD Update IPAC and Billing information on AUR Aviation D9

AMD Post Measurement documents from AUR Aviation D9

WCF Cost Revenue Transfer AFA D9

Generate a file that can be uploaded to Treasury's AR D9

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Statistical Sampling process changes with new AD AP D9

Energy Meter Master Data RP MY

Capture energy consumption and cost RP MY

Enhancement to Update Real Estate Contract RP D9

Energy Cost and Consumption Upload Program RP MY

Enhancement for MM invoice docs AP D9

Populate Customer Field USERDIM for FM Actual Data FM D9

Attribute table for Project Cost Accounting CO/PS D9

Interior Agency Disposal System(IADS) Custom Entry PP D9

Add Additional Fields to DP98 Report Layout AR D9

Mass Update of WBS Settlement Information CO/PS D9

Allocate JVs Posted BPC for GPRA GL D9

Maintain GL Cost Allocation Profile GL D9

Perform GL Cost Allocations GL D9

UPC Look-Up Transaction AFA D9

PR Redesign WebDynpro AFA D9

Upload Tool for Assets Inventory PP D9

Mass update of non-financial fields on RE Objects RP D9

BOR Allocation upload program GL D9

Mass Update of Workflows AFA D9

AR - Correspondence-003 Form 1 SF-1080 AR D9

Mass Update of CO/COR AFA D9

AR-Correspondence-003 Form 3 DI 1040 AR D9

Mass Update of Name changes for SPOCs SEC D9

AR-Dunning AR D9

Update compliance software emails SEC D9

PCS Authorization Form TRAVEL/PCS D9

PM Work Order Form (shop papers) FL D9

Calculation of RITA Results TRAVEL/PCS D9

Purchase Requisition Printout AFA D9

Print Interagency Agreement SD D9

Intra-Agency Agreement Form AFA D9

Labor Personnel Data Split D4 Amendement 1 LB D9

Labor Intf. Custom Table Up-Load-D4 Amendment-10 LB D9

Labor-Relo-FPPS-D4 Amendment-11 LB D9

IF017_Labor Leave Surcharge and Distribution-D4 Am LB D9

Labor Overhead and Indirect Cost LB D9

Laboremp-D4 Amendment-2 LB D9

Labortime-D4 Amendment-3 LB D9

Labormain-D4 Amendment-4 LB D9

Labor Post Actuals-D4 Amendment-5 LB D9

Labor Post Accruals-Payables-D4 Amendment-6 LB D9

Labor Adjustments-D4 Amendment-8 LB D9

Laboradjpost-D4 Amendment-9 LB D9

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Labor Sync Report LB D9

Create/Modify/De-obligate Obligation AFA D9

Vendor Table Synchronization AFA D9

Charge Card Daily Invoice File CC D9

Motor Pool Charges AP D9

Secure Payments AP D9

GOALS AP D9

PCS Extract TRAVEL/PCS D9

Real Time Acct Code Verification TRAVEL/PCS D9

Trip by Trip Voucher TRAVEL/PCS D9

Disbursement Notification TRAVEL/PCS D9

ASAP Treasury Funds Release FA D9

ASAP Payment Details FA D9

AR Open Items to CBS SD D9

External Validation Files AR D9

Customer Refund Data AR D9

Inbound Bills and Refunds from CBS AR D9

Inbound Collections from CBS AR D9

Inbound Write-offs and Waivers from CBS AR D9

INTERNAL BILLING DATA GL D9

IPAC Charges for Aircraft Usage AP D9

Billing and Collections (Feebacs) AR D9

Bank Data Master File Periodic Updates LB D9

Synchronize SD-Prism-MM AFA D9

Quicktime Interface Files AFA D9

FPPS Employees to HR minimaster HR D9

WBS Creation from Fire Number CO/PS D9

Debt status update AR D9

IPP Vendor AP D9

IPP Purchase Order AFA D9

IPP Invoice AP D9

IPP invoice Status AP D9

PRISM Closed Contract Status to R/3 (IPP) AFA D9

MAXIMO to SAP RE Record RP D9

SAP RE Record to MAXIMO RP D9

Ending Odometer Info (Mileage Express) FL D9

IBIS- Inbound Open Items for customers - Bills AR D9

Funding information from FBMS FM D9

BASIS+ Account Records to FBMS- Projects/WBS CO/PS D9

Networx Charges - Data AP D9

GSA Rent Bills interface AP D9

PR Interface to PRISM AFA D9

PR Attachment to PRISM AFA D9

IBIS - Inbound Collections and Write-offs AR D9

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

IBIS - Inbound Reversals for Bills and Collections AR D9

Fuel Consumption/Cost Data for GSA Vehicles FL D9

GSA Drive Through Data FL D9

Spending information from FBMS to BASIS+ FM D9

POD - CPOATG Payables and Receivables Interface POD D9

POD-CPATAX Payables against Taxing Authority Intrf POD D9

POD-CPAPAY Disbursements against generic vendors POD D9

POD-PCSTFIL Off-cycle employee Payroll transaction POD D9

Automatically create POD Employee Vendors POD D9

MAXIMO Workorder interfaces Inbound RP D9

MAXIMO Workorder interfaces Outbound RP D9

Standard FBMS WBS Element upload CO/PS D9

Outbound POD200 Interface to FPPS Datamart POD D9

PRISM to CUP Interface SEC D9

PRISM to RAR Interface SEC D9

CUP to ECC Interface for Table Updates SEC D9

DOI Learn and Compliance Software interface SEC D9

Mass Vendor Load BPI D9

Real Time Acct Code Verification - ETS2 TRAVEL/PCS D9

Trip by Trip Voucher - ETS2 TRAVEL/PCS D9

Disbursement Notification - ETS2 TRAVEL/PCS D9

Interface Asset Information from FBMS to IADS PP D9

Interface Attachments (Pictures) from FBMS to IADS PP D9

Interface from FBMS to iQMIS Real Estate Master RP D9

Interface from iQMIS to FBMS Rental Unit RP D9

Interface from iQMIS to FBMS - Contract/Tenant RP D9

Portal Master Framework PORTAL D9

Calendar Design Update (Calendrix) PORTAL D9

Content Management PORTAL D9

Portal Collaboration PORTAL D9

ME21N Transaction Simplification PORTAL D9

Mass Upload of License Plate Records PORTAL D9

CAM PORTAL D9

Automate Customer Update Request Form PORTAL D9

Automate Vendor Update Request Form PORTAL D9

Portal Custom Login Module PORTAL D9

Compliance Software Portal Development PORTAL D9

Users by Roles and Groups PORTAL D9

US CERT HSPD-12 Authentication PORTAL D9

Synchronize New Portal Role Assignments PORTAL D9

PrePayment Invoice Report (YFBL1N) AP D9

Distribution of Receipts AR D9

Payment Warehouse Report SD D9

Elimination Report GL D9

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

FBMS Custom Table Browsing Report GL D9

Fleet Ulitization Batch Status FL D9

Treasury Confirmation AP D9

Workflow Status Report AP D9

Residual Budget Address FM D9

UDO Issues Report GL D9

UDO Aging Report GL D9

PO - GL Account Discrepancy GL D9

FEEBACS Detail Report SD D9

Subsequent Activity SD D9

Reimbursable Orders Report SD D9

Trial Balance by Fund at Full GL D9

SPL Summary Trial Balance GL D9

Document Summary Report FM D9

Parked Document Report GL D9

Purchasing Report AFA D9

Reports on FI Documents With Missing FI-SL Documen FM D9

GSA Rent Bills reconciliation report RP D9

Real Property Work Order Report RP D9

FRPP Summary Report RP D9

Real Property Summary Cost Report RP D9

Department Quarterly Lease Report RP D9

CC Reallocation Reconcilliation CC D9

CC Interface Reconcilliation CC D9

Open GR/IR Balance Report AFA D9

Duplicate Invoice Report AP D9

Five Year Sapce Management Plan RP D9

Future Lease Payments Report RP D9

Accounts Payable Worflow Report AP D9

AP Payment Warehouse Report AP D9

STIG Compliance Report SEC D9

FWS Year-End Carry-Over Report FM D9

Report of collections w/o corresponding open bills AR D9

DOI Learn and Compliance Software Report SEC D9

Energy Meter Master Hierarchy Report RP D9

AQD requirement for service fee report AR D9

AQD Customer financial summary report AR D9

Energy to FI Document Reconciliation Report RP D9

WF - FI Document Payment Release AP D9

Goods Receipt Initiation upon Invoice Receipt AP D9

Release Strategy - Workflow AFA D9

Workflow for RE Contracts RP D9

AP Attachment Reporting AP D9

Mass Change for SD Orders SD D9

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Prevent Cancellation of SD Bills with Follow-On Docs SD D9

Bulk Reclassification GL D9

Trading Partner TAS BETC Defaults and Validations FM D9

Button to Open New Window for Multiple Transactions PORTAL MY

FBMS - MAXIMO IDOC Report RP Sprint 2

Process Energy Consumption and Cost Allocations RP D9

Automated JV for SD IPAC Chargebacks SD D9

Program to block/unblock vendors AP D9

Automated update of personalization information SEC D9

Do not pay interface AP D9

Expiring IPP-EFT Waiver Update AP R.FEB.15

Expired Waiver Report AP R.FEB.15

Invoice in Progress Report AP Feb - Oct 15

USER STATUS ETCO ENHANCEMENT FM R.MAR.15

AP Correction Program AP R.MAR.15

Custom Receiving transaction AFA R.MAY.15

AR Dunning - Prevent Cross-Bureau Postings AR R.APR.15 Extract Attachments from PRISM Award and use Crosswalk to map to FBMS Archivelink document AFA FY15

Attach documents (Acquisition Files) to FBMS (SAP) Purchase Orders/Awards AFA FY15

Front End to attaching documents to Purchase Orders/Award via OAOR AFA FY15

Moving attachment data from SAP PR to PO AFA FY15

Purchase Order Attachment Report AFA FY15

Business Entity Reorganization Tool RP R.OCT.15

PCS Authorization Form - DI-6002 TRAVEL/PCS R.OCT.15

Contract Avation FBMS AUR Transaction Aviation R.MAR.16

AIRS Application Aviation R.MAR.16

OData services for AIRS Aviation R.MAR.16

Real Estate to Asset Sync RP R.JUL.15

HRMM ReOrg Enhancement HR R.OCT.15

Invoice Update Enhancement AP R.OCT.15

Create Physical Inventory Document By Material IM R.NOV.15

Print Physical Inventory Form IM R.NOV.15

Tableau Trusted Certificate Authenitcation BW R.DEC.15

FBMS External User ID Generator Aviation R.MAR.16

PALT Tracking Report AFA R.DEC.15 enhancement to validate budget addresses on budget documents FM R.FEB.15

Reopen ASAP Accounts FA

Bulk Reclassification AP

Attachment security - sensitive docs SEC etravel BW

TROR Cube AR

SDS Cube AR

Portal Activity Report PORTAL

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

GTAS BAdi FM R.FEB.16

Receiving Issues Report AFA R.APR.16

GRC EFT IPP Waiver Process AP

Fleet Utilization PP

ABP Budget Version Comparison Report. FM R.JUL.16

AIRS Admin Access App Aviation R.JUL.16

Additional PO data from PRISM to SAP AFA R.JUL.16

Asset Shells deletion for the trash canned PR's and PO;s PP R.JUL.16

Tableau Web data connector PORTAL R.SEP.16

Authorization Validation for Budget FM R.SEP.16

Version 0 Postings

SF133 Upload for DATA Act File A FM R.Nov.17

DATA Act File A Creation FM R.Nov.17

FBMS External Portal Portal R.JUN.16

External Portal Help Portal R.JUN.16

Labor Business Area Mismatch Override and Reconciliation TRAVEL/PCS R.FEB.17

Enhancement to prevent rule values transport for FMDERIVE FM

Labor Business Area Mismatch Override & Reconciliation Report LB R.MAR.17

Recoveries Report and JV Enhancement FM R.MAY.17

Enhancement to scramble CC files CC NA

Enhancement to scramble Labor files LB NA

Terms and Conditions Portal

Non-Fleet Aviation Pricing Condition Report Aviation PIID Project

BOM Upload Program CO/PS R.FEB.2018

Routing Upload program CO/PS R.FEB.2018

Residual BUdget Report FM R.MAY.17

GRC to External Portal Interface Basis R.MAY.17

Tableau to Version One through a WDC R.DEC.17

Vendor POC Report AFA R.MAY.17

MDG Hierarchy Detail Report MDG R.JUL.17

Cleared Invoice Timeline Report AP R.JUL.17

SOD Mitigation Monitoring Report SEC R.DEC.17

BW Travel Data Warehouse TRAVEL/PCS R,DEC.17

FBMS SAP ID search SEC R.JUL.17

Mass Reversal of Energy Cost and Consumption Documents RP R.FEB.2018

MDG Hierarchy MDG R.JUL.17

SSO with BOBJ and Tableau through/using Portal SAML Portal R.DEC.17

MDG_AOF Design Spec MDG R.JUL.17

MDG_Cost Center Design Spec MDG R.JUL.17

MDG_Functional Area Design Spec MDG R.JUL.17

MDG_Fund Center Design Spec MDG R.JUL.17

MDG_Funded Program Design Spec MDG R.JUL.17

MDG_Fund Design Spec MDG R.JUL.17

MDG_ProjectWBS Design Spec MDG R.JUL.17

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

MDG_Fund_AOF_Rollover_Program MDG R.JUL.17

Lease Obligations RP R.DEC.17

PRISM to SAP Obligation Interface Acq R.MAY.18

Goods Movement Output - Receipt IM R.MAY.18

Contract Hold Back Report AP R.FEB.2018

Interface for Profile Maintenance - ETS2 TRAVEL/PCS R.Nov.2018

SXMB_moni utility AFA

1099 Printing interface to 1099PRO Vendor AP R.Dec.2017

Custom fields on FB70 AR R.May.2018

Enhancements on Investment document AR R.May.2018

Additional fields on Project Definition AR R.May.2018

Tableu to GRC Interface for user managment SEC R.Jul.2018

Tableu to Bison Connect via Google Connector Basis R.May.2017

NARDAR external portal website Portal R.May.2018

SAP PR Status Report AFA R.May.2018

NRDA Investment Activity Report AR R.May.2018

PR Status Report Acq R.May.2018

Trading Partner Activity Report FMGL R.Jul.2018

Charge Card Master Interface SP3 CC R.Nov.2018

Charge Card Invoice Interface SP3 CC R.Nov.2018

NRDA Transactional Report and Website BW R.May.2018

Contract Cash Flow Report RP D8

MDG Hierarchy Master Data Deletion Program MDG R.May.2018

IPAC and Invoice File Upload AP R.Jul.2018

RFC/Change Doc Enhancement for solman solman R.Dec.2018

Vehicle Justification Report Fleet R.Dec.2018

Cost Repostings Report COPS R.Dec.2018 connection between Tableau Server and the SMIS reporting database Tableau R.Oct.2018

COPS Additional Functions COPS R.May.2019

GRC to Tableau Interface for User Provisioning Security R.Dec.2018

GRC to BW Interface for HANA User Setup Automation Security R.Dec.2019

FedTalent to GRC Interface for Training Data Security R.Oct.2018

Reporting Favorites App - 'My Reports' Portal R.Dec.2018

Bureau Report app - 'My Bureau Reports' Portal R.Dec.2018

FedTalent Training Report Security R.Nov.2018

Business Entity Personas Flavors RP R.May.2019

Building Personas Flavors RP R.May.2019

Property Personas Flavors RP R.May.2019

Rental Object Personas Flavors RP R.May.2019

COPS - Verification of Costing Sheets COPS R.Jul.2019

COPS - Allocation Cycle Automated Loader COPS R.Jul.2019

Connection Between Tableau and IMARS Tableau R.Jul.2019

Connection Between Tableau and Remedy Tableau R.Jul.2019

EIR - Connection Between BW and CAMPPROD EIR R.Sep.2019

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

EIR - Connection Between BW and MTS EIR R.Sep.2019

Charm Dashboards BW R.Jul.2019

Down Payment Request Reversal Date FMGL R.Jul.2019

CP2100 Process AP R.Jul.2019

Transmit Approved Application Service AFA R.Apr.2019

Vendor Lookup Service AFA R.Apr.2019

PR Lookup Service AFA R.Apr.2019

Award Service AFA R.Apr.2019

PCS RITA Submission and Unclaimed TRAVEL/PCS R.Dec.2019

Tableau connection to AQD/BEAR Tableau R.Dec.2019

Tableau connection to OHR/HRIS (Human Resources Information System) Tableau R.Dec.2019

BW connection to FWS Datamart BW R.Jan.2019

AQD/BEAR - Web Services from FBMS BW to AQD/BEAR BW R.Nov.2019

SOD Matrix Report Security R.Dec.2019

Enhancement for line item browser FMGL R.Nov.2019

Manage Lease Obligation Fiori app RP R.Oct.2019

FPDS-NG - Atom Feed From DATA.gov BW R.Jan.2020

GS to BW data load BW R.Jun.2019

GrantSolutions User Master Data Report Security R.Apr.2019

PILT Application FMGL R.Mar.2020

Bin Label Output Form WM R.Jun.2020

Transfer Order Output Form WM R.Jun.2020

Contracts from FBMS to DOIAccess Tableau R.Apr.2020

Custom SPL Correction Utilities FMGL R.May.2020

Set Monitoring Report Security R.Jul.2020

BW-NPS RecFee Interface BW R.Dec.2020

BW-BASIS+ Interface BW R.Aug.2020

FBMS Data to IPP BOT AP R.Oct.2020

IPP Invoice Recon BOT AP R.Oct.2020

Business Entity: Standard View RP R.Jul.2020

Building: Standard View RP R.Jul.2020

Land: Standard View RP R.Jul.2020

Rental Object: Standard View RP R.Jul.2020

Business Entity: Basic View RP R.Jul.2020

Building: Basic View RP R.Jul.2020

Building: FRPP View RP R.Jul.2020

Building: Energy View RP R.Jul.2020

Building: Asbestos View RP R.Jul.2020

Land: Basic View RP R.Jul.2020

Land: FRPP View RP R.Jul.2020

Rental Object: Basic View RP R.Jul.2020

Rental Object: iQMIS View RP R.Jul.2020

Rental Object: Quick Funding RP R.Jul.2020

Building: Quick Release RP R.Jul.2020

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Payroll Fixed Cost BW R.Dec.2020

BW-NPS RecFee Interface BW R.Dec.2020

BW-BASIS+ Interface BW R.Aug.2020

The Closer Bot Acq R.Dec.2020

ECC Data to Closer Bot Acq R.Dec.2020

BW Data to Closer Bot Acq R.Dec.2020

Enable TP GTAS Fields on SD orders with follow on documents FMGL R.Jan.2021

DARTS Webservice BW R.May.2019

SAP to xECM Interface to create Users Security R.Dec.2020

Fiori Usage Data Security R.Dec.2020

Fiori User and Role Data Security R.Dec.2020

Fiori Tiles and Groups Data Security R.Dec.2020

GrantSolutions UAM Reconciliation Report Security R.Dec.2020

GrantSolutions UAM interface Security R.Dec.2020

FPPS to GRC Interface Security R.May 2020

Intra DOI Agreement ACQ/SD/AP R.Dec.2020

PILT Calculation Tool FMGL R.Mar.2021

Distribution of Receipts AR R.Feb.2021

FBMS4ALL User Status Report Security R.Mar.2021

Content Server xECM User and Group assignment report Security R.Mar.2021

Payment in Lieu of Taxes (PILT) Calculation Report BW R.Mar.2021

Add Period of Performance(PoP) dates to earmarked documents. RP R.May.2021

Special Ledger Carryforward enhancement FMGL D5

BTFA and FBMS Tableau interface Tableau R.OCT.2021

IDA Header List Report ACQ/SD/AP R.Jul.2021

DATA Act Bot RPA R.Aug.2021

External Portal GRC Interface Portal R.Nov.2022

External Portal User Activity Report Portal R.Nov.2022

OpenText Content Server Workspace Detail Report ACQ R.May.2022

Sales Order Modification for GINV GINV R.OCT.2022

Fleet RPA RPA R.Jan.2022

Enhancement to Enable Parking in FBS1 FMGL R.Jul.2022

Small Business Goaling Data RPA, aka 'OSDBot' ACQ R.Jun.2022

Modifier Bot ACQ R.Oct.2021

PALBot PGM R.Feb.2023

POB Bert Data File Labor R.Jan.2023

PO Discrepancies PO Cleanup NA

Unsupported MO's PO Cleanup NA

Aviation Workorder Cleanup Aviation NA

Travel/PCS Obligations and Advances - Data Cleansing PO Cleanup NA

Duplicate Federal Suppliers - Data Cleansing BPI Team NA

IPP Recon Bot Part 1 AP R.Oct.2023

EPIB Bot Security R.Jan.2024

PR Conversion AFA S4

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Business Partner ALL S4

SES Conversion AFA S4

Funded Program FMGL S4

Labor Tables LB S4

Charge Card Tables for Existing Invoice Data CC S4

Travel/PCS Conversion - ZTR tables T/PCS S4

FRPP, FAST and Greenhouse Gas Conversion FL/RP/EN S4

Equipment master shells FL S4

GSA Rent conversion - history AP/AR S4

AP Down Payments AP/T/PCS S4

IPP Custom Tables Conversion AP S4

Convert FMFEE History AR S4

Investment documents - FMV1 AR S4

MDG Groupings and Hierarchies MDG S4

Aviation AUR Conversion AV S4

Aviation Pricing Conditions AV S4

Inventory Management Batch Conversion IM/WM S4

FBMS Vehicles Justifications Data Conversion (NPS only) FL S4

GrantSolutions Application Conversion AFA S4

Energy Custom Fields for RE Objects EN S4

PRISM Data Transformation AFA S4

Marking PO Lines Complete AFA S4

Periodic Reposting and Distribution Cycle Upload COPS S4

Planned Costs Upload COPS S4

Expense Transfers for Reimbursable AUC Costs FMGL S4

Add PMS Field to Fund FMGL S4

Mass Transfer of Assets Assets S4

Mass Change of Assets Assets S4

Mass Retirement of Assets Assets S4

Disposal of RP Assets Assets S4

Miscellaneous Obligation App Assets S4

Enhancement for PMS Logic - Invoice AP S4

Enhancement for ALC/PMS Logic - Billing document SD S4

Populate PMS on Accounting Documents AR S4

Mass Upload of License Plate Records FL S4

Fleet Utilization FL S4

Real Property Asset Identification Assets S4

Customer Create Request App BPI/AR S4

Vendor Create Request APP BPI/AP S4

File upload/download App Portal S4

Terms and Conditions Portal S4

GSA Repairs Fleet S4

Funds Availability Check FMGL S4

Fill Business Area from Non-FI Transactions FMGL S4

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

Funded Program Group Automation FMGL S4

Legacy CF Master Data Validation FMGL S4

General BP Request App BPI S4

MDG BP Request Management App BPI S4

Business Partner Security Enhancements BPI S4

Extend Fiori App F3118 - Master Data Process Overview - Business Partners BPI S4

Extend Fiori App F3141 - Change Request Analysis for Business Partner BPI S4

Extend Fiori App F4809 - Analyze Completed Work Items BPI S4

Extend Fiori App F4752 - Monitor Open Work Items BPI S4

Personas Enhancement for HTML GUI Step Loop UX S4

ZBUDGET Upload Enhancement FMGL S4

G-Inv Purchase Order Processing with SAP HUB GINV S4

Inbound GINV Invoice processing in AIF GINV S4

G-Inv Order and Attachment Relevance for Sales Orders GINV S4

MyInbox Fiori App Extension Portal S4

HRMM Persona Flavors HRMM S4

Add Additional Fields to Balance Carryforward FAGLGVTR FMGL S4

Derivation Tool Enhancement for SF-224 and CARS FMGL S4

Redesign News and Notifications Portal S4

Redesign Switch Bureau functionality Portal S4

SAP GUI Connector for FES Portal S4

Custom Portal IdP Extension Portal S4

Real Property Disposal Discrepancy Report RP S4

Analytic Report for Mass Asset Transaction Assets S4

Trading Partner relevance report GINV S4

G-Inv Performance Discrepancy Report GINV S4

G-Inv Servicing Orders Discrepancy Report GINV S4

BW ZLABOR_TIME load LB S4

PPDR Asset Reporting Assets S4

BIO only Travel Information T/PCS S4

Merge: General AP Query v2 S4

AP Days Overdue Analysis (Net Due Date) Report S4

HQ Fund Status Summary S4

Workflow Report S4

Purchase Order History (GR.IR) Report S4

IPP Invoice Status Report and ZIPP Invoice Table S4

Unliquidated Obligation Report S4

Merge: AR General Detail Data S4

Merge: Fund Status Summary S4

Merge: General PS Query S4

Merge: General SD Query S4

Merge / New: High Level Reimbursable Agreement Query S4

Merge: Billing Documents By Sales Order S4

Merge: CITI and JPMC data in single report and TA number against trips S4

Attachment 2A ‐ FBMS Development Objects

Title Functional Area Deployment

ZLABOR_TIME Table Data S4

Merge: SPL Summary Trial Balance Rpt (Historical Multi-Year) S4

Merge: Cost Postings Report S4

Merge: Cost Summary Report S4

Merge: SGL - Year Comparision Report S4

Merge: Budget Execution From Inception S4

Merge: Contract Detail (PRISM & ECC data) S4

Merge: PO History (ECC only) S4

Merge: Obligation Query (including ALL obligation types) S4

Merge: Historical PR Query S4

Merge: Work Order Details S4

Merge: FA SAP-PRISM Sync Report S4

Merge: FA Grant Detail View S4

Merge: FA Grant Transactions View S4

Merge: FA Version History FY21 Onwards (HANA View) S4

Merge: FA SAP GS Header Sync View (HANA View) S4

Merge: FA SAP GS Line Sync View (HANA View) S4

Merge: FA Grant Detail Query - WFAM08_SK_Q004 S4

Reduce the Footprint Report (RTF) S4

Merge FRPP Disposed Report (BWRPT600 ??) S4

Merge FRPP Report (BWRPT600 ??) S4

Merge: Government Furnished Housing Collections Report S4

Merge: Cash Flow w/FM S4

Change Log Data Request S4

Potential Duplicate Invoice Report S4