My Oracle Support Banner

E1: 09: Frequently Asked Questions Regarding the Chart of Accounts (Doc ID 664720.1)

Last updated on JULY 21, 2020

Applies to:

JD Edwards EnterpriseOne General Ledger - Version XE and later
Information in this document applies to any platform.

Purpose

This document is part of an Information Center - to see other documents related to Setup in General Accounting, please use the links provided below:

Information Center: JD Edwards EnterpriseOne General Accounting Product  > Information Center: Using the JD Edwards EnterpriseOne General Accounting Product > Core Processes > Setup > Doc ID 664720.1

This document contains answer to frequently asked questions related to the Chart of Accounts.

NOTE: For additional information on setting up Chart of Accounts, you may refer to Doc ID 2394187.2 .

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 General Questions
 Question 1: Why does an account have a 'M' in the Model Consolidation field but the corresponding Business Unit is not a Model?
 Question 2: Can I merge two or more accounts/account ids into one account and account id?
 Question 3: What is the significance of Chart of Accounts Refresh and how is the F0909 table linked to the F0901 table?
 Question 4: I have added a new account but did not run Chart of Accounts Refresh (R0909R). Will this have any impact on Trial Balance rollup or Annual Close?
 Question 5: What is the significance of Build Account Master Word Search Table program (R0901WS)?
 Question 6: How can I set system to enter third G/L Account Number instead of BU.OBJ.SUB while specifying an account?
 Question 7: What is the significance of a header account?
 Question 8: What is the impact of Fixed Asset Postig Edit Code (F0911.FPEC) field on the F1202 table? 
 Question 9: Can a "." be use as part of the Business Unit, Object, or Subsidiary? 
 Question 10: Is there a limitation to the number of accounts that can be added to the chart of accounts?
 Question 11: Why are Object account descriptions for LOD 7 to 9 displaying as 21 to 23 characters instead of its maximum 30 characters?
 Question 12: Why are some of the new accounts created in F0901 via the import feature not able to print on Trail Balance Report (R09410)?
 Question 13: Does EnterpriseOne provide a complete model chart of accounts?
 Defining Chart of Accounts
 Question 1: Can I add accounts to the F0901 table by importing data from excel?
 Question 2: Can I add accounts to the F0901 table directly using SQL?
 Question 3: What are the different options available for Account Separator Character?
 Question 4: Are there any repercussions of skipping Level of Detail (LOD) while setting up chart of accounts?
 Chart of Account Revisions
 Question 1: Are there any guidelines for modifying the Posting Edit Code of an existing account from 'L' to 'S'?
 Question 2: Is there a quicker way to modify multiple accounts rather than using Revise Single Account form?
 Question 3: Is there a batch process available to delete inactive accounts?
 Question 4: What are the different Global Updates available for Chart of Accounts?
 Question 5: Is there any way to prevent changes being made to Object and Subsidiary field?
 Question 6: Why do I get "Object Number Invalid as entered" error while trying to update an existing account?
 Question 7: Why does the Taxable Account field show as blank for some accounts in Account Master (F0901) table?
 Question 8: How to make it mandatory to enter an address book number for e.g. expense accounts.?
 Question 9: Why do I get "Account Number Invalid " error message, when trying to change PEC for a Job Cost type account from "I" Inactive to " " Blank?
 Question 10: I ran the Refresh Chart of Accounts  UBE (R0909R)  and found that object account range 0001-0160 do not appear on Chart of Accounts - Reference File - F0909 even though they appear in Account Master Table - F0901. Why did it failed to update the reference file?
 Account Category Codes
 Question 1: How can you access account category codes 24 - 43 in P0901 application?
 Question 2: Why does the R09205P report not print the Account Category Codes 24 - 43?
 Question 3: Why do I get error: "Not found in User Defined Code 09/xx" while trying to add/modify an account?
 Flex Accounting
 Question 1: Can the object length be changed in the account flex format setup (P0907)?
 Question 2: Is it valid to setup an account structure like BU.OBJ.SUB.BU?
 Question 3: In an account structure like BU.OBJ.SUB.BU, is it possible to create accounts with blank values of Object Account or Subsidiary?
 Question 4: Is there any limit to the size of account structure?
 Question 5: Why is the Business Unit in the Account Number (ANI) field left justified instead of right justified?
 Account Translations
 Question 1: Why do I see the account description in English in Work with Accounts (P0901) application even the user profile is setup with language other than English?
 Question 2: Why does the system not show the modified language translation description, during copying of an account?
 Question 3: Is there any program to upload the Account Translations into F0901D table?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.