My Oracle Support Banner

E1: 14: Overview of Budget Upload (P0902Z1/R14110M/R14110/R0902ZP) (Doc ID 1466147.1)

Last updated on JULY 20, 2021

Applies to:

JD Edwards EnterpriseOne General Ledger - Version XE and later
Information in this document applies to any platform.

Purpose

Overview

Budgeting provides a projection of future expenses and revenues. Using budget history, you can compare actual amounts to your projections and use the information to improve your budgeting process. Per the current functionality, there are two methods for uploading budgets in EnterpriseOne General Accounting system as outlined below:

Method Steps
Import budgets from a spreadsheet
  1. Prepare the spreadsheet for the budget data.
  2. Import budget data using the Upload/Conversion Revisions program (P0902Z1).
  3. Review and revise imported data.
  4. Upload budget data to the Account Balance (F0902) table by running R14110 program.
  5. Purge processed records by running Processed Upload Purge program (R0902ZP).
Import budgets from a text file
  1. Copy budget data to a text file.
  2. Convert the data by running the Budget Import Field Mapping program (R14110M).
  3. Review and revise imported data.
  4. Upload budget data to the Account Balance (F0902) table by running R14110 program.
  5. Purge processed records by running Processed Upload Purge program (R0902ZP).

 

NOTE: The two methods look quite identical as the last three steps for both methods are the same. The difference between the two methods is how you import the budget data into the EnterpriseOne tables.

Scope

This document is intended for Finance Functional users who will be involved in Budgeting in the General Accounting system.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Overview
Scope
Details
 Process
 Importing Budget Data from Spreadsheets (P0902Z1)
 Overview
 Setup
 Importing the Budget Data
 Importing Budget Data from Text Files (R14110M)
 Overview
 Setup
 Reviewing the Report
 Revising Imported Budget Data (P0902Z1)
 Uploading Budget Data to the F0902 Table (R14110)
 Overview
 Program Functionality
 Setup
 Reviewing the Report
 Common Error Messages
 Purging Processed Records in the F0902Z1 Table (R0902ZP)
 Overview
 Setup
 Reviewing the Report
 Frequently Asked Questions
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.