Loading Data into the Budget Interface Table
Before you run Budget Upload, you must first transfer your spreadsheet to your server. The procedure to follow depends on the software you use.
Optionally, you can use a spreadsheet application to create your budget, then use Oracle Glue or Dynamic Data Exchange (DDE) to populate GL_BUDGET_INTERFACE.
To transfer budget information from your spreadsheet:
1. Save the budget spreadsheet in ASCII format.
For example, if you work with Microsoft Excel (version 5.0), choose File>>Save As from the main menu to create an ASCII file (Formatted Text, Space Delimited) from your spreadsheet. Your file will have .PRN as its extension.
2. Use a file transfer program to move the file from your PC to the server (where Oracle is installed).
3. Use SQL*Loader to move information from file to the Budget Interface table (GL_BUDGET_INTERFACE). SQL*Loader is provided as part of the Oracle RDBMS. You need to create a control file (e.g. budget.ctl) and use it with SQL*Loader to load the data from your .PRN file to the Budget Interface Table. Use the following command to run SQL*Loader:
sqlload <username/password> <control_file>.ctl <log_file>.log
where <username/password> are the username and password of the database where you are loading the data, <control_file>.ctl is the control file you created (e.g. budget.ctl) and <log_file>.ctl is a log file that contains any messages of the SQL*Loader process.
4. Once you have successfully loaded the Budget Interface table, use Budget Upload to update budget balances.
See Also
Uploading Budget Amounts to Undefined Accounts
Understanding the Budget Interface Table
About Budget Upload Validation
Uploading Budgets