EPBCS
Discussion List
-
Is it possible to export the dimension by generations instead of parent child relation?Summary: Generally when we export data/metadata files, we get it in the Parent-child relationship format( in 2 different columns). We have a requirement of obtaining it … -
Bursting DefinitionSummary: Bursting Definition with Library option enabled. Content (required): Hello Experts, I have created a bursting definition with library option is enabled. I want …
-
balance brought forwardSummary: Client has a requirement to roll forward actuals into scenarios to form the starting points, this is currently a manual process in EBS. In other words, Setting … -
Custom or Module-based EPBCS business processSummary: Hello, As I am fairly new to EBCS, did the high-level design with Oracle in 2016-2017 but only recently have started to implement it for a client, I decided to …
-
Writing back actuals from Planning to GLSummary: Hello, I have successfully built an integration in Data Management/Data Exchange where I want to write back actuals and budgets to Fusion GL (DEV1). Earlier I a…
-
Is it possible to Import data from ERP Procurement to EPM planning application via Data ManagementSummary: Is it possible to Import data from ERP Procurement to EPM planning application via FDME (Data Management) set up in EPM Planning application Content: we want to…
-
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…