General Ledger
Discussion List
-
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 -
newly added costcenter is not adding showing in smartviewUser recently added one cost center , but this cost center is not showing in smartview. Transfer General Ledger Balances to Balances Cubes process is running in every on…Rani V 11 views 2 comments 0 points Most recent by Global Customer Support | ASE-Oracle General Ledger & Intercompany
-
How the continuous transfer of budget balances to the budget cube affects tablesPlease tell me about the impact on tables of the ESS job "Continuous transfer of budget balances to budget cube: transfer schedule" being run. Currently, the BIP report …Akari Nuno 26 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Identify Journals Missing in Secondary ledgerSummary: Journals missing in secondary ledger. We need to indentify list of those journals and correct. Content (please ensure you mask any confidential information): Hi…Mayur Sethiya 2024 23 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Can we edit error message in ADFDI spreadsheet in Journal/ AGIS transaction import spreadsheet.We having a business requirement where to edit error message in ADFDI spreadsheet in Journal/ AGIS transaction import spreadsheet, EX when error out the details will com…Lokesh Koppera 14 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Is there any alternate way to run the Clearing Account Reconciliation for both PL and SL at once.Summary: User currently running Clearing Account Reconciliation separately for Primary Ledger and then for Secondary Ledger. As per business user they have to do TWO tim…Pavani Sala Sr Analyst-Oracle 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Display Negative Amounts in Red Font with Enclosed Parenthesis in the User InterfaceCurrently negative amounts in the UI are displayed in black font with a negative sign (-). We would like to know if there is a function/ ability available to display neg…Dayne Bautista 2 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Request to Show Latest Accounting Periods First in Inquire and Detail Balances UISummary: Hi Team, In the Inquire and Detail Balances screen, when we click on the Accounting Period field, the list of values (LOV) shows periods in ascending order (old…PrasadKota 31 views 3 comments 0 points Most recent by RaviGadia-Oracle General Ledger & Intercompany
-
API to fetch previous month accrual transaction accounting details integrated into AHCSSummary: There is a requirement to pull out the previous accrual transaction which was made by integrating subledger accounting transaction data into AHCS to generate ac…Sonal.jawalkar 1 view 2 comments 0 points Most recent by Sonal.jawalkar General Ledger & Intercompany
-
Requirement is to move one BSV from one legal entity to another legal entity of different ledgersSummary: The BSV value 534 is under UK Legal entity and UK ledger with some transactions. Now the requirement is the 534 BSV has to be removed from UK legal entity and a…Haritha Singampalli 15 views 3 comments 0 points Most recent by Vansh Bhardwaj-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…
-
Need Journal Posting Error Report or Table nameSummary Need Posting Error report or backend table name to see errored batches with detail posting errorsContent In General Ledger if Journal posting goes it to error, t…
-
How to create advanced rule in Workflow spreadsheet with condition 'Each' or 'None'?Summary: In BPM it was possible to use expressions like EACH and NONE in Advanced Mode. In the workflow spradsheets it is not present. At least it seems that way. How ca…Berwout J.R. Toonen 25 views 7 comments 0 points Most recent by Rajnish Sinha-Oracle General Ledger & Intercompany
-
How to create journal lines using REST API?Summary: How to create journal lines using REST API? Content (required): I can find resources for creating journals using FBDI or webservices but no resources on creatin…Abhishek Shukla 1.3K views 3 comments 0 points Most recent by Yeung Shing Keith General Ledger & Intercompany -
Frequent SmartView Value Replacement Issues on Fusion Cloud General Ledger and EPMHas anyone else experienced frequent issues with Excel SmartView on both Fusion Cloud General Ledger and EPM where it replaces missing or not found values/balances with …
-
DATE_CREATED_IN_GL field on the GL_INTERFACE tableHow does the DATE_CREATED_IN_GL field on the GL_INTERFACE table gets populated? As per the tables and views description: Oracle internal use only. Date journal import cr…JocelynC. 41 views 4 comments 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
Debit and Credit Columns Greyed Out in Oracle Fusion GL Journal EntryWe are working with a custom role in Oracle Fusion General Ledger. When users with this role create a journal, the Debit and Credit columns are visible but appear greyed…
-
24B New Feature: Accounting Data Archive and PurgeI am trying to Archive the data for the General Ledger as per the instructions provided in the new update 24B, but when i am trying to enable the data for archiving, it …
-
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
-
Redwood RoadmapSummary: Is there a roadmap of Redwood changes for GL and ERP generally please. Can find lots on HCM, but not ERP Content (please ensure you mask any confidential inform… -
Budget Data is not visible in GL_BALANCES tableSummary: We have created a custom scenario 'Budget' in Accounting Scenario value set. Then we have loaded data through Create Budgets in Spreadsheet task. The budget bal…
-
Control budgets not populating in LOV in Enter Budget in SpreadsheetSummary: Hi Team We have created a Control Budget: OH Control Budget_1 and completed all the required setups. The required roles and data access also given to the user b…User_LBP5E 27 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Journal approval - Level 2 approval should be triggered if journal (already in approval workflow) isSummary: Journal approval - Level 2 approval should be triggered if journal (already in approval workflow) is not approved by certain business day and not based on journ…Kolisetty Sudheer 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Incorrect Account type reclass from Revenue to ExpenseWe went live in April-25 and we noticed after loading all the TB's some of the expense account was wrongly setup as Revenue account due which it is impacting the FRS rep…Kunal Sinha 2 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Impact Of Changing the Account Type of Natural Account segment value from Revenue to ExpenseSummary: In the current landscape of our client's environment, COA values and related information will flow from EDMCS to Fusion ERP. Now there is a requirement from Cli…GokulRavi 16 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
How to generate CSV with huge data rows in GL Journal Import FBDI TemplateIsuse: When Journal Import FBDI template has huge data rows, for example more than 45000 rows, the"Generate CSV" button may not work properly or take too much time. Solu…CA Nirmal Choudhary 413 views 2 comments 0 points Most recent by CA Vara Prasad General Ledger & Intercompany -
Balances are not being translated at Average RateSummary: We have setup Reporting Currency for the purpose of translation and consolidation of balances. When translating Balances, system is not translating balances at …T Ravendra 24 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to handle foreign currency transactions in AP so that there is minimal impact on revaluationHi, Need to understand how to handle day to day foreign currency transactions in AP so that there is minimal impact on revaluation. For e.g, AP invoice in Foreign curren…Divya2307 43 views 5 comments 0 points Most recent by CA Nitesh Sharma General Ledger & Intercompany
-
What is the maximum currency precision and extended precision in Fusion GL?Hello Gurus, What is the maximum currency precision and extended precision in Fusion GL? Highly appreciated for any feedback/help in advance. Thanks and Regards, DavidDavid WHB 1 view 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Duplicate Error Manage RevaluationSummary: Hi Team, I am getting a You must specify a nonduplicate value in the selected filter segment. (GL-781538) when saving my revaluation filter on Oracle Fusion Gen…