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
-
Defining Approval rule in SRC for late journal entries(post business day 10th)Summary: We have a requirement to create an approval rule for journals based on journal batch creation date. All journals created after populated accounting period end d… -
We want to put a scheduler for every 1st of the month. Is it possible?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Remove option to run Purge Interface Tables in Scheduled ProcessesSummary: In Schedule New Process, I can run Purge Interface Tables for an Intercompany role. Is there a way to decouple it so that users are not able to run the program?…
-
Is there a way to automate the configuration steps when there is a new entity COA value?When there is a new entity value that feeds into ERP from EDMCS, we then complete the required configuration steps for the new entity, such as Manage Legal Entity, Assig…
-
Clear TO DATE of Account Combination using FBDI - Error ORA-01841Summary: Hello, I am attempting to use FBDI to clear the value out of the TO DATE field (return it to default, empty, blank or null). If I leave it blank, it skips over …
-
Does account analysis report has PO Number?Summary: Does account analysis report has PO Number in data model? Content (please ensure you mask any confidential information): Version (include the version you are us…
-
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…
-
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.