E1: 09: Frequently Asked Questions Regarding the Chart of Accounts
(Doc ID 664720.1)
Last updated on OCTOBER 25, 2023
Applies to:
JD Edwards EnterpriseOne General Ledger - Version XE and laterInformation in this document applies to any platform.
Purpose
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? |
| Question 14: Can you change Object Account fields in EnterpriseOne from 4 to 5 for Income Statements and leave Balance Sheets at a 4 ? |
| 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? |
| 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 |