Spreadsheet Upload Error Handling (120.1.2)
- 29 Aug 2024
- 5 Minutes to read
-
Print
-
DarkLight
-
PDF
Spreadsheet Upload Error Handling (120.1.2)
- Updated on 29 Aug 2024
- 5 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Business Process Overview
Spreadsheets are uploaded directly into Florida PALM by Agency users with appropriate Florida PALM module roles. Once spreadsheets are uploaded, users may review the results including any transaction errors in the Report Distribution Manager.
Business Process Diagram
Business Roles
The Business Process Flow Diagrams use horizontal swim lanes to depict where activities are performed by different parties or systems. Each swim lane is titled with a role, either agency-based or within DFS, and in some cases, are representative of an external entity or system. The swim lanes may change from page to page within a single business subprocess as more or fewer roles are required to execute sections of the business subprocess.
- Spreadsheet Upload Interface Validation: System role that loads and processes interfaces.
- Agency Module Processor: Various agency roles in Florida PALM modules that process transactions through spreadsheet uploads and resolve errors.
Business Process Flows Details
The tables below describe steps in each business subprocess as reflected on the Business Process Flow Diagrams. The tables also reflect information associated with each step describing the intent of the specific process. Florida PALM screenshots are included within the sections to allow connections to be made from specific business subprocess steps to screens within Florida PALM. This information should be read in conjunction with the Business Process Flow Diagrams. This information should be read in conjunction with the Business Process Flow Diagrams.
Process Step ID | Process Step Title | Description of Process |
|---|---|---|
1 | Spreadsheet Upload | The Agency Module Processor generates the Spreadsheet Upload file and uploads into Florida PALM using the applicable custom run control page. |
2 | Perform Key Field Validations | Key interface fields are validated. Errors during this step are considered Hard Errors and will be written to the error log. Records with hard errors must be corrected and resubmitted for processing in a new interface file or entered manually in Florida PALM. |
3 | Perform ChartField/Combo Edit Validations | ChartFields and ChartField Combination Edits are validated. Errors during this step are considered hard errors. Valid transactions will continue to the next step while hard errors must be corrected and resubmitted for processing. Hard errors will be listed in a log and error file for review. Please see 10.1 Set Up and Maintain Chart of Accounts for more information on valid ChartFields and ChartField combination edits. |
4 | Load Inbound Transactions to Staging Tables | Transactions are loaded to Florida PALM staging tables. The transactions will remain in the staging tables until processed by delivered Florida PALM functionality. |
5 | Load/Validate Transactions from Staging to Final | Transactions are validated and will be loaded to the transaction tables if no Soft Errors are present. Transactions with soft errors will remain in the staging tables and will be marked in error. Agency Module Processors will be able to review and correct most errors utilizing a WorkCenter page. PeopleSoft WorkCenters are designed to allow users to access their most used reports, queries, pages, and processes in a single location. |
6 | Continue Processing | All transactions that pass validations will continue processing and be loaded into the final transaction tables. |
7 | Review Error Log from Florida PALM Report Distribution Manager | Hard Errors will be captured in the error log, which will be available for Agency Module Processors to review through the Report Distribution Manager page. |
8 | Create Manual Entries | Agency Module Processors may choose to create transactions directly in Florida PALM to correct transaction errors. |
9 | Create Corrections in Spreadsheet Upload Template | The Agency Module Processor may make corrections and generate a supplemental Spreadsheet Upload file containing only the corrected records. |
10 | Review/Resolve Transaction/Data Errors | Pages and reports are available to Agency Module Processors which will aid in the review and correction of soft errors. If the transaction is no longer needed the transaction can be deleted. |
Accounting Events
Accounting events originate during transaction processing in the applicable source module. The accounting events impact the source module, Commitment Control ledgers, and the General ledger (Actuals).
- Source Module accounting entries require user input (I) of the primary line (i.e., expenditure, revenues) with an automated (A) system offsetting line (i.e., payable, receivable) during transaction entry. The source model transaction must pass Edit Check, Budget Check, and Cash Check (on applicable entries) prior to posting the transaction.
- The Run Budget Check (Commitment Control) process automatically affects balances in the appropriate budget ledger (i.e., appropriation, spendable cash) if the transaction passes the budget check process.
- After the transaction is posted in the source module, an automated system process summarizes and posts the entries in the General Ledger module to the Actuals Ledger.
The table below provides the most common accounting events applicable to this business process.
Acct Event ID | Accounting Event | Commitment Control Ledger(s) Impact | Source Module Accounting Entry | General Ledger (Actuals) Entry |
|---|---|---|---|---|
N/A |
Reports
Key Reports are displayed as icons with the Report Number on this Business Process. The table below provides the reports identified to be produced at a particular process step or is used to support the completion of a process step.
Report Number | Report RICEFW ID | Report Description | Report Source | Report Frequency | Audience |
|---|---|---|---|---|---|
R1 | APR125 | Budget Check Errors – A report in the WorkCenter used to display a list of vouchers with budget check errors. | PeopleSoft | Periodic | DFS, Agency |
R2 | APR126 | Cash Check Errors – A delivered report used to review Revenue Estimate budget checking errors. | WorkCenter | Periodic | Agency Module Processor |
R3 | ARR022 | Revenue Estimate Exceptions – A delivered report used to review Revenue Estimate budget checking errors. | WorkCenter | Periodic | Agency Module Processor |
R4 | ARR029 | Direct Journal Budget Exceptions – A delivered report used to review Direct Journal budget checking errors. | WorkCenter | Periodic | Agency Module Processor |
R5 | ARR065 | Posting Errors – A delivered report in the WorkCenter used to display pending items containing errors, with access to Online Error Correction pages. | WorkCenter | Periodic | Agency Module Processor |
R6 | ARR067 | Direct Journal Accounting Entry Errors – Used to correct Direct Journal accounting entry edit errors. | WorkCenter | Periodic | Agency Module Processor |
R7 | CMR011 | Accounting Errors – Summary listing of accounting errors. | WorkCenter | Periodic | Agency Module Processor |
R8 | GLR139 | Journals with Errors - Journals with any type of error that requires action. | PeopleSoft | Periodic | DFS, Agency |
R9 | GLR140 | Journals with Edit Errors - Journals specifically with edit errors that require action. | PeopleSoft | Periodic | DFS, Agency |
Interfaces
The table below provides the Interfaces identified on the Business Process.
Interface Number | Interface Description | Interface Frequency | Source | Target |
|---|---|---|---|---|
Forms
The table below provides the forms identified on this Business Process.
Form Number | Form Description | Audience |
|---|---|---|
N/A |
Workflows
The table below provides the workflows identified on this Business Process.
Workflow Number | Workflow Description | Audience |
|---|---|---|
N/A |
Version History
Date | Revision Description |
|---|---|
12/22/2023 | Original Version |
Was this article helpful?
