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
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: Hi Team, In a custom BI report, when we schedule it for a large dataset (which typically runs for about 20 minutes) with the output format set to Excel (.xlsx),… -
Accounting Date Range in AutoPost Criteria SetSummary: Query: The user wants to post journals based on the Accounting Date. Does the “Autopost Journals” process work based on the Submission Date or the Accounting Da…
-
What is the purpose of Query Required field in Chart of Accounts Structure Instance?Can you help with both LOV as "Optional and Selectively Required" ?
-
can’t delete the journals that are currently in an error statusHello, In GL, I have journal entries that were imported and ended in error, and cannot be deleted. I have already executed the "Delete Import Data" and "Purge Interface …
-
Users are not able to see custom ESS jobsSummary: The custom ESS job has the permission for BI author role and assigned BI author role to the users still users are not able to see/run the Custom ESS jobs Conten…
-
Translate General Ledger Account Balances ParametersSummary: We use scheduling tool to submit programs in oracle cloud. Program 'Translate General Ledger Account Balances' has parameters as below when submitting from ESS.…
-
Delete Translation Balances parametersSummary: Hello experts, we use scheduling tool to submit programs in Oracle cloud space. Delete Translation Balances program has below parameters to submit by user but p…
-
How to add intercompany filter when performing manual clearing account reconciliationWe are trying to use clearing accounts reconciliation functionality in GL and currently struck with below 2 points How to filter based on intercompany segment Can we do …
-
Showing unbalanced intracompany journalSummary: I am interfacing journals directly to GL through OIC (From other Application). The journals involve multiple LEs under the same Ledger. Sequencing by LE is enab…
-
GL Calendar importSummary: Is it possible to import the GL calendar from UAT to Production via Export and Import functionality Content (please ensure you mask any confidential information…
-
How to get the last period of previous fiscal Period in FRSSummary: We create " Income Statement" . The report having Two Columns , Column A represent "Accounting Period Selected in prompt" i.e Sep-2025 Column B for Previous yea…
-
Get 201 Created response on fscmRestApi/resources/11.13.18.05/erpintegrations but process is not runSummary: Get 201 Created response on fscmRestApi/resources/11.13.18.05/erpintegrations but process is not actually run 56 = batch id from the file Content (please ensure…
-
SmartView HsGetValue Function Not Working For Parent NodeSummary: In some cases, some of the parent nodes are not yielding results for our HSGetValue formula due to the following error. We did review the KB25587 but I am not s… -
How to configure allocations when the same GL account has different recurring periods?Hi Team, We have a requirement to create allocation rules for recurring journals related to rent payments. For example: In the first month, rent of $100 is paid, and the…
-
Intercompany journal how to restrict the Receiver organization list while raising the batchOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): NA Description (Required): Intercompa…
-
Unable to define a secondary ledger with data conversion level of balance.WHY I AM NOT ABLE TO CREATE SECONDARY LEDGER WITH THE BALANCE LEVEL WHEN I AM FOLLOWING SAME COA,CALENDER,CONVENTION BUT DIFFERENT CURRENCY
-
Allocation rules are creating duplicate data for Elimination of intercompany transactionsSummary: We need a solution for an issue related to an Allocation rules that we have, which is created to eliminate the IC balances. We have two ledgers, but the primary…
-
GL History Prior to Jan for some year is missing from GL inquiries and SmartView reportsSummary: The GL data for transactions and balances prior to Jan 24 is not visible in system. The system returns no data when running a smart view report or when doing a …
-
Known issues with scheduling "Employee Vacation and Delegation Rules Report"?Summary: We're looking to automate the "Employee Vacation and Delegation Rules Report," but the documentation recommends against scheduling it recurrently (only running …
-
Net Income Account error in ADBSummary: After enabling Average Daily Balancing, I receive an error message on the Net Income Account "The Combination cannot be used, it either does not exist or using … -
How to default open accounting period in FRS report?We are creating a Balance Sheet report using FRS. We want to pass / default open accounting period as a parameter. How to do it? -
Is it possible to configure Intercompany Invoice number lengthSummary: Is it possible to configure Intercompany Invoice number length? Our Intercompany invoice numbers are currently 5 digits. This length is consistent with old Inte…
-
incremental run is possible in revaluation on new transactions for YTD balances.Summary: Our Business is exploring an option to run the revaluation only for transactions booked within a specific period (Workday1 to Workday6), rather than evaluating …
-
GL-HUB-AP report takes too long to runWe have a report which pulls GL, Hub and AP data by journal line level, it takes a long time to run since it is going back into Hub, which has +1mn transactions per day …
-
Moved: India-Specific Data BackupThis discussion has been moved. -
General Ledger Account Groups query criteria to include Chart of AccountsSummary: We are looking for Query by example on General Ledger Account Groups to include Chart of Accounts criteria, is anyone aware if this function available with a pr…
-
Custom journal category for Revaluation Journal only for the Poland ledgerSummary: Is it possible to use a custom journal category only for the Poland ledger, where the reversal method is Change Sign, while other country ledgers use Switch Dr/… -
While creating journal entry, JE creation date is overridden by system dateWhile importing journals through FBDI spreadsheet, the journal entry creation date is getting override by the sys date. Is it possible to populate the date that is given…
-
How to update custom accounting rules associated to the accounting class Expense AccrualHi everyone, we'd like to know how to update the accounting rules' conditions in order to customize the expense accrual process. Please see the attached file for additio…
-
How to print prompted value as a header text in FRS report?I am creating a balance sheet report in oracle using FRS. Business has a requirement keep accounting period, entity, budget scenario as prompts. I have created the promp…