Chart of Accounts Setup
Discussion List
-
Balancing Segment Change Requirement for a Specific LedgerOur organization has multiple ledgers, all of which use the same Chart of Accounts (CoA) with the following segments: Company Location BU / Department Account Product Ch…Nimesha Yatigammana 2 views 0 comments 0 points Started by Nimesha Yatigammana General Ledger & Intercompany -
Segment Value Security (SVS) is not working when created the SVS rules using spreadsheet.We have enabled security for cost account segment, selected all business functions and saved it from below navigation - Setup and Maintenance > Manage Chart of Accounts …Sanskrati Borade 1 view 0 comments 0 points Started by Sanskrati Borade General Ledger & Intercompany -
Is the “No Manual Journal” control at COA value level enforced globally across all BU ?Summary: The “No Manual Journal” control has been implemented at the COA value level and the same COA instance is shared across multiple Business Units. However, certain…Muhammad Soban Maqbool 2 views 0 comments 0 points Started by Muhammad Soban Maqbool General Ledger & Intercompany -
How to change CoA Future 1 segment name?Hi, We are a few years post-implementation. Our CoA was created with 2 spare segments for future use. We now need to start using our Future 1 segment and wish to rename … -
How to setup Descriptive Flexfield to Key FlexfieldHi, How do I setup Descriptive Flexfield to Key flexfield? I want to manage the values as follows. Account code | flg(attribute1 DFF) 0001 | Y 0002 | N Thanks -
Is it ok to include period(.) and comma(,) character in BU name and LE name?Is it ok to include period(.) and comma(,) character in BU name and LE name? if we include above characters, will it harm anywhere?Kalpesh Salunke-Oracle 1 view 2 comments 0 points Most recent by Kalpesh Salunke-Oracle General Ledger & Intercompany -
Update account type through FBDI templateHi Team, We are trying to update account type for Natural account values through "Segment Values and Hierarchies" FBDI template. It is going into errors saying "Account …Hemlata Mehra 11 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Create Primary Ledger unable to see the Chart of AccountI am unable to see/select my Chart of Account while creating new Primary Ledger. I have deployed the flexfield and there is no error. What could be the issue?Praveen Nayak 4 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
SmartView HsGetValue Function Not Working For Parent NodeSummary: In some cases, some of the parent nodes are not yielding results for our HSGetValue formula due to the following error. We did review the KB25587 but I am not s…Wilson Chelakadan 11 views 3 comments 0 points Most recent by Wilson Chelakadan General Ledger & Intercompany -
How to Convert List of Numbers into Contiguous Range- A Range Maker Excel ToolIn Oracle Cloud ERP Financials, there are several use cases where an implementation consultant is required to convert list of numbers to range. Below are some use cases:…CA Nirmal Choudhary 11 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
dependent segment valuesSummary: Hi Team, we have a requirement where one segment is dependent on other for values. For example: we have division and Activity as 2 segments. When we select one … -
Disable an entity in OracleSummary: We have multiple entities i.e. Ledger and assigned Legal Entity and Business Unit. Are there any best practices for this for disabling an entity? I know that we…Vikash123 41 views 2 comments 0 points Most recent by Subramanian Nilakantan General Ledger & Intercompany -
CoA Deployment ErrorSummary: When we are deploying the COA we are getting following Error: oracle.apps.fnd.applcore.flex.runtime.util.service.FlexfieldXSDGenerator$CreateSchemaFileException… -
Using Rest API to update ValueSet ValuesSummary: Hi there. I am attempting to use the following REST API to update attributes of values within a given value set /fscmRestApi/resources/11.13.18.05/valueSets/{va… -
How the New Feature "Segment Value Security" 24D release will have Impact on old Segment Sec Rules ?Summary: Our Customer are using the Segment Security Rules (SR rules) from 2019 for the PBS (Company) and Cost Center Segments. Many SR rules were defined for the above …Baskara Sateesh-Oracle 41 views 2 comments 0 points Most recent by MichelleHaynes General Ledger & Intercompany -
PVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.SegmentValueHierarchyExtractPVOCan we use FscmTopModelAM.FinExtractAM.GlBiccExtractAM.SegmentValueHierarchyExtractPVO for reporting purposes In note Doc ID 2528114.1, it is mentioned that the table GL… -
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.7K views 21 comments 6 points Most recent by Jawahar General Ledger & Intercompany -
maximum values allowed in a value setSummary:We are in the process of storing the customer number value as part of the accounting flex field of the chart of accounts. We would like to understand the maximum…Wesraj 21 views 2 comments 0 points Most recent by veerendranath pulivarthi-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 102 views 2 comments 0 points Most recent by User_BMGJA General Ledger & Intercompany -
General Ledger Instance Strategy and SaaS LimitationsWe have a recent decision that requires validation and/or recommendation regarding ongoing deployments. Context: For all primary ledgers (one ledger per legal entity), t… -
Mapping primary ledger to a new COA secondarySummary: We have been working on setting up a secondary ledger for Brazil and I have mapped all the new (Secondary Ledger) COA to the old (primary ledger) COA. We are ab… -
How to enable account combination where the preserve attribute was set to "yes"Summary: The account combination was disables and Preserve attribute set to "Yes". I have set the disabled the Preserve attribute and ran the Inherit segment value progr… -
Secondary Ledger Posting error-Fusion cloudSummary: I have configured the Secondary Ledger with conversion level as subledger and completed the COA mapping . I have assigned myself data access set privileges for … -
Two Adjustment Period at year end to create with Rapid load fileSummary: We need to create two adjustment period at the year end and rapid load file do not have that option, please let me know any suggestion on this Content (required…Sam Samaddar 31 views 5 comments 0 points Most recent by Muhammad Hamza Hanif General Ledger & Intercompany -
Update chart of account values in bulk but errorSummary: I create the chart of account values in bulk but got the error with the file. Content (please ensure you mask any confidential information): I download the spre… -
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 … -
Clear TO DATE of Account Combination using FBDI - Error ORA-01841Summary: Hello, I am attempting to use FBDI to clear the value out of the TO DATE field (return it to default, empty, blank or null). If I leave it blank, it skips over … -
What is the purpose of Query Required field in Chart of Accounts Structure Instance?Can you help with both LOV as "Optional and Selectively Required" ?Ravi Kumar Rajak 81 views 2 comments 0 points Most recent by Antara De General Ledger & Intercompany -
Changing prompt for FUTURE KFF segment in COASummary: The company wants to change the Name/Prompt of a FUTURE segment in COA KFF. Please share your experience and thoughts regarding the considerations and consequen… -
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…Avilash1265 31 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany