Implementing Flex Fields in oracle

Implementing Flex fields

Key Flexfield

The basic steps in defining a key Flexfields are as given below. You may or may not use all the steps. The detailed explanation is being followed after the steps.

• Identifying Key flexfields that are required for you Oracle Applications installation
• Designing a Key flexfield structure
• Selecting the appropriate Key flexfield to define
• Defining structure information for the Key flexfield
• Defining segment attributes
• Defining flexfield qualifiers
• Defining segment qualifiers
• Implementing optional features as needed

To define the key Flexfield structure, you need to open the Key Flexfield segment form as shown in the figure 5 below. The navigation path is Application Developer à Flexfield: Key à Segments.

Figure 5. Key Flexfield Segments Form

Lets say you are defining the structure for an Accounting Flexfield. Query for the Flexfield Title “Accounting Flexfield” using the Flexfield Title window as shown in figure 5 above. If there are already existing structures for Accounting Flexfields, they would be listed in the Structures window as shown in figure 6 below.

Figure 6. Listing of existing structures for Accounting Key Flexfield

Lets say you want to define a new structure for the Accounting Flexfield with the structure code as “NEW_ACCOUNTING_STRUCTURE”. Enter the code name in the Code window and the title as “New Accounting Flexfield Struc” in the Title window. Enter an optional description for the new structure which may include the purpose of the new structure. Save the changes. The form would look like as shown in figure 7 below.

Figure 7. Structure definition for a new Accounting Flexfield

There are few check buttons on the form in the figure 7 above which can be left unchecked/checked as shown in the figure above.

The Enabled checkbox is checked by default. You can optionally uncheck it. You cannot delete a Key flexfield structure, but you can disable it by unchecking the Enabled checkbox. Next, you may select a Segment Separator other than the default period. Your choices are period, dash, pipe, or any custom character. You must have a segment separator.

Next, you can select whether you want to Cross-Validate Segments. Unchecking this checkbox will disable cross-validation for this Key flexfield structure. You can then identify whether you want to Freeze Rollup Groups. If you mark this checkbox, you will not be able to change the assigned rollup groups in the Define Segment Values form. As a last step, you can determine whether you want to Allow Dynamic Inserts for Key flexfield structures. If you do not allow dynamic inserts, you must create all flexfield combinations in the combination form.

Sponsored Links

You can freeze your flexfield structure by checking the Freeze Flexfield Definition checkbox. Once frozen, you can only make very limited changes to the flexfield structure definition. If you need to change the flexfield structure definition, first uncheck the Freeze Flexfield Definition checkbox and make the changes. Next, reactivate the Freeze Flexfield Definition checkbox. You will receive a warning message that tells you that unfreezing this flexfield and making changes to the segment definitions could affect the validity of the data already existing for this flexfield. Changing a Key flexfield structure will not update existing flexfield data. Do not freeze your flexfield structure yet, as you have not entered the segment attributes for your flexfield structure.

Once the above fields are defined click on the Seg ments button at the bottom of the form. The new form would look like as shown in figure 8 below. Enter the values as shown in the form below. You can use the already defined Value Sets for the various segments. If you have not defined them earlier, they can be created using the Value Set button at the bottom of the form. Save the changes. To assign a flexfield qualifier to each segment, select the segment on the form and then click on the Flexfield Qualifiers button as the next step.

Figure 8. Accounting Flexfield Segment Structure form

Select the New Company segment and click on Flexfield Qualifier button. Check the Balancing Segment for the New Company structure as the flexfield qualifier. The form would look like as shown in figure 9 below. Follow the same steps to choose the flexfield qualifiers for the remaining 2 segments. Check Cost Center Segment for New Cost Center and Natural Account for New Account segments respectively. Save the changes and close the Structure form.

Figure 9. Flexfield Qualifier form

As the next step, the form shown in figure 7 would be visible now. Click on the Freeze Flexfield Definition button. Then compile the flexfield structure. You can compile your flexfield structure by hitting the Compile button. Compiling a flexfield structure will automatically save the flexfield structure. You will see the dialogue box as shown in figure 10 below. Choose OK on the dialogue box.

Figure 10. Compiling Flexfield Definition

Figure 11. Dialogue box for compilation of flexfield structure

Click on OK and the flexfield definition would be saved.

Oracle Apps 11i: Setting up Chart Of Accounts (COA)

Page 1 of 3

Oracle Apps 11i Free Training : Setting up Chart Of Accounts (COA)

In this tutorial you will learn how to create a Chart Of Accounts (COA), create a new value set, General Ledger - List Types, Security Types, Format Types, Validation Types, Oracle GL Segments and Create the Accounting Flexfield Structure.

Sponsored Links

Setting up Chart Of Accounts

Document Summary

