Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

HandsonERP - Oracle E-Business Suite Training
Welcome, Guest
Please Login or Register.    Lost Password?
Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Group ID in E Business Interface
#1892
liben (User)
Expert Boarder
Posts: 97
graphgraph
User Offline Click here to see the profile of this user
Group ID in E Business Interface 15 Years, 2 Months ago  
When I am importing say 300+ lines, I wanted to use the Group ID function. So what is Group Id, is it the same as Group by .......when we write SQL script?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1895
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Group ID in E Business Interface 15 Years, 2 Months ago  
You can group the data you are importing into Oracle GL using group ids.
In the GL Interface table there is a column called GROUP ID. You can put a number in there in order to identify which group the record belong to. Then when launching the journal import program you can specify the GROUP ID. System will import only the records belonging to this GROUP ID. This feature is helpful when different group of people in Finance department are responsible for importing part of data.
Here is an example. Lets say this is a sample data in GL INTERFACE Table.
(Journal, Account, Debit, Credit, Group Id)
JOURNAL1, ACCOUNT1, 100, 0, 1
JOURNAL1, ACCOUNT2, 0, 100, 1
JOURNAL2, ACCOUNT1, 10, 0, 2
JOURNAL2, ACCOUNT2, 0, 10, 2
Group 1 can run the import for GROUP ID = 1. Only Journal 1 will be imported.
Group 2 can run the import for GROUP ID = 2. Only Journal 1 will be imported.
 
Report to moderator   Logged Logged  
 
Last Edit: 2011/05/26 12:29 By handsonerp.
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop