To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
General Ledger & Intercompany
Discussion List
-
Connect GL Location Segment to Location AddressHi, we have Locations in Oracle we need to associate with the Location Segment in the GL Account String. Scenario: We have Account Aliases we are using to decrement our … -
Can we open the new GL period before closing the old oneSummary: Currently our Finance team closes the previous months GL period on 8th working day of the month. This is causing lot of journals to be left Unposted as the new … -
Reference Date in GL Journal HeaderSummary: Hi do you know, if it's possible to use Reference Date in the Journal Header level to recalculate value from Primary Ledger to Secondary Ledger with exchange ra… -
How can we solve the issue of only one parent value showing in member id selection in SmartviewHello Experts, We have noticed that when selecting the member ID in Smartview, only one parent value is shown on the "All Department" member ID, while the other parents …
-
Company Intercompany CVR ruleSummary: Hello, Can we setup a global CVR where any code combinations with same Company and Intercompany code segments are not allowed? exp: Company 1234 is not allowed …
-
All the GL users should be able to see the Journal Approval Workflow (Future) for all the JournalsSummary: There is a business requirement that all the users who has access to Create Journals, should be able to see Journal Approval workflow for all the Journal batche…
-
How to change Amount Masking Per Millions in Oracle Fusion?Summary: Right now, the amount masking format is 1,000,000 but we need to change the format to 10,00,000 at the instance level. Content (please ensure you mask any confi…
-
FSG to FRS reportHow can an FRS report be created using all of the logic from an FSG report? My goal is to create an FRS report in Fusion that is identical to the FSG report that is avai… -
Enabling audit trail on intercompany transactions.Currently on the fusion instance audit trail is only enabled for intercompany setups, but not for the entire flow of the transaction STEPS- Navigate to Setup and Mainten…
-
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…
-
Best way to create reports from Oracle General Ledger data?What's the recommended approach for building custom reports from Oracle General Ledger data.I'm building a custom periodic trial balance report in Oracle. I need to incl…
-
How to make journal lines context default based on ledger for existing contextSummary: How to make journal lines context default based on ledger for existing context Content (please ensure you mask any confidential information): We have two ledger…
-
“Action failed. ORA-00942: table or view does not exist.” correct import errorsWe ran create opening balances for one of the reporting currency, that process was ended with warning, we are trying to fix this from correct import errors, when we sear…
-
Journal Approval- How to create a separate approval flow for backdated journal with a grace period?Hello all, I'm trying to create a separate journal approval flow for a specific entity. All journals posted after the month end (i.e., May-24) but within the first 6 day…
-
General Ledger Document Sequencing not workingSummary: GL document sequecing not working as required Content (please ensure you mask any confidential information): I have done below setups but still document sequenc…
-
Intercompany batch approval missing attachmentSummary: When creating an intercompany batch transaction, the user always imports an attachment so that the intercompany approver knows what the transaction is about. Wh…
-
Unable to define a secondary ledger with data conversion level of balanceSummary: Unable to define a secondary ledger with data conversion level of balance. I am defining a secondary ledger with same currency, Different COA Structure (Segment… -
How to set up approval limits for intercompany transactionsHow to set up the approval of intercompany transaction with the following requirement: First approver: Controller Second approver: CFO for transactions above 1 million
-
Can we send email of Create accounting Execution report details in PDF format o/p as scheduled dailySummary: Can we send email of Create accounting Execution report details in PDF format output as scheduled daily We would like to schedule create accounting report and g…
-
How to retrieve value sets relationships with REST APISummary: Hello, Some chart of accounts value sets are related to each other. How can I retrieve the relationships between the values of these sets using a REST API? Than… -
Is bulk uploading of Allocation rules in Calculation Manager possible?Summary: Is bulk uploading of Allocation rules in Calculation Manager possible? Content (please ensure you mask any confidential information): Is it possible to upload/u…
-
FBDI FOR INTERCOMPANYSummary: Currently when the user creates Intercompany transactions through FBDI , if there are 50 transactions then the scheduled process "Import Intercompany Transactio…
-
How to create a dynamic Accounting Period for Oracle Cloud EssbaseWith our on premise Essbase cube we were able to create an Accounting Period variable that contained the value of the current month. Each month we would update that vari…
-
How to generate AR/AP invoices from Intercompany AllocationsSummary: Can someone supply a use case and detailed steps to generate AR/AP invoices from Intercompany Allocations by running "Generate Intercompany Allocations". We hav…
-
-
Can we change the functional currency without reconfiguring/reimplementing the system ?Dear All, Is it possible to change the functional currency for primary ledger without reconfiguring and data migration ? Lot many countries in Europe had changed their e… -
Batch Number logic for Intercompany transaction through spreadsheetSummary: Batch numbers given while uploading spreadsheets are overridden by the application once they are uploaded. If the same batch number is used in the spreadsheet, …
-
Allocation Rule - GL Approval required on few, not on othersSummary: At Journal Source - Allocation, we can have Journal Approval Required checkbox. GL team wants most of the Allocation rules to be posted without Journal Approval…
-
How to create Auto Rejection rule for unbalanced Journals in SpreadsheetCurrently any journals created through UI goes for approval. Even if the entry is unbalanced in the entered currency its warns the creator but submits it for approval. I…
-
Journals are transferred with Journal Name as "Date(DD-MM-YYYY)" suffixed with CategorySummary: When Create Accounting is run from any Subledger and the accounting entries are transferred to GL. The Journal name is "Date(DD-MM-YYYY)" suffixed with Category…