This document is a step-by-step guide to understanding and setting up Chart of Accounts and Accounting Flex Fields in Oracle Applications.

To setup General Ledger for your organization, step through the following points:

Creating a Chart Of Accounts (COA)

A Chart Of Accounts defines what segments each account for the organization consists of. The COA consists of things like defining the accounting structure (the accounting structure is a framework or model that you will use to maintain your accounts), Account code combinations etc.

The steps involved in setting up the COA are:

1.1. Create a new Value Set.

Value Sets act as validations for the values entered by users. When the users enter the values in any of the fields (on any form), if there is a value set attached to this field, the values entered by user are validated against the value set. To create a new value set:

Log on to General Ledger – Vision Operations (USA)/GL Team Lead responsibility.

-- Navigate to N> Setup> Financials> Flexfields> Validation> Sets.

-- In the ‘Value Sets’ window, enter the new value set name and a description for the value set.

-- In the ‘List Type’ drop down box, select the kind of list you require based on the following criteria:

• Use ‘List of Values’ when the expected number of values is between 10 and 200. If you choose ‘List of Values’ then your value set will not provide the LongList feature in Oracle Forms applications and users will not see a poplist in Oracle Self-Service applications. .
• Use ‘Long List of Values’ when the expected number of values is more than 200. The LongList feature requires a user to enter a partial segment value before the list of values retrieves all available values. If you choose ‘Long List of Values’ then your value set will provide the LongList feature in Oracle Forms applications and users will not see a poplist in Oracle Self-Service applications. You may not enable LongList for a value set that has a validation type of ‘None’. .
• Use ‘Poplist’ when the expected number of values is fewer than 10. If you choose ‘Poplist’ then your value set will not provide the LongList feature in Oracle Forms applications but users will see a poplist in Oracle Self-Service applications.

-- In the ‘Security Type’ drop down box, select the security you want Oracle Applications to use with this value set. The possible security types are:

• No Security - All security is disabled for this value set. .
• Hierarchical Security - Hierarchical security is enabled. With hierarchical security, the features of value security and value hierarchies are combined. With this feature any security rule that applies to a parent value also applies to its child values. Within a hierarchical tree of values, a value is subject to a security rule if any parent above it is subject to that security rule. .
• Non-Hierarchical Security - Security is enabled, but the rules of hierarchical security do not apply. That is, a security rule that applies to a parent value does not "cascade down" to its child values.

* The parent values and child values in a particular Key flexfield are defined in the ‘Segment Values’ window, discussed later in this document.

-- Enter the ‘Format Type’, ‘Maximum Size’ and ‘Precision’ for your value set.

-- You can also specify the ‘Min Value’ and the ‘Max Value’ that this value set permits.

-- The first 2 check boxes on the screen define which values (‘Numbers only’, ‘Uppercase only’) the value set permits. Whereas if the third check box is checked, the values that are entered in the fields will be Right justified and zero filled automatically.

-- The ‘Validation Type’ can be any one of the following:

• None: You use a None type value set when you want to allow users to enter any value so long as that value meets the value set formatting rules. Because a None value set is not validated, a segment that uses this value set does not provide a list of values for your users. A segment that uses this value set (that is, a non-validated segment) cannot use flexfield value security rules to restrict the values a user can enter. .
• Independent: This value set provides a pre-defined list for valid values. These values are entered using the ‘Segment Values’ window (Fig 10). .
• Dependent: A dependent value set is similar to an independent value set, except that the available values in the list and the meaning of a given value depend on which independent value was selected in a prior segment of the flexfield structure. You can think of a dependent value set as a collection of little value sets, with one little set for each independent value in the corresponding independent value set. You must define your independent value set before you define the dependent value set that depends on it. You enter the values for dependent values in the Segment Values window (fig 10). E.g. you have selected an independent value set ‘vs1’ for segment1 and a value set ‘vs2’ that is dependent (on ‘vs1’) for segment2. Let us assume that vs1 has two valid values: ‘Computer’ and ‘Furniture’. Then vs2 will have two sets of valid values pertaining to each value in vs1, i.e. if ‘Computer’ is entered for the segment1 then there may be a set of valid values for segment2, say, ‘mouse’, ‘keyboard’ etc. If ‘Furniture’ is entered for segment1, then there may be a set of valid values for segment2, say, ‘table’, ‘chair’ etc. .
• Special and Pair: Special and pair value sets provide a mechanism to allow a "flexfield-within-a-flexfield". These value sets are primarily used for Standard Request Submission parameters. You do not generally use these value sets for normal flexfield segments. Special and Pair value sets use special validation routines you define. For example, you can define validation routines to provide another flexfield as a value set for a single segment or to provide a range flexfield as a value set for a pair of segments.

Fig 2: Value sets window.

1.2. Create the Accounting Flexfield Structure.

