Page 1 of 1

Legacy LedgerData uploading to APPS G/L‏

Posted: Wed Oct 27, 2010 2:06 pm
by asad
Dear all,


We implementing oracle apps G/L and we want legacy GL data upload to oracle APPS GL, we have following fields in legacy ledger system

SQL> desc ledger
Name Null? Type
------------------------------- -------- ----
GL_TRANS_DATE DATE
GL_TRANS_SEQ_NO NUMBER(6)
GL_MAJOR_ACCOUNT NUMBER(4)
ACCTG_CODE VARCHAR2(3)
GL_TRANS_REFERENCE VARCHAR2(50)
GL_TRANS_AMOUNT NUMBER(14,2)
GL_TRANS_SOURCE VARCHAR2(6)



Kindly help me if its possible to upload legacy ledger data to APPS GL. If it is possible kindly give the table , field name which is mandatory in order to upload in APPS GL.

Thank you.
Regards,
asad

Posted: Wed Oct 27, 2010 3:10 pm
by admin
All the steps are very well covered in our Financial document. You will have to upload into GL_interface table and then through system you will import.

topic.asp?TOPIC_ID=5830