Data Loader commands

Data load is a powerful tool for uploading the data into the application. There is no technical knowledge to use this tool.

This tool is most commonly used for inserting the values into the VALUESET and CALENDAR CREATION etc

Following are the keys are helpful for using the dataload

TAB      Press the Tab key

ENT      Press the Enter key

*UP      Press the up arrow key

*DN      Press the down arrow key

*LT       Press the left arrow key

*RT       Press the right arrow key

*SAVE  Save the current record

*SP      Save & proceed

*FE       Open the field editor

*PB      Navigate to the previous block

*NB      Navigate to the next block

*PF       Navigate to the previous field

*NF       Navigate to the next field

*PR      Navigate to the previous record

*NR      Navigate to the next field

*IR        Insert a new record

*CL       Clears the form field but does not delete any data

*ER      Clears a record from the form fields but does not delete it

*DR      Delete the current record

*FR       Navigate to the first record

*LR       Navigate to the last record

*SB      Press the Spacebar. This is useful for toggling the setting of radio buttons and check boxes instead of using the mouse.

*ST       Select the entire field

*FI        Open the find window

*FA       Find all records

*QE      Put the form in to the query enter mode

*QR      Run a query when the form is in query enter mode

*BM      Open the block menu. This is used in Oracle E-Business to select the block or tab to which to navigate.

*AX      Sends the Alt + X keystroke where X is a single letter (A-Z).

Note : In most applications the menus, buttons and other controls can usually be activated by using the Alt key combined with one other key. DataLoad provides *AX so that all possible Alt key combinations are available as a DataLoad command.

Built-in Commands

The following commands are built-in to DataLoad to provide additional functionality beyond sending data and keystrokes to applications. These commands cannot be edited or replaced in the commands window. The built-in commands are listed in the following table. Where available, please click the link on the command name for more information about using each command.

*SLN or *SL(N)      Pause the load for N seconds

*CW(window)        Change to window window

*ML(coordinates)    Position the mouse at coordinates and press the left button

*MR(coordinates)  Position the mouse at coordinates and press the right button

*DL(coordinates)  Position the mouse at coordinates and double click the left button     

PROMPT(message)   Prompt the user with message and wait for a response     

PHP(function)   Calls a PHP function when Scripting used with a Macro load

The following keys can be used to edit, control and navigate around the spreadsheets:

CTRL + A	Selects the entire spreadsheet
CTRL + C	Copies the selected cells
CTRL + D	Uses the Fill Down command to copy the topmost cell of a selected range in to the cells below
CTRL + F	Opens the Find window
CTRL + H	Opens the Replace window
CTRL + N	Creates a new, blank load
CTRL + O	Displays the Open window to open a new file
CTRL + S	Saves the current load
CTRL + T	Opens the column setup window
CTRL + V	Pastes data from the Windows clipboard
CTRL + X	Cuts the selected cells
F1	Displays the DataLoad User Guide
F2	Opens the current cell for editing
ARROW KEYS	Move one cell up, down, right or left in the spreadsheet CTRL + ARROW KEY moves to the edge of the current data region in a spreadsheet CTRL +SHIFT + ARROW KEY extends the selection of cells to the last non blank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next non blank cell.
BACKSPACE	Clears the content of the active cell. In cell editing mode, it deletes the character to the left of the insertion point.
DELETE	Clears the content of the active cell. In cell editing mode, it deletes the character to the right of the insertion point.
END	Moves to the last cell in the current row. If SHIFT is also depressed the selection is extended to the last cell in the current row. CTRL + END moves to the last cell in the spreadsheet. If SHIFT is also depressed the selection is extended to the last cell in the spreadsheet.
ENTER	Takes the current cell out of edit mode, if required, and moves the active cell down by one row. ALT + ENTER inserts a new line in the current cell, allowing multi line editing within cells. ALT + ENTER also puts the long cell edit box above the spreadsheets in to multi line mode but in that area new lines can then be inserted using just ENTER without the ALT key.
ESC	Cancels cell data entry and takes the cell out of edit mode.
HOME	Moves to the first cell in the current row. If SHIFT is also depressed the selection is extended to the first cell in the current row. CTRL + HOME moves to the first cell in the spreadsheet. If SHIFT is also depressed the selection is extended to the first cell in the spreadsheet.
PAGE UP	Moves one page up in the spreadsheet. SHIFT + PAGE UP moves one page up in the spreadsheet and extends the selection CTRL + PAGE UP moves to the topmost cell that is currently visible SHIFT + CTRL + PAGE UP extends the selection to the topmost cell that is currently visible ALT + PAGE UP navigates to the previous spreadsheet, i.e. from the footer to main to header spreadsheets
PAGE DOWN	Moves one page down in the spreadsheet. SHIFT + PAGE DOWN moves one page down in the spreadsheet and extends the selection CTRL + PAGE DOWN moves to the bottom most cell that is currently visible SHIFT + CTRL + PAGE DOWN extends the selection to the bottom most cell that is currently visible ALT + PAGE DOWN navigates to the next spreadsheet, i.e. from the header to main to footer spreadsheets
TAB	Moves to the next cell in a spreadsheet SHIFT + TAB moves to the previous cell in a spreadsheet

  

