EPBCS
Discussion List
-
CLEARBLOCK NONINPUT vs CLEARBLOCK UPPERHave a requirment to clear upper level blocks for one account. As per oracle document CLEARBLOCK UPPER - Remove consolidated level blocks. CLEARBLOCK NONINPUT - Remove b… -
Forms - Suppress Missing Blocks doesn't work on ILvl0Descendants of a shared memberSummary: We have a form that includes 3 dynamic formula accounts on it. If the entity dimension is set to pull ILvl0Descendants of the primary hierarchy any members with…
-
If we are adding a user to OCIGen2 ,how to make a user as Federated by defaultWe are using APIs to add the users in OCI gen2 applications. When the user is added to OCI gen2 , the user is getting created as Federated option as "NO". Every time we …
-
less powerful role to create rulesSummary: Content (please ensure you mask any confidential information): Hi Apart from giving service admin directly, is there any less powerful role which we can given t…
-
Not able to validate if condition with member of SmartList data type when comparing with integerSummary: I have written very simple formula in free form application, where my cube Hybrid BSO. I have created a dynamic calc member MemberB with member formula mentione…
-
How to use the Plan Element in EPBCS?Summary: We have a requirement to handle adjustments in Planning for which we need 13 periods. P1-P12 for the accounting periods and P13 for adjustments. We would typica… -
Are there any connectors available for PowerBI/Azure we can pull the data from our cubes?Summary: Are there any connectors available for PowerBI/Azure we can pull the data from our cubes? We would like to be able to pull the finanical data we have in our cub… -
Issue with dynamic calc parentHello experts, I have issue doing a dynamic calc in PBCS: The calc is very easy: "Final Balance Typ2" / "Final Balance Typ1"; At level 0 from Entity I can see correct da… -
How to use loaded GL balances from ERP Cloud in EPBCS through SV or data forms?Summary: Hello, I have successfully built a direct integration in Data Exchange between ERP Cloud and EPBCS and loaded several GL balances into the workbench. But how do…
-
Client has a requirement to view text data at parent entity level in ASO cube.Summary: Client has a requirement to load text data at parent entity level in ASO cube for which we have informed that its not possible but they insist to view report at… -
DTP Prompts are not coming up when saving a formHi guys, I am very new to DTPs and trying to study its behavior trying different scenarios. One of the scenario that I am testing is that "User will select company from …
-
Is there anyway to find the username and the last updated date of a form or a value in the form?Is there anyway to find the username and the last updated date of a form or a value in the form via SmartView?
-
Dashboard 2.0 combination chart doesn't do column chart (stacked bar; only normal bar)Summary: Dashboard 2.0 combination chart is pretty useful.. but currently it has has no column chart (stacked bar) combined with other charts. You only have the normal b…
-
Compensation calculation not working in Mass UpdateUnder Mass Update tab of Compensation planning, for Synchronize Defaults form, while adding a new employee, compensation is not getting calculated on save. Incremental s…
-
Passing file name while using rest API to run data load ruleSummary: I am running the data load rule using rest API functionality but while giving the file path it is giving an error mentioning "File or directory does not exist" … -
Prior balance (Spanning in years and months)Summary: Content (required): Hi I need to do the following scenario, where i need to get the prior month balance + current month balance. but when it spans over the next…
-
Simplified editor: adding shared member special character & is failingSummary: Simplified editor: adding shared member special character & is failing. The error is 'base member specified for shared member could not be located' You can add …
-
Does Critical Patch Update also applicable to Oracle Planning?Summary: Oracle Critical Patch Update is released for Oct 2023 and it includes security patch for Essbase. Is the security patch also applicable to Oracle SAAS products …
-
Auto update of members across ERP and EPBCSSummary: Content (required): Hi Experts, We have defined data integrations to transfer budget data from EPBCS to ERP and actual data from ERP to EPBCS. In ERP COA natura…
-
Additional fields in data extract from EPMI am trying to export data from EPBCS application using DLR. Would like to know how can I add additional columns in my export file which is not available as a Dimension/…
-
Prefix data in Data IntegrationKindly advice on how below can be achieved using Data Integration Source is sending us "GL Department" as "4200620". We would like to load this as "_4200620".
-
clear region in data management issueSummary: Content (required): Hi we defined the clear region in options and tried to export using export mode "REPLACE" method. Clear rule did not execute, i checked the …
-
How to delete only descendant members of a parent in EPBCS using groovy scriptWe have a requirement to delete Purchase requisitions every time we load the transactional data. To achieve this we want to use a groovy Business rule to delete the desc… -
If condition for variables.Summary: Content (required): Hi i have an account with date format where we enter the loan start date. for ex : 1st may 2020. Then i pass the loan fixed rate which user …
-
Copying data for period rangeSummary: Content (required): Hi I need to copy data for a period range as below. Ex: i have a loan start date : 01-may-2020. and loan end date as 31-apr-2026 (72 no of p…
-
date in calc managerSummary: Content (required): Hi I want to copy a certain to a specific month and year, based on the date entered by user in "loan start date" (MM/DD/YYYY Format) For ex:…
-
How to use RTP in MR ?Summary: Hello , Recently we have a requirement to build a MR keeping the Year Dimension as RTP . However we want use same RTP (Enter Year) for both Current Year : Singl…
-
HSP_NOLINK - Checking if the Dynamic XREF has been sucesfully removed or notSummary: By adding HSP_NOLINK UDA, we delink the automatic Dynamic XREF from source to target cube. In EPM application, can we see somewhere like Smartview or extract if…
-
Data Management Member Mapping - One Source value to Multiple targets within same dimensionSummary: Content (required): Hi Experts, We have a business process to transfer budget amounts from EPBCS to ERP Fusion. There is a requirement to transfer the same budg…