• Cristian Betancur
    ERROR:Create unique precedence levels for tax jurisdictions...1
    Topic posted November 14, 2019 by Cristian BetancurBronze Medal: 1,250+ Points, tagged Configuration, Financials, Payables, Security, Setup / Administration in Core Financials > Tax and Global public
    ERROR:Create unique precedence levels for tax jurisdictions that apply to the same tax. (ZX-885139)
    ERROR:Create unique precedence levels for tax jurisdictions that apply to the same tax. (ZX-885139)


    I want to create a Withholding Tax with Tax Jurisdiction with City, using Global Configuration Owner. However, when I want to save the tax, it shows an error:

    "This precedence level already exists. Create unique precedence levels for tax jurisdictions that apply to the same tax. (ZX-885139)".

    However, when I create Withholding Tax under BU or LE like configuration owner, I can save taxes with this kind of jurisdictions.



    Oracle ERP Cloud Release 13 19D -
  • Jennifer Wolfe
    Finance Auditor and Spend Authorization Access1
    Topic posted October 28, 2019 by Jennifer WolfeBlue Ribbon: 750+ Points, tagged Expenses, Reports, Security in Core Financials > Expenses public
    Finance Auditor and Spend Authorization Access
    Is it possible for the Finance Auditor to have access to Employees' Spend Authorization

    Is there a way for the Finance Expense Auditors to not only have access to the Expense Reports but also the Spend Authorizations?


  • Tarun Agarwal
    Track Changes in BPM worklist - Application PreferencesAnswered15.0
    Topic posted September 18, 2019 by Tarun AgarwalSilver Medal: 2,000+ Points, tagged Financials, Security in Applications Security public
    Track Changes in BPM worklist - Application Preferences
    We need to identify when was the Notification Mode changed

    Hi All,

    We want to know when and with the help of which user account was the Notification Mode Changed in the BPM Worklist in the Application Preferences. Is there any way to identify the same?

    Thanks in Advance!



  • Remi Degrelle
    Is there a way to restrict the list of account values by...7
    Topic last edited November 28, 2019 by Remi DegrelleRed Ribbon: 250+ Points, tagged General Ledger, Security, Setup / Administration in Core Financials > General Ledger & Intercompany public
    Is there a way to restrict the list of account values by modules ?
    Need to have different list of values for accounts depending on the module

    Hi everyone,

    I would like to see if there a way to restrict the list of account values depending on the module selected for a particular transaction?

    By using the standard functionnalities,

    1) We can restrict access to subledger accounts using Third-party control accounts (to avoid GL manual entries on pure subledger accounts)

    2) We can restrict access in a given subledger module to a pre-defined list of accounts using segment value security rules. But when we applied this security rule on a custom role (that we call for example SUBLEDGER_AP_SECURITY_RULE), and apply it to the user, then the user is not able to see those values whatever the module he's selecting

    (I see that there is a LOV for module in the SR General Information page but it seems to be inefficient. See below screenshot)

    On this second point, part of this problem can be solved by implementing a proper SOD. But we still have some cases of users having access to multiple subledgers or subledgers and GL for which we need to secure the list of available accounts depending on the module. In addition to that, we are using pure GL accounts (GL mirror accounts or GL intercompany reclassification accounts) for fast correction during month-end that we reverse on the next period (and make correction in the appropriate module). These particular accounts must be used in GL only and in no other subledger module.





  • Stephen Manning
    Cloud ERP with PBCS in same Identity Domain - how to SSO?7
    Topic last edited January 30, 2019 by Stephen ManningRed Ribbon: 250+ Points, tagged Configuration, Security, Setup / Administration in Integrations and Extensions public
    Cloud ERP with PBCS in same Identity Domain - how to SSO?
    We have our production and test PBCS environments deployed in the same identity domain as our Cloud ERP production environment and it is presenting some SAML SSO challenges for the PBCS environments


    When we subscribed to our Cloud ERP and PBCS services - the production identity domain for Cloud ERP also had both of our PBCS environments provisioned into it.

    at the identity domain level in my services - the authentication configuration points to the Cloud ERP OID/OIM URL's and as you are probably aware we then open an SR to have our SAML SSO integrated for the Cloud ERP side.

    For Cloud EPM (PBCS) we were advised to modify this authentication configuration at the identity domain level but I think that will cause the Cloud ERP configuration to break.

    This was discussed / discribed here

    Can anyone tell us what we should be doing to approach this? Should we ask to have our PBCS environments moved to their own identity domain? Not sure what to do here.

  • Mark Rinaldi
    What's New in 19.12?15.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!

  • 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?



  • 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 MyServices35.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 )