Chart of Accounts Setup
Discussion List
-
Partial period closing rules for account groupsSummary: We need help with a period-end closing scenario. The department requested the creation of partial closing rules for account groups. For example, after a certain…Paulo Pessolato 2 views 0 comments 0 points Started by Paulo Pessolato General Ledger & Intercompany -
Recommended Number of Segments for COA ConfigurationSummary: Oracle Fusion Cloud ERP allows configuring the Chart of Accounts (COA) with 2 to 30 segments. We would like to know the recommended number of segments to mainta…Kasthuri.S 65 views 4 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Creating Chart of Account Value Set Values via APISummary: Using Rest APIs to create Chart of Account Value Set Values Content (please ensure you mask any confidential information): We have a requirement where a team is…Balwinder Singh 7 views 1 comment 0 points Most recent by George-Oracle General Ledger & Intercompany -
is possibile to have start date mandatory on value setis possibile to have start date mandatory on value set is possibile to have start date mandatory on value set
-
Segment Value Security in sql predicate instead of filterHow to create Segment Value Security rule in sql predicate instead of filter. (VALUE=0000 OR VALUE=8888 OR (VALUE>=1000 AND VALUEAbhisek Choudhury 8 views 0 comments 0 points Started by Abhisek Choudhury General Ledger & Intercompany
-
Change Retained Earning Future Segment ValueHi All, I need suggestion on below issue We have retained earning accounting combination mentioned in specify ledger option as 1001-0000-101001-0000(Future Segment)-0000…Jakee_Agarwal-Oracle 23 views 2 comments 0 points Most recent by Jakee_Agarwal-Oracle General Ledger & Intercompany
-
Proper CoA lenghSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Cannot Access Manage Departments and Manage Locations through Setup & MaintenanceSummary: Cannot Access Manage Departments and Manage Locations through Setup & Maintenance Content (please ensure you mask any confidential information): We are trying t…
-
Subledger accounting Mapping setsSummary: We are able to import bulk data using FBDI(XlaMappingsImportTemplate.xlsm template) into subledger accounting Mapping sets however, we have not found a way to u…
-
What would be the impact of creating large number of segment value security rule?There is a business requirement to create segment value security rules for each individual value of cost centers and there are around 30,000 cost centers. This would req…Sanskrati Borade 79 views 9 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Income Statement Not translated at Averange RateSummary: The Translation for Income Statement accounts happens at ending rate even if set up has average in the Account Dimension. Content (please ensure you mask any co…
-
Best way to manage mappings between full chart stringsWe are looking to manage relationships to map transactions from one unique chart string to another (between 2 different chart of accounts). It is likely that there will …Annie Karta 2 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to create a new version of chart of accounts without replaces old segment names in previous COA.Summary: When creating a new version of chart of accounts where existing parent codes and child codes are renamed, the old existing versions that has the old segment val…Sreenath Pachman 2 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Cannot add Tree Label when add tree node via REST APIHi all, I am able to add tree node to COA hierarchy by this API. But I cannot add tree label in the request body, otherwise there will be error "The request content does…
-
The Right Approach to Handle Cross Validation Rule ChangesWe are making changes to Cross Validation Rule. Specifically disabling some combination of the segments in Chart of Account. However, these combinations are already used…Zhen Hao Lean 27 views 3 comments 0 points Most recent by Zhen Hao Lean General Ledger & Intercompany
-
Impact of Increasing Segment Length Assigned in Existing and Deployed Chart of AccountsSummary: Business user has Chart of Accounts that is tied to AP, AR, CM, FA, and other modules. They would like to expand their cost center segment from a length of 4 di…Mira Dela Cruz 2 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle General Ledger & Intercompany
-
Impact of Replacing Seeded Intercompany Segment Label with Custom Label in COA StructureSummary: We need to understand the impact of replacing Seeded Intercompany Segment Label with Custom Label in COA Structure Also steps to resolve it. Content (please ens…Mayur Sethiya 2024 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to remove base hierarchies from selection without losing full member qualification?Summary: Hello, I have always created two versions of each hierarchy, both base and current, as is best practice. Client team has commented on the amount of hierarchies …Alex Bice 12 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to define the Chart of account segment Labels(Qualifiers)Summary: we are having requirement to create a new chart of account segment labels to assign for Value sets in the COA setup. Are there any way to come up with customize…Risandu olitha 239 views 4 comments 0 points Most recent by Risandu olitha General Ledger & Intercompany -
Add one child COA value in two parents of the same HierarchySummary: Add one child COA value in two parents of the same Hierarchy Content (please ensure you mask any confidential information): We are moving from EBS to Fusion. In…Sunil Nukala2 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Oracle fusion GL code combination erroring with error "This combination is invalid: PL/SQL"With valid segment values the system showing error as "This combination is invalid: PL/SQL" for the Journal code combinations. This error is not from the CVR rules and c…Swati Bobade 17 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to restrict cost centre (child) drilldown access to certain accountsSummary: Hi Team, I want to restrict the drill-down access (to cost center child level) for Salary & Wages (S&W) GL accounts in SmartView and FAW (Fusion Analytics Wareh…Gifty V 1 view 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
primary to secondary mapping - do we have limit of rows (or number of mappings) in Account RulesSummary: primary to secondary ledger mapping - do we have limit of rows (or number of mappings) in Account Rules mapping as we have 8 segment COA for Primary and 9 segme…S Mahapatra 11 views 2 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
Can we change the COA segment sequence once its deployed and Transactions are created?Summary: Hi All, Is it possible to change the sequence of Chart of Accounts (COA) segments after deployment and once transactions have been created? Will this impact any…
-
Issue Converting Accounting Calendar from Fiscal Year to Calendar Year in Oracle FusionSummary: Hello Team, We are in the process of modifying our existing accounting calendar setup in Oracle Fusion Financials. Currently, the ledger is using a fiscal year …
-
Scheduled process to run after new primary balancing segment value is addedSummary: For a situation where the "Review and Submit Accounting" process has already been run and a primary BSV has been added to the valueset at a later point, what ar…Akshaykshaji 1 view 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany -
Missing Operator in Manage Segment Value Security SpreadsheetSummary: Hi, We are considering to enable Manage Segment Value Security By Business Functions functionality as new 24D release. However, we see that Condition Operator i…Huyen Pham 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to update Chart of Account Segment Values and GL Account Hierarchy in bulk easily1. Update Chart of Account Value Set Values Sometimes there is a requirement to update COA value set values in bulk e.g. Value Description, Enable flag, Segment Value At…CA Nirmal Choudhary 4.3K views 17 comments 6 points Most recent by Narottam Singh Chauhan General Ledger & Intercompany -
Table based value set to retrieve detail values of COA SegmentSummary: Hi, We have a requirement to define a DFF retrieve Cost center segment values where summary option is "No". Content (please ensure you mask any confidential inf…Mahmoud9308 54 views 4 comments 0 points Most recent by Yomna Moustafa General Ledger & Intercompany
-
Account type Budgetary DR & CRSummary: Content (required): What is the purpose of Budgetary credit and Budgetary debit under "Accounts Types" in manage COA values? In what type of instances these can…