Category 101
Discussion List
-
Bind variable does not pass through to the SQL querySummary: When I give the variable a value from integration, no rows are extracted from the SQL source. but the log says the bind variable was added. --------------- Exec… -
EPM to ERP Fusion Drill through errored out due to period mapping issue.Summary: EPMFDM-140133:Could not find a Period key mapping for the given parameters Content (required): The data load from Fusion to EPM planning (Custom EPBCS) is succe…
-
Get Planning Unit History and Annotations - Invalid Method or Method Not allowedSummary: I'm trying to get the planning unit history and annotations for a specific entity using rest Api provided in admin guide. Admin Guide URL https://docs.oracle.co…
-
Unable to create blocks for Allocation LogicSummary: Unable to create blocks for Allocation Logic Only Period and Account are Dense and rest of all are Sparse. FIX(&CurYr, &CurMnth,"Actual","Final", @RELATIVE("All…
-
Export One Row like Period Member using EPM Integration AgentSummary: Hi Team, we are working on EPM PBCS integration with OnPrem ERP Staging Tables using EPM Integration Agent. Our requirement is: ================================…
-
Can we remove users from the (prior) Classic environment now that they've been migrated to new OCI?Summary: Our users have been getting confusing emails asking them to change their password for the old (classic) environment PBCS. Even if they do change their password,…
-
IPM Auto Predict Error in PBCSSummary: IPM Auto Predict Error in PBCS Content (required): I am trying to Auto Predict based on actuals in ASO to target in BSO however I am getting below error. There …
-
How do I write a member formula BS & IS prior year data for trending?Summary: Trying to create a member formula to use for balance sheet trending in PBCS. Content (required): I am trying to write a member formula that will do the followin… -
zero value not included in the imported dataSummary: zero value not included in the imported data Content (required): We migrated data between two applications with Data Exchange / integration jobs. From the expor…
-
Ruleset and Rule Variable Prompt OrderSummary: The order of my variable prompts within a Rule and a Ruleset are not updating regardless of how I have the order setup within Calc Manager. Content (required): …
-
Member limitation for Employee Dimension.Summary: We are planning to add 4600+ Employees to Employee dimension(Planning Employee+Job wise) in EPM Workforce Will there be any issues we might face on performance …
-
Sensitivity Analysis at a higher levelSummary: Content (required): Hi, Client has a requirement to perform sensitivity analysis, but at a more higher level. Meaning, more at the profit and loss statement fac…
-
Submitting Date in MM-DD-YYYY formatI am trying to submit date in MM-DD-YYYY format using Smart view ad hoc grid but it changes back to DD-MM-YYYY format. I tried to change date settings under user prefere…
-
Text Values Migration Synchronization Issue EPM/PBCSSummary: Have to keep data between an older PBCS cube and EPM cube in sync. Text values are misaligned. Content (required): Need to bring the text values from the new EP… -
How do we Integrate EPBCS workforce with HCM for custom dimensions like PC and CC.Summary: We need to integrate Custom dimensions like Programme Code and Cost Centre and get the data from HCM for these dimensions into EPM Workforce. These are custom d…
-
Refresh Error for Shared MemberSummary: Trying to create a new alternate rollup but keep getting the "In an aggregate storage outline, only one shared member [Angi Ads & Leads] (including prototype) i…
-
Smart list vales is not getting saved on a formSmart list having Yes/No in a drop down, when I select values and save the form, it comes back to #MISSING. Please advice!
-
Import Rates from ERP to EPBCSSummary: Form subvars off imported ERP rates and reference them in business rules. Content (required): Currently we are manually hard-coding our period average and perio…
-
Validation Rules for percentage in the formSummary: We have a requirement from customer that when the percentage is not equals to 100% in a specific row, it should appear in RED color , I have written a validatio…
-
API to export and injest data from EPBCS to AWS S3 and TableauSummary: Have someone worked on a “live” data connection from EPM Planning to AWS S3 and Tableau? The finance team wants to create live Dashboards in QuickSight by conne…
-
Hyperion Planning Forms: Require all cells to have data enteredSummary: When users add a new TBH employee via form, I want to ensure they are entering all necessary information. Content (required): Is there a way to require cells to…
-
Metadata load from Fusion to EPBCS using DMSummary: Issue with loading members and alias properties from Fusion to EPBCS using DM Content (required): We are loading the metadata from fusion system to EPBCS using …
-
Copy OWP_Status across version in Strategic Workforce Planning.Summary: Requirement is to do Hiring, terminations and transfers in a different version (what if) and hold back the original data in the base version. While copying the …
-
guys, is anyone having problems with the São Paulo data center?Summary: we are slow to perform refresh, we have already restarted the service and we are still having problems. Content (required): Version (include the version you are… -
Dynamic Calc Accounts not adding up in Department dimensionSummary: Content (required): We have two dynamic calc accounts in our workforce cube that are not adding/aggregating up in the department hierarchy. They are both set to…
-
Executing Data Load Rule from Groovy RuleSummary: Executing Data Load Rule through Groovy Rule. Content (required): Hi All, We have a requirement to call Data Load Rule from Groovy Rule. Is there a Command whic…
-
'Add' Export option in Data Management not accumulating data into the cube intersectionHi All, We've created a data management process to load data from a file and export it into our application. After the import phase into Data Management there are 23 rec… -
Can we extract a report of the Metadata changes since the last DB refresh in clould EPBCS?Summary: If I recall correctly, we have an option in 'On-Premise' to extract a copy of the Metadata changes since last refresh. Do we have any such thing available for c… -
Security refreshing?Hi Team, How does security work in terms of it being "refreshed"? I recall that when assigning roles in MyServices it took time for it to be provisioned, but what about …
-
Sorting by Date & Recognizing Date in Managerial & Narrative ReportingSummary: Is it possible to sort by date in report in Managerial Reporting? Currently, the dates do not seem to be recognized as number values and we want to utilize a dy…