Journal creation through Excel Addin
Hi everyone, I need to create a few journal templates so that they can be filled up in Excel and subsequently loaded into Onestream. I found online screenshots of some journal templates in Excel like the following one: but it's not clear to me how can I create it. Is there a way to export in Excel the already precompiled structure of a journal from Onestream? or do I need to create it manually in Excel? Any suggestion would help!
Make document attachment required on journal
Hi Everyone, Our business team would like to make it mandatory to attach a document to every journal entry. I know this can be done via a confirmation rule. However, one of our business partners googled this and AI returned the information in the screenshot below so they are questioning why we can't enable the setting referenced. We can't find this in any of the OneStream documentation nor see it when creating new workflow forms or journal templates. Is anyone familiar with this setting?
Including Journal Entries from Different Origin Member in Account Reconciliation Discovery
Hi Community, I’m working on an Account Reconciliation solution where I need to ensure posted journal entries balances are also included in the Account Reconciliation discovery process. Currently, by design the Discovery process only pulls trial balance information already imported and validated in the Stage. Therefore, I wanted to check if there’s a recommended, or best practice approach, to accomplish this requirement. Any guidance or examples would be greatly appreciated, thanks in advance for your help!
Automating Email Notifications for Journal Submissions
Our team submits topside entries in OneStream using the Adj channel. Upon a journal reaching "Submitted" status, I want our application to send an email notification to the approver that the journal is ready for review. We already have email notifications up and running for our application. I would like to have the email distributed based on a security group we have, CorpAdjApprover. Any ideas on how I can set this up? Would it go through an Event Handler business rule? Thanks in advance.
Error Saving Journal: Entity Member Filter property for journal is inconsistent with template settng
Hey everyone, My first post, so I hope I'm in the right place. While trying to upload an Excel JE Temp to a WF, the following error appears. I can confirm that the entity member filter is consistent for both the OS Temp and the excel Temp. Also, the same Temp has been used to load data in one of the previous months, with no error. Any suggestions/help would be appreciated. -Amrit G.
Journal Threshold for Approval
Hello, Is there a way to allow a group of users to quick post journals under a certain threshold amount, but if higher than the threshold the journal needs approval? I used a rule previously that will reject the journal if the user attempts to quick post above a certain amount, but then I can't figure out how the next step would be for X group to go in and approve it for them? Thanks!
Oracle EBS 12 Drill Back to Journal and Subledger information
Hello everyone, newbie here, We about to embark on phase 2 of our implementation with the first task of creating drill back capabilities to our Oracle EBS 12.2 (on Prem) application. I want to try to organize as much of this as possible up front since my IT resources are extremely busy at this point. I have been searching for guidance on the best options for setting this up, but have run into so much disparate information. Is there any one of you fellow Oracle EBS users who would mind jumping on a call with me to discuss some of my options? 1. Where can I find Oracle SQL code examples to drill back to trial balance, journal and subledger information 2. Where could I find OneStream code snippets that could be incorporated into my application for this drillback data. Any help would be greatly appreciated.
