Sunday 13 July 2014

Journal Import in Oracle

For All the entries in the subledger modules , the data will be transferred to the GL and subsequently  journals will be created and posted.
In order to create journals in Oracle the data should be present in GL_INTERFACE , once the data is loaded into the GL_INTERFACE the Jounal Import programs "Import Journals" needs to be submitted.

Data can come into GL_INTERFACE either from the Subledgers eg :AP/AR/INV or uploaded by Web ADI.
Once the data is available in GL_INTERFACE , launching Jounral import will pick up data for the Ledger for which the program is run , validate the data and create journals.

Some of the important points to remember when running Journal Import :
  • Group Id : When you are running Journal Import you can import data for multiple sources by specifying the Group Id Pramater. When specified journal import will process only the records of the specified Group Id. If the Group Id is not provided then Journal Import will only process the records for which Group Id is not specified ie Group ID NULL , records with group id will be left un-processed
  • Chossing : Import Descriptive Flexfields, and whether to import them with validation : If we are not creating Summary Journals then we can choose to import the Descriptive Flexfields . Here we can choose to import DFF with our without validation . With Validation Imports journals only if the Descriptive Flexfields pass the validations or you can choose to import journals without Flexfiled journals  where Oracle will not validate the DFF and generate all the journals

No comments:

Post a Comment