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
-
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 …
-
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…
-
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…
-
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…
-
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…
-
All ERP Transaction Console Errors need to email to abcxyz.com and also to the submitter.Hi Community Please help me with below requirement. All ERP Transaction Console Errors need to email to abcxyz.com and also to the submitter. Thanks in advance. Jakee
-
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 …
-
site shown in accrual account should reflect in liability account also.Summary: site segment for liability account should be same as site segment shown for accrual account for intracompany supplier. we checked site is not coming from suppli…
-
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…
-
Allocation formula is not generating allocation journalsSummary: Allocation formula is not generating allocation journals, we are getting below message in the log - Message data is :::::FUN_ALLOC_NO_LINES The allocation gener…
-
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 –…
-
GL: Anyone migrated the allocation rules from one instance to another by using export and importHas anyone successfully migrated General Ledger (GL) Allocation Rules from one Oracle instance to another using the Export and Import functionality? If yes, could you pl…
-
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…