Setting Up Group Account Numbers for E-Business Suite

993000

Hi All ,

I have installed and configured the OBIA 11.1.1.10.1 with Oracle EBS version R13 .I am in process of configuration of required src files i.e file_group_acct_codes_ora for data loading  .

I have checked my ebs source database for the details of Group_Account_num .But I am not clearly aware about how to get the details from oracle ebs and what tables I need to refer to get the details .Is there any queries are there to get these required details .

I have checked for chart of Account in Oracle EBS and found in GL_CODE_COMBINATIONS and found only one chart of account is there for my customer .

Could you please let me know how to know the GROUP_ACCT_NUM details and From FROM ACCT and TO ACCT details to pu in the file_group_acct_codes_ora  .

I have gone through the Oracle blogs and sites there it is mentioned about the how to map the Oracle general ledger account to group account numbers but not cleared about the how to get these details and from which tables we will get these details .

Kindly help us on this if any one has experience on this .

Thanks

Thomas Dodds

You set the mappings with your finance/accounting department ... to start the conversation you can run the following against EBS:

SELECT

ST.ID_FLEX_STRUCTURE_CODE  "Chart of Account Code"

,SG.ID_FLEX_NUM            "Chart of Account Num"

,SG.SEGMENT_NAME               "Segment Name"

,SG.APPLICATION_COLUMN_NAME    "Column Name"

,SG.FLEX_VALUE_SET_ID          "Value Set Id"

,SG1.APPLICATION_COLUMN_NAME   "Parent Column Name"

FROM

FND_ID_FLEX_STRUCTURES ST

INNER JOIN FND_ID_FLEX_SEGMENTS SG ON ST.APPLICATION_ID = SG.APPLICATION_ID AND ST.ID_FLEX_CODE = SG.ID_FLEX_CODE AND ST.ID_FLEX_NUM = SG.ID_FLEX_NUM

INNER JOIN FND_FLEX_VALUE_SETS VS ON SG.FLEX_VALUE_SET_ID = VS.FLEX_VALUE_SET_ID

LEFT OUTER JOIN FND_ID_FLEX_SEGMENTS SG1 ON VS.PARENT_FLEX_VALUE_SET_ID = SG1.FLEX_VALUE_SET_ID AND SG.ID_FLEX_NUM = SG1.ID_FLEX_NUM AND SG.APPLICATION_ID = SG1.APPLICATION_ID AND SG.ID_FLEX_CODE = SG1.ID_FLEX_CODE

WHERE

ST.APPLICATION_ID = 101

AND ST.ID_FLEX_CODE = 'GL#'

AND ST.ENABLED_FLAG = 'Y'

ORDER BY 1,2,3;