what are GL enhancements in R12

Security

You can secure your setup and definitions by granting specific privileges to users to view, modify, and/or execute a definition. This enables you to control which of your users can view a definition, but not modify or execute it, or execute a definition without modifying it, or vice versa.

Following is a list of definitions that have this security available for:

1.    MassAllocation and MassBudget Formulas

2.    FSG Reports and Components

3.    Accounting Calendars

4.    Transaction Calendars

5.    AutoPost Criteria Sets

6.    AuoReversal Criteria Sets

7.    Budget Organizations

8.    Chart of Accounts Mappings

9.    Consolidation Definitions

10.  Consolidation Sets

11.  Elimination Sets

12.  Ledger Sets

13.  Recurring Journals and Budget Formulas

14.  Rate Types

15.  Revaluations

Integrated Web-based Spreadsheet Interface

Through the integration with Web ADI, users can now leverage spreadsheet functionality in Oracle General Ledger via a web-based interface. The spreadsheet interface can be conveniently launched from a GL responsibility.

Using the Journal Wizard, we can leverage spreadsheet functionality to create actual, budget, or encumbrance journals. You can take advantage of spreadsheet data entry shortcuts such as copying and pasting or dragging and dropping ranges of cells, or even using formulas to calculate journal line amounts. You can then upload your journals to Oracle General Ledger. Before uploading, you can save and distribute your journal worksheets for approval.

We can also import data from text files into spreadsheets, where it can be further modified before uploading to Oracle. This functionality is useful when migrating data from legacy systems, or from any source that can produce delimited files.

Using the Budget Wizard, you can download budget amounts to a spreadsheet, modify the amounts, and then upload them back. You can also choose to download the actual amounts to compare it with the budget amount. Budget Wizard also allows you to plot graphs and do a graphical comparison on the amounts. Budget Wizard also provides budget notes. You can add descriptions to accounts and amounts in your budget and explain your budget within the budget worksheet, avoiding the clutter of external documentation.

Sequence for Reporting

Maintaining two sequnces have been introduced, accounting and reporting sequencing.

Journal Line Reconciliation

Journal Line Reconciliation enables you to reconcile journal lines that should net to zero, such as suspense accounts, or payroll and tax payable accounts for countries, such as Norway, Germany, or France.

Enhanced Intercompany;

In R12, we have made many improvements to intercompany accounting. 11i is Global Intercompany System (GIS) has been replaced with an exciting new product called Advanced Global Intercompany System (AGIS). We also extended intercompany balancing support to include encumbrance journals.

For intercompany transactions ,in R12 new module has been introduced.

Accounting Setup Manager is a new feature that allows you to set up your common financial setup components from a central location.

What is Accounting Setup Manager

Accounting Setup Manager is a new feature that streamlines the setup and implementation of Oracle Financial Applications. The Accounting Setup Manager will facilitate the setup required for simultaneous accounting for multiple reporting requirements.

