Chart of Accounts Setup
Discussion List
-
Is there a table that stores ALLOW_POSTING_FLAG?Oracle Fusion Cloud Financials 25A Is there a table that stores the value for allow_posting_flag for a segment value loaded into gl segment values? that field can be loa… -
How to derive Cost Center on Payables line for Taxable Journal?When creating a Taxable Journal like below example including a Cost Center on both debit and credit lines, it seems not to be possible to derive the Cost Center on the a…
-
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 …
-
Can we change/Edit current Balancing segment Hierarchy?Summary: Segment hierarchy change Content (please ensure you mask any confidential information): Currently we have a segment hierarchy but wanted to change to different …
-
Transaction number as per Document sequence not updating on FBDI AR invoiceSummary: When uploading AR Transaction through FBDI I cannot see the document sequencing followed on the transaction number whereas when I am passing invoice manually it…
-
Is there a table that stores COA Segment Value changes?Summary: To provide context, we would need to investigate when some of our segment values have been enabled or disabled under Manage Chart of Accounts Value Set Values p…Mira Dela Cruz 1 view 1 comment 0 points Most recent by Chandra Sekhar Kadali-Oracle General Ledger & Intercompany
-
alternate account for Purchase OrdersSummary: Hi Team, We wanted to disable certain COA values and provide alternate account in its place so that the inflight transactions would not get affected. But we are…
-
Requirement for New COA and Legal Entity Mapping to Existing Calendar and LedgerHi Team, We have a requirement to create a new Chart of Accounts (COA) and new Legal Entity, maping and using an existing Accounting Calendar and existing Ledger. Kindly…Prasanna002 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
REST API to get cost center detailsHello, Our customer has a requirement to fetch the cost center details using REST API. Customer uses only Oracle Fusion Finance modules. No HCM module is being used. As …Karunakar Tanneru-Oracle 1 view 2 comments 0 points Most recent by Karunakar Tanneru-Oracle General Ledger & Intercompany
-
Oracle Fusion ERP COA event trigger OIC integrationMy goal is to trigger an OIC integration when the Charter of Accounts (COA) is changed in Fusion ERP, what event can I subscribe to in OIC? If there is not a built in ev…Karthik Giddu 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Account hierarchy with Parent4, Parent1 and Child Value (Parent2 and Parent3 being blank)Hi Community, I need expert help on hierarchy. Summary: Right now we have account hierarchy for revenue and expense accounts. Parent4, Parent3, Parent2, Parent1 and Chil…Jakee_Agarwal-Oracle 14 views 2 comments 0 points Most recent by Jakee_Agarwal-Oracle General Ledger & Intercompany
-
Hierarchy for Legal entitiesSummary Hierarchy for Legal entitiesContent Hi Have a couple of questions on Legal entity creation in Fusion 1.We have a requirement where we want to define a tree for l…
-
The search in accounting flexfield segments is searching only based on valueSummary: As part of the client's Oracle setup, the Accounting Flexfield consists of 10 segments. All value sets have been imported with both Value and Description fields…
-
Account, sub account and other segment description in German language through EDMCS for Fusion GLSummary: Hello, We need account, sub account and other segment description in German language through EDMCS for Fusion GL, if anyone has idea on this worked your help wo…
-
Can I create custom financial categories values for the chart of accounts segment?Summary: We are interested in creating some custom values for the Financial Category column on our account segment. Is it possible to customize this drop down list of va…Lindsay C 31 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
General Ledger - delete unused Hierarchies, delete unused GL CubesSummary: HCM has gone live, in Production. During HCM implementation, a ledger and chart of accounts were defined that are not being used for the ERP implementation that…
-
Can we add DFF to chart of account value set codeWe need to add a DFF at one value set code of COA values. Is it feasible If yes, can you please help us with the stepsSrija 1 view 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
Is there a way to extract all audit log entries detailing changes to the COA structure?Summary: We are asked to provide an extract all audit log entries detailing changes to the Chart of Accounts structure (segments, values, hierarchies) and other critical…
-
Segment Security ChangesSummary: What are the steps to edit/ add the existing data security for a segment? Example: Created a segment security condition and policy and assign to a custom SVS ro…
-
What all points to tate care before end dating a Department segment?Summary: We are asked to end date a value of Department segment. We checked the points mentioned in the below link. What are the steps to disable a department value — Cl…
-
Instruction: Add a (DFF) to a specific Value Set for additional COA attributesSummary Add a context sensitive DFF to a value set (COA)Content One of the requirements for my organization was to add DFF's to the value sets of our chart of accounts, …Bobby Choate 296 views 4 comments 3 points Most recent by Jakee_Agarwal-Oracle General Ledger & Intercompany -
When Cross-Validation Combination Set is better than Cross-Validation Rules?Cross-validation combination set and cross-validation rules have the same purpose, which is to prevent invalid account combinations during journal entry. These two are d…Butch Melvin 32 views 4 comments 1 point Most recent by Neil Ramsay-Oracle General Ledger & Intercompany
-
Use SQL predicate in segment value security conditionHi, we are trying to create segment value security condition using SQL Predicate. The requirement is to show all the segment values except for few. This segment has hier…D Mandal 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Restrict Value Set Access per COA Admin in Setup Using Page ComposerWe have multiple Chart of Accounts (COA) structures, each managed by a different administrator. We want to restrict access in the “Manage Chart of Accounts Value Sets” p…Patrick Chrabieh 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Is there a way to delete unused combinations from GL_CODE_COMBINATIONS tables in Oracle Fusion CloudIs there a way to delete unused combinations from the GL_CODE_COMBINATIONS table in Oracle Fusion Cloud? These combinations have zero balance and are no longer used in o…
-
Is there a workaround to view combinations for a combination set?Summary: I have followed steps to View Combinations for a Combination Set available in Oracle Help Center. When I get to step 8 listed below to download it freezes my pa…Rosa Alvarado 22 views 5 comments 0 points Most recent by Rosa Alvarado General Ledger & Intercompany
-
Can I add non-qualified custom Segment Label to existing COA Segment which is already in use?Summary: We have requirement to create OTBI Report to fetch data for a particular COA Segment. The segment is not visible in Subject Areas. We have already tested it in …Satya Kr 1 view 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
How to prevent changing a segment value when an Alias is being used?Summary: We are trying to figure out a way, that an alias could be used to enter some (not all segments) of the GL Code combination (when entering transactions), and whe…Jeremy Downey 006 1 view 3 comments 0 points Most recent by Jeremy Downey 006 General Ledger & Intercompany
-
How can I change segments in an existing chart of accounts structure?Summary: The Customer wants to changue the order of the. segments in the char of account structure, in this moment we already did the configuration but they have no made…Fabio Gonzalez 1 view 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Segment Value Set Security Control for Ledger SetWe have enabled Segment Security control by ledger-wise and have also a ledger set. When we assign the ledger set to a user and they select a ledger from the LOV while m…Sandeep Nihalani 1 view 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany