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… -
Account Analysis Report - How to Pass Account Filter (P_FLEX_FIELD_RANGE_FILTER_ID)Summary: We are working with the Account Analysis Report in Oracle Fusion (ESS Job). When we apply an Account filter (Natural Account segment) in the report submission U… -
Has anyone set Allocation rule in GL to create Standard Recurring Journals?Summary Unable to create variable for Accounting PeriodContent Hi, We are trying to use allocation rule to create Standard recurring journals and I'm unable to create va…
-
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…
-
Submit ESS job Generate Allocations via SOAP webservice - getting atribute lookup valuesSummary: We need to automate the allocation generation process, as it requires thousands of manual runs per month. We want to use the Automation tool to run the ESS job …
-
How can I find correct load_request_id for transactions those are stuck in the GL_INTERFACE tableSummary: How can I find the correct load_request_id for transactions that are stuck in the GL_INTERFACE table? Please help to a SQL query. Content (please ensure you mas…
-
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…
-
How to create many lines on task Manage Intercompany Balancing Rule (Legal Entity Rules)?Summary: How to create line on task Manage Intercompany Balancing Rule (Legal Entity Rules) with REST API or FBDI spreedsheet ? Content (required): Manage Intercompany B… -
Budgetary Control Infolets not displaying data even after creating budget account groupsHello everyone, We have already completed the Budgetary Control setup and created the required budget account groups, also we have already consumed funds, but the Budget…
-
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 …
-
Unable to select the BU in "Assign Business Unit Business Function".Summary: Unable to select the BU in "Assign Business Unit Business Function". Content (please ensure you mask any confidential information): We have created a setup user…
-
Changing prompt for FUTURE KFF segment in COASummary: The company wants to change the Name/Prompt of a FUTURE segment in COA KFF. Please share your experience and thoughts regarding the considerations and consequen…
-
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…
-
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…
-
How to assign access to GL for a specific Company and only the revenue accounts?Summary: We would like a Team Member to have access to a specific companies GL but only for Revenue. Content (please ensure you mask any confidential information): Versi… -
How to trigger Funds Check before Workflow Approval based on successful Funds CheckSummary: We have a client requirement to trigger Journal Workflow Approval only on successful Funds Check? If Funds Check Fails, then journal should NOT get routed for a…
-
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…
-
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 …
-
How the supplier liability account is deriving on payable invoice for Intra company vendorHow the supplier liability account is deriving on payable invoice for Intra company vendor Need to some changes in supplier liability account combination for intra compa…
-
how do I edit the expression builder for journal batch name ?how do I edit the expression builder for journal batch name in oracle sandbox so that it will autopopulate the journal name feild as sequence number first then the sourc…
-
Subledger accounting Mapping setsSummary: We are able to import bulk data using FBDI(XlaMappingsImportTemplate.xlsm template) into subledger accounting Mapping sets however, we have not found a way to u…
-
What will be the ideal number oIf rows we can have in Journal Import FBDI template and the file sizeSummary: I have a requirement where i need to upload 20+ millions of data on a daily basis via OIC integration through Journal Import FBDI Template. Row Count per File –…
-
Unable To Delete The Unposted SLA Journal in GLHi, We are busy introducing a GL housekeeping / maintenance process to clean up the GL after ledger close each month. As part of the process, we would like to delete any… -
Customize / Restrict GL Journal Approval Email NotificationsSummary: We have a business scenario where Business don't want to enable Notifications (EMAIL) for all Journal Approvals Requests in BPM. But requesting to have Emails g…
-
Proper CoA lenghSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Ledger Intercompany balancing lineTrying to change the description from Ledger Intercompany balancing line to Intercompany balancing line Added the following rules but still getting the same issue?
-
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…