Category 337
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
-
Close monitor and Business UnitsSummary: The user's guide is refering to Business Units. Is not working from me. Did anyone made it work? Reference The period status information that's displayed is bro…Pablo Schenquerman 4 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
RESTAPI for audit reportSummary: We've Audit reports to identify/track the changes happened in the application. As part of MCA India audit, its required to keep a daily backup of audit reports.…Sujatha Kumari 12 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to exclude natural account segment from Revaluation Process?Summary: We need to exclude some Natural Account value from Revaluation Process Content (please ensure you mask any confidential information): When we run Revaluation Pr… -
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 22 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How can I pull in all ledgers within one report regarding 'Subledger Period Close Exceptions Report'We have 20 + ledgers and have to run a report for each due to 'Ledger' as a required field. Does anyone have any workarounds if Oracle has not created another BIP report…
-
Closing Journal were generated with only one line with amounts in debit and credit.Summary: When executing the process “Create Income Statement Closing Journals”, two line items with a debit and a credit amount were generated. When executing the proces… -
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 24 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 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How do we efficiently get a detail by contract of the RMCS accounts?Summary: We implemented RMCS in October 2023. We created a report to allow us to perform netting under ASC606. The report has each of the RMCS accounts but they do not t…Nefertiti 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Receivables & Collections
-
Do we have BICC PVOs for GL_SETS_OF_BOOKS and GL_TRANSLATION_RATES?Need to extract data from cloud tables- GL_SETS_OF_BOOKS and GL_TRANSLATION_RATES. I am unable to find any PVOs in any lineage sheets. Do we have PVOs available for them?Neha Aishwarya 11 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
-
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 -
import intercompany transactions do not check AP AR periods statusCreate manual intercompany in UI when AP AR periods are closed, it will prevent us to submit, pop up message will show saying AP or AR periods are closed BUT when use sp…
-
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 1 view 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
-
The clearing option Enter Manually On All Journals isn't permitted for processing subledger entriesSummary: We ran create accounting for over a million of receivable transactions. The Create Accounting Execution Report showed 3 transactions having the error message be…RB Vasquez 11 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Subledger Accounting & Accounting Hub -
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
-
Intercompany - Purge Interface Tables - Allow context purge of data optionSummary: Intercompany - Purge Interface Tables - Allow context purge of data option. what does it actually mean? More information required such as Example between Yes an…JUC189 31 views 6 comments 0 points Most recent by Baidehi Nanda–Support-Oracle 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 11 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…
-
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 31 views 7 comments 0 points Most recent by Rajnish Sinha-Oracle General Ledger & Intercompany
-
What's the best practice to limit revaluation journals cannot be modifiedHi team, We are a global company and APAC users request to have their revaluation journals cannot be updated after generation under audit requirements. We know that we c…Marcy Gao 11 views 7 comments 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Journal approval based on COA segment valuesSummary: The "Project" is one of the segments in our chart of accounts. Our journal approval process is currently defined as follows: If the Project segment value is zer…Richa Arora-Oracle 31 views 3 comments 0 points Most recent by Basant Parihar General Ledger & Intercompany
-
Audit report to capture critical events of user activitySummary: Hi Everyone, One of our clients is looking for the reports that show logons, access attempts, and data modifications. Does any seeded report exists in the Oracl…Mahamood Sk 11 views 1 comment 0 points Most recent by Razvan Paduraru-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.4K views 3 comments 0 points Most recent by Yeung Shing Keith General Ledger & Intercompany -
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
-
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 21 views 5 comments 0 points Most recent by Rosa Alvarado 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…