Category 101
Discussion List
-
How to make dimension members from top to bottom hierarchy in web-form?I have created a web-form with Account dimension in rows and there is no function selector to make members to display from top to bottom. it always show from bottom to t… -
Working with predictive planning - Error pasting valuesI'm receiving this error when I try to paste data into a webform: However the webform looks ok: I'm not using period dimension, all data is against begbalance. Thanks yo… -
Drill through to BIP report not workingHi All From EPBCS application, we are trying to drill through to source system i.e. BIP report. The BIP Report has 2 Run time parameters P_YEAR (Values = 2024) P_MONTH (…
-
how to upgrade EPMAutomateSummary: 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 extract user report by EPM instance via Console IAM ?Hello All, We need to export the list of all users per instance. Before migration to OCI, we could use the APIs and export the list of users per instance, so we could co… -
Manage / Automate Valid Intersections with Groovy (Solution)Hi - The below post from @JeremieR-Oracle gave the inspiration to get over the hump on how to update Valid Intersections completely in the cloud inside of EPM. Hopefully…
-
Map Member Data IntegrationHi, We have currently 25,000 mapping and might go upto 50,000 mapping in future Can the system cater this? f
-
Questions about member expressionI would like to know the appropriate member expression for the Account “ACH0035” as it differs from the expected value. I can use @PRIOR(“ACH0035”) to get the value of i…
-
With Groovy, how can i get the specified attribute value of Entity from PVO (on a form)With below form, I want to pick the Entity value of 1188 and test if its "Type" attribute is equal to "Corporate". I am able to get the whope PVO but not the 1188 itself…
-
PBCS jobs getting stuck at drill through step in DMSummary: PBCS jobs is getting stuck at drill through(Create drill region HPL_DRILL_REGIONS) step in DM and kept on running until we cancelled the job and changed the dri…
-
Dynamic member in a FlexForm errorSummary: I have a FlexForm that have a mix of stored and dynamic member. The expectation is that when submitted, it'll submit data from the stored members, but will igno…
-
Smart Push from BSO to ASO is Excluding AccountSummary: We have a form definition with multiple lines. The first line has the exclusion of an account 49149990. The forth row of the form is listing this account explic… -
Make cells readonly for specified data rangeHello all, For a program we enter start date (01-02-2025)-dd-mm-yyy and End date (31-12-2025), From this range feb 2025 to dec 2025 the cells has to be editable remainin…
-
Denying a Transfer OutSummary: Hello, I have a use case of a department manager submitting a "Transfer Out" of an employee, and an administrator needing to deny the transfer request. Using OO…
-
Script DesignHi, We have a requirement when a smartlist value is selected for a particular intersection, we need to identify all other intersections that use the same smartlist value…
-
Create or Update All Substitution Variables Defined for the ApplicationHello, I am trying to leverage "Update Substitution Variables " REST API and below is the code: Through Postman it is working fine. I am trying to execute it as I did fo…
-
Groovy - The form GroovyDataGrid is Invalid when DataGridDefinitionBuilder is usedHi all, In an ASO cube, we are using CsvWriter and DataGridDefinitionBuilder to iterate through each account to generate a CSV file in Inbox/Outbox Explorer. while using…
-
Can I check the details of users having access to all EPM applications/environmentsTo check the details of users having access to EPM applications/environments
-
Creating via Groovy Rule the Excel file needed for the update of Cell-Level SecuritiesSummary: We would need to create and populate the two-tab-based Excel file needed for the Cell-Level Securities update. Is there a way to do so? Content (please ensure y…
-
data management category disappeared for all DRLsSummary: Content (please ensure you mask any confidential information): Hi all We have an issue where the category has disappeared in data exchange for our DRLs. However… -
Suppress #noaccess on EPBCS Data FormsWe currently have multiple data forms that display all departments associated with a Business Unit. When a user with access to only certain departments accesses the form…
-
Maximum number of members in Period DimensionSummary: What is the allowed limit on Period dimension? (Dense). Custom cubes Content (please ensure you mask any confidential information): What is the allowed limit on…
-
How can we dynamically build xlsx file to import Cell level security into planning using groovySummary: How can we dynamically import Cell level security into planning using groovy. we did not find any method which can create an xlsx file. we have csv file writer …
-
How To find Oracle EPM hostname and port number?Summary: How To find Oracle EPM hostname and port number? Content (please ensure you mask any confidential information): We want to find Oracle EPM's Hostname and port n…
-
EPBCS Dashboard 2.0 - The Property Menu of a Grid Object is Greyed Out, Unable to Edit Data FormattiSummary: We have a "Dashboard 2.0" Dashboard, and we have added one Grid Object from a "Forms 2.0" form. We are trying to adjust the data formatting of that grid object,…
-
HTTP500 internal server error when running concurrentusage rest apiSummary: I'm running the below rest api for concurrentusage I get success response as below but in the email, it says tests are failed with HTTP500 internal server error…
-
Audit Tool doesn't return the historic.Summary: I'm referring to the Audit feature in EPM Cloud applications, I need to consult the modifications of User Administrator and Group Administrator. Content: Basica…
-
How to generate GL Journals from Oracle EPBCS to Oracle Fusion GL ?Summary: How to generate GL Journals from Oracle EPBCS to Oracle Fusion Cloud GL ? Does Native connector exist to do that ? Content (please ensure you mask any confident… -
PBCS User variable selection throws an error ajax to servlet failedSummary: During selection of member name in user variable limits, it is giving this error "ajax to servlet failed" with a small pop-up window for one particular project.…
-
Configuring compensation for different statusesSummary: Configuring OOTB Workforce Planning, and I see that when I choose a Status of "Leave of Absence" for an existing employee that the total compensation for the ch…