With the Accounting Setup Manager, you can perform and maintain the following common setup components from a central location:

·         Legal Entities

·         Ledgers, primary and secondary

·         Operating Units, which are assigned to primary ledgers

·         Reporting Currencies, which is an enhanced feature

·         Subledger Accounting Options. This is where you define the accounting methods for each legal entity subledger transaction and associate them to the ledger where the accounting will be stored.

·         Intercompany Accounts and Balancing Rules

·         Accounting and Reporting Sequencing

·         Both Intercompany and Sequencing

Creating foreign currency recurring journals

In Release 11i, you could define recurring journals using the functional currency or STAT currency.

Now in Release 12, you can create recurring journals using foreign currencies. This is particularly useful if you need to create foreign currency journals that are recurring in nature. For example, assume a subsidiary that uses a different currency from its parent borrows money from the parent. The subsidiary can now generate a recurring entry to record monthly interest payable to the parent company in the parents currency.

Data Access to Multiple Legal Entities and Ledgers

You no longer have to constantly switch responsibilities in order to access the data in a different ledger. You can access multiple ledgers from a single responsibility as long as all ledgers share the same chart of accounts and calendar.

Simultaneous Opening and Closing of Periods for Multiple Ledgers

You no longer have to open and close periods for each ledger separately. You can now open and close periods across multiple ledgers simultaneously by submitting Open and Close Periods programs from the Submit Request form.

Simultaneous Currency Translation of Multiple Ledgers

You can run the Translation program for multiple ledgers simultaneously, if you are managing multiple ledgers.

Financial Reporting for Multiple Ledgers

Now with this feature you can run Financial Statement Generator (FSG) reports for multiple ledgers simultaneously. This is useful if you manage multiple ledgers and want to run a balance sheet or income statement report for all of your ledgers at the same time.

Cross-Ledger and Foreign Currency Allocations

You are able to allocate financial data from one or more ledgers to a different target ledger. This enables you to perform cross-ledger allocations, which is useful for purposes such as allocating corporate or regional expenses to local subsidiaries when each entity has its own ledger

Automatic Posting

You can now share AutoPost Criteria sets across multiple ledgers that share the same chart of accounts and calendar and use the AutoPost Criteria sets to post journals across multiple ledgers simultaneously.

AutoReversal Criteria Setup Integrated Web-based

AutoReversal Criteria Sets can also be shared across ledgers to reverse journals across multiple ledgers. This is enhanced by integrated Web-based Spreadsheet Interface.

Journal Copy

Now we can now copy entire journal batches. You can copy journal batches with any status. The system will create a new journal batch containing the same journal entries.You may also change the batch name, period, and/or effective date while copying the journal batch. After copying the journal batch, you may modify the unposted journals in the same manner as any manually created journals.

Consolidation Mappings

You are able to define Chart of Accounts Mappings (formerly known as Consolidation Mappings) between two charts of accounts. Therefore, if you have multiple Consolidation Definitions for parent and subsidiary ledgers that share the same chart of accounts pair, and their mapping rules are the same, you only have to define a single Chart of Accounts Mapping.

The enhancement in R12 allows you to define mappings between charts of accounts instead of between sets of books, so that they can be shared across multiple Consolidation Definitions.

Therefore, if you have multiple Consolidation Definitions for parent and subsidiary ledgers that share the same chart of accounts pair, and their mapping rules are the same, you only have to define a single Chart of Accounts Mapping.

You can also secure access to chart of accounts mappings using definition access set security. This allows you to secure which users can view, modify, and/or use chart of account mappings in consolidation definitions.

Replacement for Disabled Accounts

Normally when an account is disabled, you can prevent transactions that include the account from erroring during journal import by defining a replacement account for the disabled account. Journal import replaces the disabled account with the replacement account and continue the journal import process if the replacement account is valid. This improves processing efficiency by preventing the journal import process from erroring and enabling the successful creation of the journal with minimal user intervention when an account has been disabled.

Data Access Security for Legal Entities and Ledgers

