• Philippe Latouche
    Extraction of roles
    Topic posted 12:25 PM by Philippe LatoucheSilver Medal: 2,000+ Points, tagged Financials, HCM, Security in Applications Security public
    Extraction of roles
    how to do an extraction of roles

    Hi guys,

    I would like to know if is it possible to an extraction of all the roles in ERP Cloud right now with the description. I don't want to do a copy-paste for each of them.

    Is it possible ?

    Thank you,


  • Jennifer Wolfe
    Double 'Submit' is required after 19D release
    Topic posted 9:32 AM by Jennifer WolfeBlue Ribbon: 750+ Points, tagged Configuration, Expenses, Financials, Security, Setup / Administration, Tip, Update in Core Financials > Expenses public
    Double 'Submit' is required after 19D release
    After 19D was released we now have to hit the 'Submit' button twice

    After 19D:

    Create expense report, click the 'I have read the policies' link, hit submit.  Nothing happens at this point, we have to reselect the policy link and hit 'Submit' again.  

    Have any others had this issue?



  • Shlomo Elnekave
    User Inactive Date4
    Topic posted 6:48 AM by Shlomo ElnekaveBlue Ribbon: 750+ Points, tagged Security in Applications Security public
    User Inactive Date
    User Inactive Date


    How can i get the inactive date ? ( see attached )

  • Mark Rinaldi
    What's New in 19.12?35.0
    Topic posted December 6, 2019 by Mark RinaldiSilver Crown: 22,500+ Points, tagged EPM Automate, Groovy, Help Center, Integration, Reports, Security, SmartView, Tip, Upgrade, User Assistance in Enterprise Performance Mgmt > Planning public
    What's New in 19.12?
    ...last one of the year!

    Here we are again and for the last time this year (BTW, pet peeve, this isn't the last time in the decade... decade ends 31-Dec-2020)!

    As usual, I assume you have already memorized the latest What's New document from our wonderful User Assistance team but I'll plagiarize and add some (hopefully) helpful commentary.  Staying with my recent theme, I'll list the EPM Common features and then focus on the Planning-only items and leave the non-Planning features to my friends in the other forums.

    New Features - EPM Common

    1. The Video team keeps pumping out the hits with some excellent overview videos that are very helpful to learn more about our new product offerings from June of this year, EPM Standar Cloud or EPM Enterprise Cloud, and the must watch video for all your User Assistance Assets for EPM Cloud to ensure you know where to access all the available resources to better understand your EPM Cloud solutions.
    1. EPM Cloud now allows Service Administrators to assign a user to many groups. This new feature simplifies group-based assignment of application roles and access control.
    1. Ooh, here's a nice one that you've probably wondered about... A new Select All checkbox in the Select Members dialog box in Financial Reporting Web Studio lets you select all members currently assigned to a report or a book instead of selecting one member at a time. This saves time if you have a report or a book with several members and wish to remove all the members to update the report or book instead of removing one member at a time.
    1. We have renamed Financial Reports to simply "Reports" in User Preferences on the title page and in the object library in the Navigation Flow designer.  Three guesses why in the comments?  First one with the correct answer wins absolutely nothing except Customer Connect fame and glory!  laugh
    1. The Data Management (DM) team keeps enhancing the fabulous On-Premises Agent, which can now be installed as a Windows service, enabling you to run the agent in its own Windows session. This service can be started automatically when the computer boots, can be paused and restarted, and does not show any user interface. On Linux computers, the EPM Integration Agent will be started as a background process.
    1. I hope you are sitting down because I'm sure you'll be stunned to know that there is a new version of Oracle Smart View for Office,, available this month with new features and fixes.

    New Features - Planning

    1. The Video team has also created a Planning-related video for Source System Integration with the EPM Integration Agent.  We're happy to announce the EPM Integration Agent, a flexible, extensible source data integration solution! With custom and seeded SQL queries and scripting you can extract and transform data from on-premises (I had to add the ending "S" and will scold the author internally, for those that have been following my previous posts, you'll know why cheeky) and third party cloud source systems for use in Planning.  Getting data into EPM Cloud is even more robust and easier than ever.
    1. Have your or users ever wondered why a data cell is read-only?  Wonder no more... There are many reasons why a data cell is read-only. For example, you might not have write access to the cell, or maybe the cell’s value is calculated dynamically. Now you can determine the reason why a cell is read-only.

      The Action menu in a form now provides an option, Show Reasons for Read-Only Cells. Selecting this option loads the reasons why cells are read-only. Then you can right-click on a cell and select View Reasons for Read-Only Cell to see the reasons why the cell is read-only.  Voila!  Pretty cool, I think.

    2. In simplified multiple currency applications, you can now assign security to the Currency dimension to make Currency dimension members read-only based on user access. To enable security for the Currency dimension, click the Edit Dimension Properties tab, and then select Apply Security.  Yay!
    1. There is now an Import Exchange Rates job type for simplified multi-currency. To create this job type, you must point to an import CSV file that is located (available) in the inbox.

    Upcoming Changes - EPM Common

    1. In a future update, there will be a revised interface with enhanced navigation and a new theme called Sky Blue.  The revised interface retains existing functionality and enhances your experience with a more modern look and feel and responsive design. The Welcome Panel and the Global Header readjust after resizing, which means less scrolling. An updated Welcome Panel features Announcements and Notifications. Arrows are available on the Home Page to help you navigate easily between the Springboard and infolet dashboard pages. A bigger Navigator Menu has improved usability, more themes for customization are included, and a bigger work area has more space to maneuver and provide better visibility. The interface is also more consistent with other Oracle products, such as Fusion Applications.

      After the interface is released, all new customers will use the new lighter-colored Sky Blue theme, and existing customers will keep their current theme. You can switch themes using Tools, and then Appearance.

    2. In an upcoming release, Oracle will rename the Planner EPM Cloud predefined role as User. This change will have no functional effect.

      Subscriptions that were provisioned prior to the May 2016 update used the Planner role, which has been maintained in subsequent updates to provide continuity. In subscriptions that were activated after May 2016, the Planner role was already replaced by the User role.

    3. Removal of Instance name from predefined Role names.  Currently, the predefined role names displayed in the Access Control screens of EPM Cloud environments prefix the instance name to the role name in INSTANCE_NAME ROLE_NAME format. They are also stored in this format in the snapshots, making it difficult to migrate snapshots from one instance to another.

      To facilitate the migration of security across EPM Cloud environments, Oracle plans to rename predefined role names displayed within EPM Cloud applications by removing the instance name prefix. For example, if the instance name is Planning1, predefined role names are Planning1 Service Administrator, Planning1 Power User, Planning1 User, and Planning1 Viewer, the new role names will be Service Administrator, Power User, User, and Viewer.  This is a great thing!

      NOTE: This change does not affect how the role names are displayed in the MyServices customer portal.

      This change won't impact customers who currently use predefined roles for managing application-level provisioning and access to artifacts. Oracle will ensure that all application role assignments and artifact security assignments are automatically updated after the roles are renamed. This change makes it easy to migrate EPM Cloud artifacts across environments.

      This change is being implemented to address customer feedback. If you have any concerns about this change, please contact Oracle Support.  {Cough, cough... do you remember why I said we add this paragraph?}

    4. Predefined Role Names as EPM Cloud Key words.  Starting with an update in the near future, Oracle plans to treat the following predefined role names as EPM Cloud key words, which should not be used in the name of any custom artifacts that you create; for example, as a group name in Access Control.

    • Service Administrator
    • Power User
    • User
    • Viewer
    • Planner
    • System Administrator
    • Application Administrator
    • Library Administrator
    • Reports Administrator

    If you have any groups or artifacts named using these keywords, Oracle requests that you rename or delete them; else Oracle will rename them to ensure that there is no impact because of this change. For example, a group named Power User will be renamed as Power User1 without affecting the current role assignments. If you do not want Oracle to automatically rename such groups, you must rename them.

    This change is being implemented to address customer feedback. If you have any concerns about this change, please contact Oracle Support. {Cough, cough}

    1. In a future update, Oracle will add a query governor on Essbase block storage and aggregate storage cubes to guard against excessive server load created unintentionally by running ad hoc queries that take a very long time to complete. The new governor will limit all queries to a maximum of 30 minutes execution time. This governor affects only retrieval of data, for example, Smart View ad hoc queries, web and Smart View forms, and reports. It does not affect business rules.

    Upcoming Changes - Planning

    1. Update to the exception response in REST APIs for Planning and Planning Modules.  Oracle will remove the internal package and class names from the following fields in the exception response in REST APIs for Planning and Planning modules in an upcoming release in early 2020:
    • message
    • localizedMessage

    Considerations - EPM Common

    1. Clarifications on EPM Automate Command and REST API behavior for ADDUSERS.  The EPM Automat and REST API documentation has been enhanced for the addUsers command/API, respectively.  The updated documents detail the command/API usage and behavior in SSO and non-SSO configurations.

    Hmmm, my favorite may be the video for the Planning source system integration with the EPM Integration Agent.  It is a very powerful feature.  Seeing why a cell is Read-only can be useful as well as being able to secure the Currency dimension.  Let me know your favorite feature.

    Hopefully you get some time off later this month to recharge for the new calendar year.

    As always, Happy Planning!

  • J-La
    NEW Oracle Admin Account65.0
    Topic posted December 5, 2019 by J-LaGold Medal: 3,500+ Points, tagged HCM, Security in Applications Security public
    NEW Oracle Admin Account
    Genuine email from Oracle or phishing?

    I received an email from Oracle with subject Action Required: Please Use the NEW Oracle Admin Account.  

    The email states that a NEW admin account has been CREATED and I am being asked to go to a URL that looks really strange, and to login with my current admin account credentials. The explanation of why I would temporarily have two admin accounts is a bit thin, and also the reason why I would now need to login to the new admin account is not clear.

    Can someone from Oracle confirm this is genuine? 

  • Neil Saunders
    Oracle Identity Cloud Service vs MyServices45.0
    Topic posted December 4, 2019 by Neil SaundersRed Ribbon: 250+ Points, tagged Other, Security in Applications Security public
    Oracle Identity Cloud Service vs MyServices
    Since the old MyServices portal has been discontinued, I'm unable to find what I need in the new IDSC portal


    We recently we're switched to the new admin accounts and the old 'MyServices' portal has been discontinued.

    1. Although our Admin users we're brought over to the new portal, our 'contacts' (receive email notifications about planned outages, P2Ts, etc) were not. How/Where do I add these 'contacts' back? And how/where do I set up notifications?

    2. There were some useful reports available (RUEI) in the old portal, that I cannot find in the new one.

    See screen shots in the attachment.

  • Shlomo Elnekave
    How to audit user login activity ?7
    Topic posted December 4, 2019 by Shlomo ElnekaveBlue Ribbon: 750+ Points, tagged Security in Applications Security public
    How to audit user login activity ?
    How to audit user login activity ?


    Is there any option to audit the user login activity in the cloud ? ( for example "last logon date" field that was available in the EBS )


  • Kunal Daya
    Reporting on a User Role assignment revoked date2
    Topic posted December 4, 2019 by Kunal DayaGreen Ribbon: 100+ Points, tagged Financials, HCM, Other, SCM, Security in Applications Security public
    Reporting on a User Role assignment revoked date
    Report that displays when a role was assigned to a user and when it was revoked from the user

    Hi Community,

    Please could you assist, we are trying to build a report to identify when a role was added/granted to a user and when the role was removed from a user.

    If you could advise if there are any existing reports or what tables can be used to identify this information?

    Thanks in advance

  • Joseph Ip
    Can EPM Cloud -My Service connect to multiple IDCS?1
    Topic posted December 4, 2019 by Joseph IpRed Ribbon: 250+ Points, tagged Infrastructure Security, Security, Setup in Enterprise Performance Mgmt > Security and Infrastructure public
    Can EPM Cloud -My Service connect to multiple IDCS?
    Can EPM Cloud -My Service connect to multiple IDCS?

    Hi Folks,

    According to my understanding, once I login to My Services, I can see the TEST instance and PROD instance.  However, we would like to configure TEST instance with TEST IDCS instance and PROD instance with PROD IDCS instance.  Is it possible?



  • Andy Tauro
    Assigning Predefined Role via REST API is not reflected in...2
    Topic posted December 2, 2019 by Andy TauroSilver Medal: 2,000+ Points, tagged EPBCS, EPM Automate, Integration, PBCS, Planning, Security, Setup in Enterprise Performance Mgmt > Planning public
    Assigning Predefined Role via REST API is not reflected in My Services
    If we assign a user a role to an app via REST API, the job 'succeeds' and user shows up in app, but the role assignment is not reflected in My Services

    We are working on scripting the process of creating new users and provisioning them to one or more applications. We are able to use the EPM Cloud Rest API to create the user, but when we try to assign a predefined role to the user, such as 'User' or 'Viewer', the job results say "Succeeded", matching the row counts from the uploaded file. But the role assignment is not reflected in My Services. I don't think there is a way to see the job status details for "Manage Users" jobs, is there? Like "Import Data" jobs will show the first 5 kickouts in the job status details. But I cannot find a similar URL for this.

    When we checked the "Assign Application Role" screen and the user does show up. When we check the canned groups that are created to correspond to the predefined roles, sure enough, the user is in there. But My Services does not seem to get updated. Is this normal? I have a feeling that when we first tested this when it was released last year, the update was reflected in My Services too. But I have no way of verifying. 

    We have tried waiting overnight, after the user creation, to assign the role, and it doesn't make a difference. The application that this testing is being conducted in is an EPBCS (legacy SKU) application. Unfortunately, we didn't do this testing before the Nov'19 patch, so have no way of knowing if this last patch had any impact on this.