The accounting flexfield structure defines all the segments that makeup any account in the organization. In any organization, the accounts typically consist of codes like company_id, department_id, asset_number etc.

E.g. a typical account may have the first 2 digits representing the company, next 3 digits representing the department, next 4 digits representing the location and the last 4 digits representing the asset number.

(A typical account may look like 01.111.0011.0001)

(A typical account may look like 01.111.0011.0001)
01	111	0011	0001
Company_id	Department_id	Location_id	Asset_Number

Sponsored Links

Each of these segments are defined in the accounting flexfield structure. Follow below steps to create an accounting flex field structure:

-- Logon to N> Setup > Financials > Flexfields > Key > Segments

-- Query for the Flexfield Title ‘Accounting Flexfield’. This should give a screen that looks like below:

Fig 3 Key flexfields segments window

Navigate to the structure lines and click on the ‘New’ button on the tool bar.

-- Enter the ‘Code’, ‘Title’ and ‘Description’ for your accounting structure.

The controls on this form are discussed in explanation for fig 6, 7 and 8.

-- Check the Cross-Validate Segments checkbox and the Allow Dynamic Inserts checkbox.

Fig 4

-- Click on the ‘Segments’ button. Enter the segments that you intend to be in your account structure. E.g. Company_id, Department_id etc.

-- Enter the (Serial) Number, (Segment) Name, Window prompt, Column (this is the column in the table GL.GL_CODE_COMBINATIONS to which this segment is mapped) and Value Set (for validation).

-- Also select the Displayed and Enabled check boxes for these segments. The form may look like this:

Fig 5

-- Navigate to each segment and for each segment, click the Flexfield qualifiers button.

-- The flexfield qualifiers window displays 4 qualifiers that can be attached to the segment. Click any one of the segment qualifiers and to attach it to the selected segment, check the enabled check box. Of these Oracle GL requires the following 3 segments identified:

• Balancing Segment: This attribute is used to identify the balancing segment. Normally, the company segment is selected as the balancing segment. This means that for a company, oracle applications will try to make the debits and credits equal. .
• Cost Center Segment: This is only used in the Oracle Assets module. .
• The Natural Account Segment qualifier specifies which segment contains the account type for an account combination. (Account types can be Assets, Liability, Expense, Revenue, or Ownership/Stockholder’s Equity.)

Apart for these the 4th segment is:

• Intercompany Segment: This segment is used while passing intercompany entries.

See the figure below:

Fig 6

-- Once you have specified the Flexfield qualifiers for each of the segments, close the Flexfield qualifiers and the segment summary windows.

-- Selecting the ‘Enabled’ check box enables the flexfield on the form.

-- Selecting the ‘Cross-Validate Segments’ check box enables the cross validation rules to be applied to this flexfield.

-- Selecting the ‘Allow Dynamic Inserts’ check box eliminates the need to enter the valid account combinations before using them. The effect is that you don’t have to use the ‘GL Accounts’ form (see *1 at the end).

-- On the Key Flexfield Segments window, check the ‘Freeze Flexfield Definition’ check box. A message will appear warning that you must be done with making changes to your flexfield definition before freezing. Click OK. Selecting this check box makes the flexfield definition non updateable (unless you uncheck it again).

Oracle Apps 11i: Setting up Chart Of Accounts (COA) - Page 3

Page 3 of 3

.

.

.

Sponsored Links

See the figure below:

Fig 7

-- Save the record.

-- A message will be shown for compiling the flexfield definition. Click OK. See figure below.

Fig 8

-- Another message will be displayed saying that a request to generate flexfield view has been submitted and the view name.

With this step we are done with creating the chart of accounts.

2. Enter the valid Accounting Flexfield Segment values:

Now we need to enter valid values for the accounting flexfield segments. There may be a certain range of values that your value set definition permits. But there may be just a few of these permitted values that you may want to use. These valid values are entered for each segment in this step.

The steps are:

-- Navigate to N>Financials>Flexfields>Key>Values.

Fig 9

-- Make sure that in the ‘Find Values By:’ region, ‘Key Flexfield’ option is selected.

-- Click in the ‘Structure’ field and click on the LOV. In the Find box enter the name of your accounting flexfield structure and click FIND. Click OK when you have selected your AFF structure. Click on FIND in the ‘Find Key Flexfield Segment’ window.

-- Click on ‘Values, Hierarchy, qualifiers’ tab.

-- Enter the values that you want to use for each segment and their meaning in the description (the segment name is shown in the block above the current block).

Fig 10


*1 - You can enter the valid account code combinations through the ‘GL Accounts Form’ (N>Setup>Accounts>Combinations). But since we have enabled the ‘Allow Dynamic Inserts’ option on the ‘Key Flexfield Segments’ window, we do not need to enter valid account combinations in this window before we use them. Whenever such a combination is used, it will be defined dynamically.

