Home » Applications » Oracle Fusion Apps & E-Business Suite » GL_INTERFACE ISSUE (11I)
GL_INTERFACE ISSUE [message #399967] Fri, 24 April 2009 12:53 Go to next message
Krishna_dev
Messages: 32
Registered: May 2007
Member
I am running the journal import and would like to summarize the journal imports being inserted into gl_interface. I am working with 5 segments. So if code combinations in the journal entries are the same they will then I would like get the sum of those journal entries and summarize it as one line.

Example

In staging table:

SEGMENT1||SEGMENT2||SEGMENT3||SEGMENT4||SEGMENT5||AMOUNT
0001 020 0000 000 000 100
0001 020 0000 000 000 100
0001 020 0000 000 000 100
0001 020 0000 000 000 100
0002 030 0000 000 000 100

As above the first 4 lines are the same, each with an amount = 100. I would like to select those lines to enter into gl_interface so that they are one line totalling 400 for the first 4 and a seperate line of 100 for the 5th line which is a different combination as below

Inserting into gl_interface table:

SEGMENT1||SEGMENT2||SEGMENT3||SEGMENT4||SEGMENT5||AMOUNT
0001 020 0000 000 000 400
0002 030 0000 000 000 100

Does anyone know the SQL statement to do this.
Re: GL_INTERFACE ISSUE [message #399986 is a reply to message #399967] Fri, 24 April 2009 16:21 Go to previous message
Krishna_dev
Messages: 32
Registered: May 2007
Member
so far this is the query I have come up with to pull this off. Can anyone validate this for me.


select segment1,segment2,segment3,segment4,segment5,sum(amount)
from table_t
GROUP BY segment1,segment2,segment3,segment4,segment5;

Previous Topic: LPN Status
Next Topic: Payable transfer to GL completed with error
Goto Forum:
  


Current Time: Sat Dec 03 10:05:05 CST 2016

Total time taken to generate the page: 0.12914 seconds