Chart of Accounts Setup
Discussion List
-
Unable to purge files from Load Interface Files for ImportSummary: We have historic files available when using process Load Interface Files for Import > Import Segment Values and Hierarchies. We are unable to use Scheduled Proc… -
How can I use SQL to define a segment based on the ledger?Summary: The client has two ledgers and one of them has only one company - "01". I would like the value for company to already be filled in in this company's ledger and …
-
Role for access 'Manage Chart of accounts value set values'Summary: HI Team, As per the business requirement we need to create a custom role which having privilege to access 'Manage Chart of accounts value set values' work area.…
-
What is "Adjustment Period" in General Ledger Accounting Calendar and its reporting impactsWhat is "Adjustment Period": When we configure General Ledger module, one of the important setup is Accounting Calendar. In that, there is a functionality called- Adjust…CA Nirmal Choudhary 806 views 7 comments 1 point Most recent by PandurangJ General Ledger & Intercompany -
Need help on a query with Account hierarchiesSummary: I need to retrieve GL balances based on the account hierarchies and I am not able to get it for the 2nd level child. I am able to do it for one level. In the qu…
-
How to get the General ledger Accounting rules filters reated Code cominations from primary ledgersSummary: We are trying to get the code combinations from Primary ledger based on the General ledger Accounting rule filters defined for Secondary ledger code combination…PavanMotamarri 21 views 2 comments 0 points Most recent by PavanMotamarri General Ledger & Intercompany
-
Do you have to manually add another year to the Accounting Calendar each year?Hi there, The accounting calendar I am working with has monthly periods starting January and ending December. It is currently 2023, I have clicked the 'Add Year' button …
-
Questions about Maintain Chart of Accounts Hierarchies processWe recently discovered we had an issue with a custom BIP report that was built for us by our implementation consultants. Long story short, we discovered that any new com…MDeming 3 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Third party control accountSummary: I am sure I know the answer to this question, but I am hoping I am wrong. Is it possible to turn off Third party control accounts for specific ledgers only? For…Jason Rausch 23 views 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany -
Using value sets with table validation for segments of the Accounting Key FlexfieldContent We have a CoA segment to capture the project number from Project Costing transactions. Whilst it is usually not considered best practice to have a project segmen…Andy May-Coates-Oracle 65 views 4 comments 3 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Import Journal Batch Name is changing after importing journals in UISummary: Import Journal Batch Name is changing after importing journals into system. Content (required): Users are trying to import the Journal batches with batch name a…Kumar 57 52 views 3 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Edit Historical RatesSummary: Edit Historical Rates Content (please ensure you mask any confidential information): When option is selected along with the period the excel is blank when opene…CraigX 21 views 7 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
Changing Year for a GL FISCAL CalendarClient has come with a business requirement when in currently they have defined a fiscal calendar. ex 1-Apr-2019 to 31-Mar-2020 and selected year as 2020, but they what …CMA Vishal Kumar 23 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Approval Flow for Adding New Accounts?Summary: Looking for a way to add a review process for new accounts and cost centers in the Chart of Accounts Content (please ensure you mask any confidential informatio…
-
Why CVR Combination set don't have precedence on Related Value in GL?We are using CVR Combination set to allow all SEGMENT 2 with SEGMENT 3 (00). On the other hand, our Related Values prevent those kind of combinations. The documentation …Francois Desjardins 13 views 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany -
Why there is a segment label as FA_COST_CTR in Manage Segment Label Setup?Summary: Hello Everyone, In Manage Segment Labels setup, there is an Oracle seeded segment label for Cost Center Segment and its code is FA_COST_CTR. Why its FA_COST_CTR…Dhrumil Pandya 11 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Cannot change data access in GL UI. LOV is empty.Summary: Content (please ensure you mask any confidential information): Data access set LOV is empty in the "Change Data Access" in GL UI. The user has been granted and …Dian Minshan 25 views 3 comments 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany -
Secondary ledger is not available to select on Inquire and Analyze Balances or SmartViewSummary: We are in the process of creating a secondary ledger. The secondary ledger has been created, chart of accounts created, value sets created, primary to secondary…Nicole Croll 24 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Can a new dimension be added that can be used in smart view and financial reporting studio?Summary: We are on Oracle Fusion Cloud 23C. There is a requirement to add a new dimension to classify an account as GAAP or non-GAAP that can be used in SmartView or Fin…Daisy.Dabandan DS 13 views 2 comments 0 points Most recent by Daisy.Dabandan DS General Ledger & Intercompany
-
Inquiry Regarding Balance Transfer to Secondary Ledger and Reporting CurrencySummary: Content (please ensure you mask any confidential information): Dear Community Members, I wanted to reach out to seek your valuable insights and expertise regard…Patrick Chrabieh 35 views 2 comments 1 point Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
How to create DFF in related value set values ?Summary: We are maintaining related value set and value set values in Chart of Accounts. Is there any way we can create a DFF in related value set values page to identif…Dhrumil Pandya 11 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
COA Values in Arabic DescriptionSummary: Hi Experts We have created Value Set Values in English Language. If the user Logins with Arabic Language then value Description is appearing in English Is it Po…Satya Mothe 13 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Inquire on Detail Balances: When picking Account from List, Version shows [Natural Account]@[100000]Summary: Hi, Within the GL Module -> Tasks List -> Inquire on Detail Balances, when I am selecting from the Natural Account field (Will click on the drop down, "Search")…Akbar Ahmed 21 views 1 comment 0 points Most recent by CA Nirmal Choudhary 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 1.1K views 8 comments 4 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Is there a way to update 'Control Account' value on code combination level without using the 'InheriSummary: The page 'Manage Account Combinations' does not allow us to update 'Control Account' value, the field is read-only. Is there any possibility to update this fiel…Guy Van Nuffel 12 views 2 comments 0 points Most recent by Guy Van Nuffel General Ledger & Intercompany -
can we merge two values in certain value set?Hello Oracle Customer Connect community, We recently implemented a new hierarchy for our departments, and we'd like to find a way to merge the old department values with…
-
Related Valueset Values upload any API or WebserviceSummary: Is there any API or Web-service for Related Value-set Values upload Content (required): We are maintaining the Related Value-set Values. For automation/integrat…Hemant T 52 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Is it feasible to use or enable future segment as Intercompany SegmentSummary: Hi Experts Current we have 8 Segment in Prod COA as below 1. Company 2.Line of Business 3. Activity 4. Location 5. Department 6. Natural Account 7.Future1 8. Fu…Satya Mothe 23 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Chart of accounts BI Object MappingSummary: We used the RI spread sheet to setup our COA structure and other items in our fusion sandbox instance. We want to use these in OTBI so I when I checked the BI o…
-
Inherit Segment Value Attributes Scheduled Job SecuritySummary: We would like to know which Security/Job role(s) allow business users to run Inherit Segment Value Attributes Scheduled Job Content (required): Our business hav…