PeopleSoft FSCM Update Image 37 was recently released, and it contains a long list of helpful new features. Some of the highlights from the new Image update include:
- COVID-19 Features for General Ledger and Inventory
- Kibana Visualizations for Contracts and General Ledger
- Run Control Management
- Delegation Framework for Purchasing and Supplier Contract Management
- eProcurement Features
- eBill Customer Hierarchy
- Email Notification for Treasury WorkCenter
- Purchase Order Acknowledgment for Buyer
- Accounting Tags in Expenses
- Close Period by Journal Source
- Project Template Status
- Asset Management Features
- Additional Features
PeopleSoft FSCM Update Image 37 Highlights
COVID-19 Features for General Ledger and Inventory
COVID-19 features in PeopleSoft FSCM Update Image 37 include:
- General Ledger Enhancements to GTAS and DATA Act
- Inventory Partial Item Substitution and Inventory Counts by One User Defined Field
General Ledger enhancements include reporting the Disaster Emergency Fund Code for GTAS and DATA Act.
PeopleSoft Inventory enhances the manual count process by allowing you to select one of the user-defined fields as search criteria when creating a counting event. The Item Selection window displays the items that match the specified criteria. Use the Item ID and Description fields to narrow the item list. You can select individual or multiple items. If there’s an inventory shortage, the material reservation process searches for one or more substitutions items in priority order until the demand is met. If there is unfulfilled quantity, a backorder is created based on the reservation rule.
Kibana Visualizations for Contracts and General Ledger
Kibana Visualizations for Contracts
The Customer Contracts homepage now includes contract analytics using Kibana visualizations – providing insight into the number, size, and duration of your active contract base.
The Contract Analytics dashboard targets active contracts, identifies lines of business, schools, and areas of research that are expanding, and others that are shrinking. You can filter the dashboard to a specific area of the organization by clicking on a particular business unit, region, or individual contract administrator.
The two remaining duration visualizations identify the average duration and remaining days left on your contracts. They show where contract terms are changing and which customers and agencies are issuing longer contracts. Other visualizations compare contract backlog and future cash flow across lines of business.
This tag cloud displays the 30 largest contracts started in the last 30 days. The All Active Contracts visualization provides contract details in a grid format.
Kibana Visualizations for General Ledger
The Financial Position Trending and Financial Performance Analysis Kibana dashboards help organizations analyze their financial position and performance. The General Ledger Operational Insights dashboard allows you to analyze operational performance.
Use the Financial Position Trending dashboard to analyze the financial position of transactions within a selected timeframe. This dashboard provides visual understanding of trends and patterns for financial transactions. It also displays top-performing accounts. You can drill down into five levels of account tree data and three levels of department tree data for detailed analysis. The Financial Position Trending dashboard displays 12 months of data and provides drill-down capabilities. Actual, posted, and unposted journals are included, and statistical journal entries are excluded.
The Financial Performance Analysis dashboard provides insight into the yearly financial performance of a business. You can select a base currency, a ledger, or a business unit to compare the financial balances among the fiscal years selected. Use controls to slice and dice the ledger index. Date and time ranges are not used. Closing journals are filtered, and statistical journal entries are excluded.
The General Ledger Operational Insights dashboard provides journal volume trends. You can filter data based on the header business unit. The dashboard focuses on all journal transactions created in the last 12 months. Statistical journal entries are excluded. This dashboard also includes journals across date and time entered and journal count by status for top 20 users’ visualizations.
Run Control Management
FSCM provides a new Run Control Delete Framework with FSCM Update Image 37. This framework allows you to delete run control IDs that are no longer used. You can view existing run control delete requests and take action such as editing or deleting requests. You can also add new requests. Select individual rows to view a delete request summary. You can also update Delete Request details if it hasn’t been submitted for deletion.
On the Run Control page, add user IDs for run control data that needs to be deleted. Users can only delete their own run controls while administrators can delete run controls created by any user. Select run control components with run control data that needs to be deleted. Use the Review and Delete page to review and delete the selected run control data. Review the processing details for the deleted run control data.
The Run Control Delete page lists the Delete Request status as submitted until the processing is complete.
Delegation Framework for Purchasing and Supplier Contract Management
The Delegation Framework allows you to choose a proxy who can approve certain transactions on your behalf. Purchase orders and supplier contract management documents and clauses are now available for this feature. PeopleSoft FSCM plans to add more transactions in future Images.
eProcurement Features
In FSCM Update Image 37, PeopleSoft procurement enhances the following features:
- Search option on the Browse Catalogs page
- Price adjustments at schedule level
- Substitute item visibility on the search results and Line Details page
- Advanced contract search option on the Line Details page
- Receive requisitions for all Ship To’s
- Invoice Number on Manage Requisition and Purchase Order Inquiry pages
- Amount Only option on the Special Requests and Checkout pages
With the new search option on the Browse Catalogs page, you can search for an item across all categories or a specific category such as catalog, favorites, templates, and web suppliers.
View price adjustments for a schedule by clicking the Price Adjustments icon on the Schedule Detail page. It shows how the current price of the item is calculated.
If substitutes exist for an item, search results display the substitute item link. The Substitute Items window displays all of the substitutes defined for the original item. When you have substitute items defined for the original item, the Line Details page displays the Substitute Item Search option. The Substitute Items window displays the original item and its substitute. Also, you can manually override the auto-substituted item if setup allows.
Use the Contract Search option on the Line Details page to add contracts to the requisition line.
The Receive All Ship To (RECV_ALL_SHIPTO) role action allows a casual user to receive all requisitions for all Ship To’s. Users assigned to this role action can view the Ship To column on the Receive Items page.
The Invoice Number field is available on the Manage Requisition and Purchase Order Inquiry pages.
The Amount Only option is available on the Special Requests and Checkout pages. Select this option to indicate a requisition line is Amount Only. On the Special Request page, you can view the Amount Only option if the requester has the Amount Only Special Request role action assigned and enabled. The Checkout page displays the Amount Only option only if the requester has the Amount Only Lines role action assigned and enabled.
eBill Customer Hierarchy
In PeopleSoft FSCM Update Image 37, the Fluid eBill Payment Customer hierarchy allows you to visualize the Customer Hierarchy chart, analyze current balances, and view related invoice information for customers. It’s similar to the Classic version but with the added advantage of PeopleSoft Fluid technology including mobile access from your tablet and the ability to analyze customer invoice information.
Use the Related Actions dropdown next to a customer to view statements, account summary, invoice, and invoice to pay information for that customer. The invoice balance links allow you to drill into customer invoice information. Use the Overdue Balance link to view and analyze customer overdue balance information. Use the Account Balance link to view and analyze customer account balance history. Use the Account Balance Rollup link to view and analyze rollup account information by customer.
Email Notification for Treasury WorkCenter
You can now send email notifications for transactions using the Fluid Treasury WorkCenter on the Treasury WorkCenter page. Use the Related Actions menu to access the Email Notification page. You have to set up the Email Notification Framework to view the Email Notification page. You can notify one or more users of an action they need to take for one or more transactions. The system adds the email text based on the transaction selected on the WorkCenter page. You can decide which fields to display in the email notification.
Purchase Order Acknowledgment for Buyer
In FSCM Update Image 37, PeopleSoft Purchasing enhances the Purchase Order Acknowledgment process by adding the Purchase Order Acknowledgment History tiles to the Procurement Operations homepage.
The PO Acknowledgments page lists both the online and EDX purchase order acknowledgments routed to a buyer. To streamline the review process, only purchase orders with changes are displayed by default. Additional filters are available to narrow search results. Select a purchase order acknowledgment to review its details and proceed with appropriate actions. You can view a supplier’s response by selecting a purchase order line in the left pane. Changed fields are highlighted – making the review process much quicker. The page allows you to perform different actions like view the purchase order document, enter or view supplier comments, view header information, reset to purchase order values, reject lines, and more. If the modifications are acceptable, you can proceed with approving the purchase order.
The Purchase Order Acknowledgment History page lists the acknowledged purchase orders. Select a purchase order to view its historical acknowledgment information.
Accounting Tags in Expenses
In FSCM Update Image 37, PeopleSoft Expenses added the use of accounting tags for the Fluid user interface (UI). Accounting tags are a quick way to populate the correct ChartField segments into expense report and travel authorization accounting lines, and they ensure that users populate accounting information with correct data for quicker approval and payment processing.
Close Period by Journal Source
Journal source security restricts access to users based on the permission added to the user or role for a specific journal source. This functionality also restricts journal posting during period end based on the defined cutoff schedule. You must have access to the journal source to create or edit journals. The journal sources available for selection are based on your defined user access.
To apply journal source security to setIDs, add them using the Journal Source Security by SetID page. To enable journal source security for business units, use the Journal Source Security by BU page. Then, provide users with journal source access for the business unit and source combination using the Journal Source Security by User page. After selecting the user, choose the business unit to provide source access. Finally, provide journal source access to specific roles on the Journal Source Security page. Then, add the business unit. This allows you to restrict access to users based on the defined permissions for a specific journal source associated with the user or role.
This functionality also restricts journal posting during period end processing based on the defined cutoff schedule. Define a period end cutoff schedule for a particular business unit, ledger, and fiscal year on the Period End Cutoff Date Definition page. Journal sources associated with the business unit that has a cutoff schedule are populated from the Journal Source Security Business Unit page. Journals can’t be posted if the cutoff date is past the date defined on the Period End Cutoff Definition page for the selected journal source. Because the journal post date is after the defined period end cutoff date, the system doesn’t allow you to post the journal.
Project Template Status
In PeopleSoft FSCM Update Image 37, you can now activate or deactivate a project template. When creating a new project from a template, filters are applied to include only active project templates. Use the Update Project Template Status pagelet to update the status for multiple project templates en masse as a single action. Select “Refine Filter Criteria” to narrow the list of project templates with end dates from the past.
Asset Management Features
Asset Physical Life Enhancement
Asset Management and Maintenance Management enhance physical life tracking for an asset. Use the Physical Life Information section of the Manufacture/License/Custodian page to track the physical life of an asset, determine the life expectancy of equipment, and plan for equipment replacement.
The replacement date displayed the estimated date that the asset should be replaced. The life expectancy percent displays the current age of the asset expressed as a percent of total life expectancy. The physical life fields are part of the Asset Basic Ad component, but they’re also available in the Define Asset Operational Information component.
Spreadsheet Data Import Enhancement
The Import Data by Spreadsheet process allows you to enter asset transaction data offline using a spreadsheet application and then import the transaction data into Asset Management tables. To accomplish this, PeopleSoft Asset Management delivers spreadsheet templates that provide the framework and fields necessary to generate the required spreadsheet CSV file. With FSCM Update Image 37, Asset Management adds two ned spreadsheet templates:
- Transfer Assets
- Asset Cost Adjustment by Amount
Use the Transfer Assets template to transfer ChartFields.
Use the Asset Cost Adjustment by Amount template to adjust asset cost by amount.
On-Hand Items Actuals Enhancement
Maintenance Management enhances the Cost Summarization process to identify on-hand purchasing actuals. The On-Hand Indicator allows you to determine the non-inventory items currently available for completing work order tasks.
Additional Features
Additional features added in PeopleSoft FSCM Update Image 37 include:
- PeopleTools enhancements to the Ledger Balances Analysis, Account Reconciliation, and Receivables pivot grids
- The ability to restart the BI Publisher process
- Adherence to legislative changes to India GST for 2020 in Billing, Receivables, and Payables
- The ability to correct a project status
To learn more about PeopleSoft FSCM Update Image 37, check out the video below. You can also find information through the Cumulative Feature Overview (CFO) tool, the Update Image Overview on My Oracle Support, or go to the PeopleSoft Information portal for updates.
Additional Resources
Join us next month for Quest Experience Week (QXW) as Quest celebrates its 25th anniversary with a FREE week of digital learning! QXW offers four jam-packed days of practical Oracle product learning for users of JD Edwards, PeopleSoft, Oracle Cloud apps, and Oracle Database solutions. There’s something for everyone: strategic insights, practical product how-to sessions, customer case studies, and best practices.