Alternate Financial Implementation Steps (Oracle Learning Management)

Alternate Financial Implementation Steps

If you do not run Oracle General Ledger, you must define an accounting flexfield structure, create a ledger, and set several options. This process activates your Suppliers and Customers pages and assists you in transferring costs between OLM and your accounting system.

Define an Accounting Flexfield Structure

If you intend to use OLM to transfer cross charges for internal learners or resources, you should define a Chart of Accounts that reflects your real Chart of Accounts (plus cost centers and departments). This includes segment names, length, validation and selectable values.

Note: If you already run Oracle General Ledger, the flexfield structure you require already exists, and you do not need to complete the following steps.

Step 1: Define Accounting Flexfield Value Sets

If you want to validate the values which a user can enter for any segment you must define a specific Value Set.

The attributes of the Value Set control the type of values that can be entered, and how many characters each segment can hold. The attributes of the Value Set also control how the values are to be validated.

Value Sets can be shared by different segments of the same flexfield, or by segments of any other flexfield.

For example, consider the following typical three value sets for your accounting flexfield structure:

Company
Account
Cost Center

Note: You must create the value sets with the validation type Independent.

Table B-1 Value Sets

Value Set	Format Type	Maximum Size
COTA_COMPANY	Char	11
COTA_ACCOUNT	Char	11
COTA_COST_CENTER	Char	11

Use the Value Sets window.

See Defining Value Sets

Step 2: Define Accounting Flexfield Segments

Define a structure for your Accounting Flexfield which contains the segments you want to use. Name your structure something like OLM Accounting Flexfield, for example. You can then distinguish this structure from the Accounting Flexfield structure used by Oracle Financials. This may be useful if your enterprise later buys Oracle Financials and you want to set up full accounting functionality.

Note: You must not check the Allow Dynamic Inserts box. Oracle Learning Management requires the valid combinations to exist, and therefore cannot enter new values upon data entry in the OLM Finance windows.

Table B-2 Accounting Flexfield

Segment Number	Segment Name	Column	Value Set
1	Company	SEGMENT1	COTA_COMPANY
2	Account	SEGMENT2	COTA_ACCOUNT
3	Cost Center	SEGMENT3	COTA_COST_CENTER

You must enter flexfield qualifiers for each segment, to identify which segment appears on each window.

Table B-3 Company Segment

Flexfield Qualifier	Check the Enable Box:
Cost Center Transfer Segment	NO
Natural Account Segment	NO
Balancing Segment	YES
Intercompany Segment	NO

Table B-4 Account Segment

Flexfield Qualifier	Check the Enable Box:
Cost Center Transfer Segment	NO
Natural Account Segment	YES
Balancing Segment	NO
Intercompany Segment	NO

Table B-5 Cost Center Segment

Flexfield Qualifier	Check the Enable Box:
Cost Center Transfer Segment	YES
Natural Account Segment	NO
Balancing Segment	NO
Intercompany Segment	NO

Use the Key Flexfield Segments window.

See Defining Key Flexfield Structures

Step 3: Define Accounting Flexfield Segment Values

As you have chosen Independent validation for the Value Sets used by a Accounting Flexfield Segment, you must define your list of valid values for the Value Sets.

Table B-6 Accounting Flexfield Segment Values

Value Set	Description	BudgetingQualifier	Posting Qualifier	Account Type Qualifier
COTA_COMPANY	Company 000	Yes	Yes	N/A
COTA_ACCOUNT	Account 000	Yes	Yes	Liability
COTA_COST_CENTER	Account 000	Yes	Yes	N/A

Use the Segment Values window.

See Defining Segment Values

Step 4: Uncheck Dynamic Inserts on OTA Accounting Key Flexfield

You must set the dynamic inserts to NO for the OLM Accounting flexfield.

Navigate to the Define Key Flexfield Segments window, and query the OLM Accounting key flexfield structure.

Uncheck the Dynamic Inserts box.

Use the Key Flexfield Segments window.

See Defining Key Flexfield Structures

Step 5: Freeze and Compile Your Accounting Flexfield Structure

You are now ready to freeze your Accounting Flexfield definition. Check the Freeze Flexfield Definition box and save your changes. OLM freezes and compiles your Accounting Flexfield definition. Compiling the flexfield definition enables the Accounting Flexfield window with the defaults, values, and rules that you have defined.

Use the Key Flexfield Segments window.

See Defining Key Flexfield Structures