Launches GL - EBS 11

Perguntas relacionadas a questões técnicas do Oracle EBS. Criação de Concorrentes, Value Sets, Alerts, Forms Personalizations, Configurações, etc
Post Reply
marquesjr
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 77
Joined: Wed, 05 Dec 2007 10:51 am
Location: Fortaleza - CE

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
Moderador
Moderador
Posts: 641
Joined: Mon, 03 Sep 2007 3:26 pm
Location: Fortaleza - CE
att,

Daniel N.N.

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
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 77
Joined: Wed, 05 Dec 2007 10:51 am
Location: Fortaleza - CE

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
Moderador
Moderador
Posts: 641
Joined: Mon, 03 Sep 2007 3:26 pm
Location: Fortaleza - CE
att,

Daniel N.N.

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
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 77
Joined: Wed, 05 Dec 2007 10:51 am
Location: Fortaleza - CE

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
Moderador
Moderador
Posts: 641
Joined: Mon, 03 Sep 2007 3:26 pm
Location: Fortaleza - CE
att,

Daniel N.N.

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
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 77
Joined: Wed, 05 Dec 2007 10:51 am
Location: Fortaleza - CE

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.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest