User Forms
You can also bring up a user form to enter or complete your dataset. To open the user form, click on the ‘Forms’ ribbon button.
You can also double-click on any cell below row 10 to open the user form.
Using the form, you can enter or complete your dataset. The user form provides validation using data cached from your EBS instance during login.
Fields marked with a yellow background are mandatory fields. For each record uploading through the loader, mandatory fields are required to fill in the values.
Greyed-out fields are read only. Those fields contain supplementary details for the user information purpose.
Row_ID field represents the unique row_id Oracle assigned to the record. This is populated only when the user downloads the records. The user should not enter or modify the value on this ID field. Do not modify or adjust this value as it is imperative for the upload process and is used as a part of the concurrent program and refresh process.
Batch Number field auto-generates a unique number once the records are uploaded to the interface table. This is a required parameter for the concurrent request to pick up the records from the interface table and import them to Oracle. It processes only those records that are submitted by this user and avoid accidentally processing other user’s records sitting in the interface table. This should not be modified by the user and so it is greyed out as a read-only field.
Start Date is the starting date of the range of dates for which rows will be inserted into GL_DAILY_RATES. General Ledger will insert one row for each date in the range between Start Date and End Date. Each date will have the same conversion rate you specify. This is a mandatory field. The range of start and end date cannot exceed the 366 days.