GL Conversion

When we are dealing with a Implementation project, We will have to create Conversions for different master Data. Here i am trying to explain GL Conversion process.

1. Create a SQL Loader concurrent program to Load Legacy system data into a Staging table in Oracle Application.
 Pre requisites : - Developer will get Conversion data file template from client and make sure that all mandatory columns for GL_INTERFACE is there.
Create a staging table based on Conversion Data File format and other columns to validate user validation and process status.
2. Create a Master Program to call Sql Loader program, validate and insert valid records into GL_INTERFACE, Print Validation messages and Invoke Journal Import Programs. To make the program more user friendly, can include parameter to 'Preview Mode' - Yes/ No and 'Journal Import' - Yes /No.


Mandatory Columns in GL_INTERFACE

• STATUS - Assing value 'NEW'
• LEDGER_ID  - Validate the ledger in GL_LEDGERS from Ledger Name given in Data template.
• USER_JE_SOURCE_NAME - Validate the Source name against table column 
GL_JE_SOURCES.USER_JE_SOURCE_NAME. To distinguish 'Conversion' data, it is better practice to use custom Source for Conversion data.

• USER_JE_CATEGORY_NAME - Validate the Category name against table column GL_JE_CATEGORIES.USER_JE_ CATEGORY_NAME. To distinguish 'Conversion' data, it is better practice to use custom category for Conversion data.
• ACCOUNTING_DATE 
• CURRENCY
• ACTUAL_FLAG

Ref: https://docs.oracle.com/cd/A60725_05/html/comnls/us/gl/gloiji03.htm