Launches GL - EBS 11

[marquesjr]

Staff starting here with EBS, and I'm trying to get the debit and credit bill along with the value, of a certain release. What set of tables can I get this information?

[DanielNN]

Hello Marques_JR,
The table that has the accounts and other segments of the accounting key is gl_code_combinations.

It has connection with gl_je_lines (where has all LANCES of GL) and GL_BALANCES (where has summarized values).

[marquesjr]

Thanks Daniel, I rode some that is helping, but the return of the consultation is delaying. I noticed that in GL_CODE_COMBINATIONS only has the account number, where do I find the account name? Another doubt that I stayed is how all accounting launch has a debt in an account and a credit in another account from JE_HEADER_ID will it be able to identify in which account has dropped the debt?

Select all

 
SELECT 
    a.JE_HEADER_ID 
  ,a.JE_LINE_NUM 
  ,a.CODE_COMBINATION_ID 
  ,a.PERIOD_NAME 
  ,a.EFFECTIVE_DATE 
  ,a.CREATION_DATE 
  ,a.ENTERED_DR 
  ,a.ENTERED_CR 
  ,a.ACCOUNTED_DR 
  ,a.ACCOUNTED_CR 
  ,a.DESCRIPTION 
  ,b.SEGMENT2 
  ,b.SEGMENT4 
FROM 
    GL.GL_JE_LINES a 
  ,GL.GL_CODE_COMBINATIONS b 
WHERE 
    a.CODE_COMBINATION_ID = b.CODE_COMBINATION_ID AND 
    b.SEGMENT4 = '487981935465001' AND 
    a.EFFECTIVE_DATE = '30/04/2009' 

[DanielNN]

Regarding how accounting is made, this depends on company to the company, if you use doubled shares for each release or not.
already where account descriptions are located, they are given via flexfileds registries.
Look at this table and enter the correct FlexField data:

Applsys.fnd_id_flex_segments

[marquesjr]

Searching for segment_name returned the following:

Select all

 
APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM APPLICATION_COLUMN_NAME SEGMENT_NAME    
-------------- ------------ ----------- ----------------------- --------------  
501            GL#          80350       SEGMENT4                CONTA CONTÁBIL  
501            GL#          80370       SEGMENT4                CONTA CONTÁBIL  
501            GL#          80371       SEGMENT4                CONTA CONTÁBIL  
501            GLLE         80350       SEGMENT4                CONTA CONTÁBIL  
501            GLLE         80371       SEGMENT4                CONTA CONTÁBIL  
501            GLLE         80370       SEGMENT4                CONTA CONTÁBIL  

[DanielNN]

Dude,
I replied rushed because I was going out for lunch.
The description is in

Select all

apps.fnd_flex_values_vl 

and you relate to this to pick up the ID of the desired segment:

Select all

applsys.fnd_id_flex_segments

on slowness, your query must be Making Full Table Scan as it is not using any index.
These columns are part of indexes:
hearder_id,

Select all

PERIOD_NAME ,  
CODE_COMBINATION_ID, 
SET_OF_BOOKS_ID

takes a look at how they are in your environment.

[marquesjr]

Thanks, I found yes it is in

Select all

apps.fnd_flex_values_vl.DESCRIPTION

on the counterpart, debit and credit, I am still looking for, launches are in batch but there is no field that specifies the counterpart.

Thank you for help Daniel, I will continue looking for a way to get the counterpart and post here if I stay.