Frequently Asked Questions

1. What is a COA?
2. What is a value set?
3. What are dependant and independent value sets?
4. What are Special and pair value sets?
5. Explain the various security types related to value sets.
6. What is the significance of the ‘Allow Dynamic Inserts’ option on the ‘Key Flexfield Segments’ window?
7. What is a pop list?
8. Explain the various flexfield qualifiers.
9. How do you enable the cross validation rules to be applied to this flexfield?
10. Which form can be used to enter the valid account code combinations?

Overview

Users and Responsibilities are created in oracle applications in order to control the access to the data. Users are assigned a set of responsibilities through which they can retrieve or modify certain set of data. Responsibility is a grouping of access in a logical manner. Accounts payable responsibility would contain all the privileges to create invoices, make payments etc. All the users from the payables department would be given this responsibility. You can create users, responsibility through system administrator responsibility in oracle applications.

Creation of User

Navigation – System Administrator ->Security -> User -> Define

Figure 1. Create User Navigation

Follow the above the navigation path and click on Define. You will see following screen in front of you.

Figure 2. Create User

Fields

UserName		Give the username in this field.
Password		Enter desired password twice in this field. You would be required to change the password when you login first time with this username.
Description		Provide brief description of the user in this field.
Password Expiration		Days  Accesses  None 
Person		You can attach employee to this user. This is used for HRMS applications
Customer		To attach customer to this user.
Supplier		To attach supplier to this user.
Email		Provide email address for the user. Its use to send notifications to the user through oracle applications.
Fax		Fax number for the user.
Effective Dates		From and To dates between which the user would be active.
Responsibilities		List of responsibilities assigned to the user.

Sponsored Links

Figure 3. Create User Indirect Responsibilities

Figure 4. Create User Securing Attributes

Oracle Apps 11i : Creating Journals through Oracle GL

Page 1 of 2

.

Oracle Apps 11i Free Training : Journal Entry

This tutorial will describe the procedure of creating journals through oracle GL - Create a new batch with multiple Journal entries, Enter Journals to a Batch and to Enter Journal Lines.

Sponsored Links

Create a new batch with multiple Journal entries

Create a Journal batch

The following are the steps for creation of a journal batch:

1. Navigate to the enter journals window.

2. Choose New Batch.

3. Enter an optional Batch name to identify the batch on general ledger and journal entry reports. You cannot have duplicate batch names in the same accounting period. If you do not enter a batch name, General Ledger will create a default name from the source, combined with a unique batch ID and the system date.

4. Enter the accounting Period for which you want to post the entries in your journal batch. General Ledger defaults to the latest Open period.

a. Note: If you enter a period prior to the current accounting period and the user profile option Journals: Enable Prior Period Notification is set to Yes, General Ledger will display a message indicating that you are entering a prior period journal. You must confirm that this is what you want to do.

b. Additional Information: Balance Type is a display–only field. It displays Actual when you are entering actual journals and Budget when you are entering budget journals.

5. (Optional) Enter a description for the journal batch.

6. Enter a Control Total if you want to verify the total debits for your journal batch against the batch control total. You can also enter a control total at the journal entry level.

7. Choose Journals to add journals to the batch.

Figure -2 The Journal batch creation screen.

Enter Journals to a Batch

One can enter a journal to an existing batch or can create a new journal. The following are the steps:

1. Navigate to the Enter Journals window.

2. Enter or query the batch for which you are entering journals. To enter a journal without entering batch information, choose New Journal and proceed to Step 4.

• To enter journals for a new batch, choose New Batch and enter the batch information.
• To add journals to an existing batch, query the batch and choose

Review Batch.

3. Choose Journals.

4. Enter a unique Journal name for the entry. If you do not enter a journal name, General Ledger automatically assigns a name using the following format: Source Journal ID Date.

If you did not enter a batch name before entering journals, General Ledger uses the name of the first journal in the batch to create a default batch name.

5. Enter the Period for the journal entry. If you entered a period at the batch level, you must use the same period for each journal entry in the batch. If you did not enter a period at the batch level, choose any Open or Future Enterable period for your journal entry. Note that you can only post journals in Open periods.

6. Accept or change the default Effective Date for the journal entry.

7. Enter a Category to describe the purpose of your journal entry, such as accrual, payments or receipts. All lines in a journal entry share the same journal category.

General Ledger defaults the journal category if you defined the profile option Journals: Default Category.

8. Enter an optional Description for the journal entry. General Ledger uses this as the default description for each journal entry line. You can change the journal entry description as necessary.

9. Enter a Control Total if you want to verify the total debits for the journal lines against the journal control total.

10. Accept the default Currency (the functional currency for your set of books), or change the journal currency to enter a foreign currency or statistical journal.