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?
Launches GL - EBS 11
-
- Moderador
- Posts: 641
- Joined: Mon, 03 Sep 2007 3:26 pm
- Location: Fortaleza - CE
att,
Daniel N.N.
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).
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).
-
- 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
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'
-
- Moderador
- Posts: 641
- Joined: Mon, 03 Sep 2007 3:26 pm
- Location: Fortaleza - CE
att,
Daniel N.N.
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
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
-
- Rank: Analista Júnior
- Posts: 77
- Joined: Wed, 05 Dec 2007 10:51 am
- Location: Fortaleza - CE
Searching for segment_name returned the following:
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
-
- Moderador
- Posts: 641
- Joined: Mon, 03 Sep 2007 3:26 pm
- Location: Fortaleza - CE
att,
Daniel N.N.
Daniel N.N.
Dude,
I replied rushed because I was going out for lunch.
The description is in and you relate to this to pick up the ID of the desired segment:
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,
takes a look at how they are in your environment.
I replied rushed because I was going out for lunch.
The description is in
apps.fnd_flex_values_vl
applsys.fnd_id_flex_segments
These columns are part of indexes:
hearder_id,
PERIOD_NAME ,
CODE_COMBINATION_ID,
SET_OF_BOOKS_ID
-
- Rank: Analista Júnior
- Posts: 77
- Joined: Wed, 05 Dec 2007 10:51 am
- Location: Fortaleza - CE
Thanks, I found yes it is in
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.
apps.fnd_flex_values_vl.DESCRIPTION
Thank you for help Daniel, I will continue looking for a way to get the counterpart and post here if I stay.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 1 guest