Category 101
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 … -
Role required to launch Data MapSummary: We are using Strategic Modeling module of Planning. We have forms that push data from Planning Cube to the SM Model. This is done by launching Data maps using B…
-
Help with ASO MDX member formula CASE IIFHello, My ASO member formula works correctly below: ------------------------------------- /* Working but not complete*/ CASE WHEN IsAccType ([Account].CurrentMember, Las… -
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 …
-
User variables and Financial ReportsHi All, does anyone have any experiences\suggestions in relation to the controlling of the User POV when transitioning between forms and Financial Reports using Navigati… -
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…
-
Data Integration Clear Region and SecuritySummary: Clear Region in Data Integration seems not to reflect Dimension Member Security, Scenario Security (Start/End Period/Year) or other Security like Valid Intersec…
-
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…
-
groovy script for Copy DataSummary: Summary: Dear Expert, Need your help about groovy script. Right now, we are copying data from 1 intersection to another intersection using DATA COPY Feature in …
-
Bypass valid intersections in a formDoes anyone know how to bypass valid intersections in a form? We loaded data in invalid intersections and need to update that data. Thanks!
-
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…
-
Not able to provision users to FCCS & PBCS ApplicationsSummary: Not able to provision users to FCCS & PBCS Applications Content (please ensure you mask any confidential information): we have created new users but not able to…
-
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 …
-
Duplicate Member Names - FREE FORM PLANNINGhi All, In Free form planning application, I want to use duplicate member name (Across business dimensions). I know we can have duplicate member alias, but want to know …
-
Alias members are not accepting in the member formulasHi, we are using PBCS Application Version 23.10.68, For the account members when i tried to include alias member in the member formula it is giving me validation error b…
-
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…Lakshani Hettiarachchi 21 views 3 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Is there a limitation on the file size or number of records while exporting via QUICK MODE?While using DATA EXCHANGE - QUICK MODE integration-> to export data to a FILE, (from EPCMS - ASO cube) to flat file, Is there a limitation on the file size or number of …
-
Is there a way in Groovy to getEvaluatedMembers / get ancestors with Administrator permissions?Summary: Would like to know if there is a simple way of using getEvaluatedMembers (or similar) with admin permissions, to pull back names of members in the hierarchy des… -
SV: Getting an error when selecting user Variable for forms in SmartviewSummary: Content (please ensure you mask any confidential information): Getting the below error when selecting a member which is part of the user-defined variables. This… -
copy data from many POV to one POV.Hi, I need to right a business rule function to change the 9 accounts with currencies to no Currencies, its similar to datacopy @RELATIVE("Input Currencies",0) To "No Cu…
-
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… -
Balance sheet data for end-of-year adjustment periods is not loading correctly from GL in ERP?Summary: • My agency accounting practices require the use of two adjustment periods following the 12th accounting period. The data load rule for income statement (i.e. "… -
Validation clearing data in data managementHi All, We've hit an issue where a user has hit the "validation" in Data Management following a successful import and the data seems to have disappeared (the show option…
-
Expand Button in FR is not visibleSummary: Hi, After the OCI migration (which happened last Friday, 20 Oct 2023) the expand button in FR is not visible if opened from SmartView: But it's visible if opene…