In R12, since you can access multiple legal entities and ledgers when you log into Oracle General Ledger using a single responsibility, Oracle General Ledger provides you with flexible ways to secure your data by legal entity, ledger, or even balancing segment values or management segment values. You are able to control whether a user can only view data, or whether they can also enter and modify data for a legal entity, ledger, balancing segment value or management segment value.

Management Reporting and Security

This can be best understood as:You can designate any segment (except the natural account segment) of your chart of accounts to be your management segment and use Oracle GL security model to secure the management segment for reporting and entry of management adjustments.

Prevent Reversal of Journals with Frozen Sources

You can no longer reverse journals from frozen sources defined in the journal sources form.

If the journal is created from a frozen source, the journal cannot be modified even if the source is subsequently unfrozen in the future.
This provides streamlined data reconciliation with subsystems. Not being able to reverse journals that originated in subledgers will ensure that the account balances will always tie out with General Ledger. If you need to reverse a subledger journal, then you should do so in Subledger Accounting or the subledger application.

Prevent Reversal of Unposted Journals

You also can no longer reverse unposted journals. This ensures data integrity and better auditability. In the past when we allowed you to reverse unposted journals, there was a risk that the original journal could be deleted so you could end up reversing something that didn't exist. Now, all reversals can be tied back to the original posted journal.

Control Accounts

You are able to control data entry to an account by ensuring it only contains data from a specified journal source and to prevent users from entering data for the account either in other journal sources or manually within general ledger.

Some of the GL Standard Reports converted into XML Publisher

Oracle General Ledger's Account Analysis, General Journals and Trial Balance standard reports are now integrated with XML Publisher.

Introduction to Web ADI

 

Introduction to Web ADI:

What is Web-ADI?

It is a spreadsheet extension available in Release 12 of Oracle Applications, which can be used for Assets module. It can be used to perform the following tasks:

1.      Creating Assets

How are the above tasks accomplished?

In responsibility “Assets, Vision Operations (USA)” in Release 12 GPI, the navigations for the above tasks are:

Mass Additions à Additions Integrator (for Creating Assets)

select responsibility as “Assets, Vision Operations (USA)” & navigate as Mass Additions à Additions Integrator.

In this page you need to select Corporate Asset Book as “OPS CORP” & click on “Continue”.

Now you need to select Viewer as “Excel 2003” [Depending on the version of Excel you are using] & click on “Next”.

Note: Here if you check “Reporting”, then the document you create will not allow you to upload data.

Now select Layout as “Add Assets Default” [Using this standard layout for now, in chapter 3 we will create our own layout] & click on “Next”.

 You will get a file download window, here you need to click on “Save

 You need to specify where you want to save this layout & click on “Save”.

 You will see a message window that says “Your document has been created”, you need to click on “Close”.

 This is the excel spreadsheet which contains the relevant Asset information columns. Here, first you need to double-click on the cell adjacent to “Queue Name”.

The following window will pop-up, from the list of values you need to check “New” & then click on “Select”.

Now you need to specify Asset Description by double-clicking the below cell & then select from the list of values as shown below.

Now you need to specify Major Category & Minor Category as shown below:

Now you need to enter the Units & Costs manually.

Similarly you need to specify Country, State/County, City, Building details.

Next you need to specify Expense Account.

You need to specify Clearing Account.

You need to enter the Date Placed in Service manually.

Note: The remaining columns in this spreadsheet are optional.

You need to go to the Oracle Menu & click on “Upload”, the following window will pop-up; here you need to select as shown below, & click on “Upload”.

Now you need to validate the above steps, which is to check if the asset data is loaded into the interface table.

For this you need to go to responsibility “Assets, Vision Operations (USA)”, and then navigate as Mass Additions à Prepare Mass Additions.

In this window you need to enter the below data [sample data that we had previously uploaded using the spreadsheet] & click on “Find”.

Now you can see the data that we had entered on the spreadsheet has been loaded into the Interface table.

Now you need to try the same process but this time move the data into Oracle Assets, which is post the data. (So you need to repeat steps up to 18 & modify step 19 as shown below by checking the box for “Create Assets Now (Post Mass Additions)”.