Chart of Accounts setup
Discussion List
-
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 13 views 2 comments 0 points Most recent by Sanskrati Borade General Ledger & Intercompany -
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 21 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… -
20D:How to Create Related Value Sets for a Chart of AccountsSummary In 20D, Related value sets provide a new way to define dependencies between two segments in a Chart of Accounts to ensure only valid combinations are used during…Rahul Asthana-Oracle 134 views 7 comments 6 points Most recent by ESSAHLI AHMED General Ledger & Intercompany -
Is it possible to update the summary and posting flags for value set values in FBDIWe need to update the summary, allow posting and allow budgeting flag with the help of FBDI. But when I am trying to do this its giving an error that validation failed. …Swati Bobade 1 view 3 comments 0 points Most recent by Nikhil_Jain10_07 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 … -
Segment value security restriction for cost center works on Core HR and Payroll module?We have a requirement to restrict the cost centers in the 'costing of position' task. Can we achieve it by enabling segment value security? segment value security restri…Sanskrati Borade 1 view 0 comments 0 points Started by Sanskrati Borade General Ledger & Intercompany -
Limitation on number of parents in ERP GL Account HierarchyI tried adding another parent column in the RapidImplementation sheet for uploading account hierarchy but it encountered an error. My question is — is there a limitation… -
Cross Validation FBDI file getting error "Type Mismatch"Summary: Cross Validation FBDI file getting error "Type Mismatch" Content (please ensure you mask any confidential information): Hi , We are getting below error while tr…Balakrishna S 51 views 6 comments 0 points Most recent by Finance Team General Ledger & Intercompany -
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 -
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 1 view 0 comments 0 points Started by Muhammad Soban Maqbool General Ledger & Intercompany -
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 2 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 45 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 23 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 111 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…