About Conversions

[amicguys]

hi,,

This is kishore and my question is how can get the conversion data into our own source which we define that at gl level .could any body can help to sort out this probs.

Regards,
kishore

[mpotdar]

Kishore,

My understanding is, you are planning to create a new Journal Source for Conversion.

If so, while populating Converted GL Balances from legacy system, ensure to you use this new Journal Source in GL_INTERFACE.

1. In GL_INTERFACE table, use column USER_JE_SOURCE_NAME.

2. While populating GL_INTERFACE table, you would need to populate
Following columns (not Null).

STATUS NOT NULL VARCHAR2 (50)
SET_OF_BOOKS_ID NOT NULL NUMBER (15)
USER_JE_SOURCE_NAME NOT NULL VARCHAR2 (25)
USER_JE_CATEGORY_
NAME
NOT NULL VARCHAR2 (25)
ACCOUNTING_DATE NOT NULL DATE
AVERAGE_JOURNAL_FLAG VARCHAR2 (1)
CURRENCY_CODE NOT NULL VARCHAR2 (15)
DATE_CREATED NOT NULL DATE
CREATED_BY NOT NULL NUMBER (15)
ACTUAL_FLAG NOT NULL VARCHAR2 (1)

3. Also you would need to populate "Assigning Values for Additional Required and Conditionally Required Columns" mentioned in GL User Guide (page 1-102)

4. Apart from this you would need to populate either Acct Code Combination ID / Individual segment values.

5. Also ensure to populate GROUP_ID column for each run (this is a nonmandatory Column, but recommended) Use sequence GL_INTERFACE_CONTROL_S for populating this column.

Cheers
Mrunal