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
-
INTER and INTRA Company Balancing Scenarios Examples M:1 and 1:M and M:MSummary: Attaching a document with examples of INTER and INTRA Company Balancing Scenarios as 1:M, M:1 and M:M to outline how balancing lines are generated for those exa… -
🚨 Unknown Member error in Financial Reporting Studio Reports🚨Common issues in Financial Reporting Studio Reports🚨 💭 A) Error executing query:Error:Internal Essbase JAPI error:[Cannot perform cube view operation.Essbase Error(1260… -
💡 How to prevent creator of the journal to approve his own journalSummary: 💡Do you know how to prevent creator of the journal to approve his own journal? Content: This can be achieved by using the "Prohibit Self-Approval" setup. Oracle…
-
💡It is possible to change the Ledger name/Description or Legal Entity name ?Summary: 💡It is possible to change the Ledger name/Description or Legal Entity name? Content: 1.1. Ledger Name: Yes, it is possible to rename the ledgers manually using …
-
What's new in Joint Venture Management for 25DCheck out what’s new in Joint Venture Management for 25D! Here are some examples of what we’ve done: Partner Contributions for Specific Accounts or Projects Transaction …Reni Thomas-Oracle Fusion Financials Product Management-Oracle 2 views 0 comments 0 points Started by Reni Thomas-Oracle Fusion Financials Product Management-Oracle -
💡 Webservice: Sample Test Case for Journal Import Using SOAP UISummary: Webservice: Sample Test Case for Journal Import Using SOAP UI 💻 Content : A. Download the FBDI template: https://docs.oracle.com/en/cloud/saas/financials/25c/oe…
-
Multitier Intercompany OperationsSummary: Required setup and testing of Multitier Intercompany Operations Content (please ensure you mask any confidential information): New multitier functionality requi…
-
Intercompany TAD setup exampleSummary: Attaching a document that provides example on how to setup Transaction Account Definition TAD for Intercompany Content (please ensure you mask any confidential …
-
💡What's New 24D: Exception-Based Approvals for Manual Subledger Entries💡 Description of the Functionality: Exception-Based Approvals for Manual Subledger Entries Use the approvals workflow for manual subledger entries to improve governance …
-
What's new in Joint Venture Management for 25CCheck out what’s new in Joint Venture Management for 25C! Here are some examples of what we’ve done: Financial Reporting by Joint Venture Stakeholder Joint Venture Distr…Reni Thomas-Oracle Fusion Financials Product Management-Oracle 30 views 0 comments 0 points Started by Reni Thomas-Oracle Fusion Financials Product Management-Oracle
-
💡Do you know how to delete old Essbase cubes after the P2T?💡Do you know how to delete old Essbase cubes after the P2T? Content: Please be informed that after P2T, if for example, you have a COA name different on TEST instance co…
-
💡It is possible to unassign a Legal Entity (LE) from a Ledger?Summary:💡It is possible to unassign a Legal Entity (LE) from a Ledger? Content: Once ledger completion status is confirmed, then Legal Entity (LE) cannot be disassociate…
-
💡Do you know how granting user privileges to see output of all the ESS job processes?Summary: 💡Do you know how granting user privileges to see output of all the ESS job processes? Content: In this post we will provide an example for granting to a user pr…
-
💡 Do you know what are the essbase restricted characters and what is the impact of using them?💡 Do you know what are the essbase restricted characters and what is the impact of using them? Content: The following is a comprehensive list of characters and words tha…
-
Common GL Posting Errors and How to Troubleshoot ThemHi everyone, As a beginner when transferring journals from subledgers to General Ledger in Oracle ERP Cloud, I sometimes get posting errors. What are the most frequent c… -
How to enable "AI Chat" option under "Me" in navigator for agent studioOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): NA Description (Required): How to ena…
-
upload sequence settingSummary: how can i manage GL accounting sequence rapidly，import or other possible ways，here is the function Content (please ensure you mask any confidential informatio…
-
Approval Rule for Journals created after <GL Period End Date 10 days>Summary: Hi there, We have a requirement to create an approval rule for journals based on journal batch creation date. All journals created after populated accounting pe…
-
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 …
-
Intercompany transactions between different ledgersWe currently have 4 ledgers configured, and we need to be able to make intercompany transactions between them, can you tell us if this is possible. Best regards.
-
when trying to access Manage Secondary Ledgers task getting errorSummary: When trying to access manage secondary ledger task in Oracle financials cloud getting error like "View row with key oracle.jbo.Key[null ] is not found in Primar…
-
If we want to implement the new COA, do we have to create the legal entity and the ledger?Summary: Our chart of account structure and values have changed, and we need to apply the new COA. Is it necessary to recreate the legal entity and the primary ledger? C…
-
How to update Chart of Account Segment Values and GL Account Hierarchy in bulk easily1. Update Chart of Account Value Set Values Sometimes there is a requirement to update COA value set values in bulk e.g. Value Description, Enable flag, Segment Value At… -
how to ensure that user only able to see requests run by them only in Scheduled processSummary: Content (please ensure you mask any confidential information): Hi, We have a requirement wherein users wants to restrict the requests in Scheduled process for a…
-
How to Delete Multiple Account Hierarchy Tree VersionsSummary: We would like to know if there is a way to delete multiple hierarchy tree versions at a time in Oracle Financials Cloud. I mistakenly created 1,254 tree version…
-
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" ?
-
What is the alternative to apps_initialize in oracle fusionHi, We have a custom requirement to create a journal using the REST service but the created_by should be a different specific user other than the service_user which is u…
-
If one reciever rejects in a multi-receipieint transactions, does the whole transaction get rejectedSummary: In intercompany module, if one reciever rejects in a multi-receipieint transactions, does the whole transaction get rejected or just partial Content (please ens…
-
Control budgets not populating in LOV in Enter Budget in SpreadsheetSummary: Hi Team We have created a Control Budget: OH Control Budget_1 and completed all the required setups. The required roles and data access also given to the user b…
-
change the default exchange rate type from "SPOT" exchange rate type to "Corporate".Summary: kindly note that currently we are depends on "SPOT" exchange rate type as the default exchange type, but we need to change it to be "Corporate". and I need to k…
-
do we can restrict the user with out giving to access to the particular journal sourceSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to create Recurring entries in GL for fixed amounts every month?Summary: How to create Recurring entries in GL for fixed amounts every month? We have a requirement to create recurring journal entries every month and once we pass an e…
-
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…
-
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… -
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?…
-
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…
-
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…
-
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…
-
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… -
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),…
-
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 …