EPBCS
Discussion List
-
Intermittent error for groovy script - An unknown error occurred when executing the script.Summary: Intermittent error for groovy script - An unknown error occurred when executing the script. Content (please ensure you mask any confidential information): We ar… -
EPBCS Smartview issues after WebView2 updateWe've started having connection issues with EPBCS after a recent Microsoft update. Curious if any others are having similar issues. It appears to have started around 10/…
-
Custom Projection Formula for GMROL - ASO CubeSummary: Hi All, I need some help how to write formula for Scenario dimension member in ASO Cube - We have custom scenario called STL_Projection which shows Actuals for …
-
ASO Cube refresh errorHi Experts, I am getting this error when refreshing ASO outline : ASO members with time balance members requires a time dimension to only contain stored hierarchies. Mem…
-
21C to Freeform - Unable to process outline due to cube Name is nullHi all, We are trying to import LCM of an Essbase 21C application (.zip file) into a Freeform application. Using "LCM Export" option available in Essbase 21C job console…
-
Oracle EPM Data Exchange Validity SQL code working inverselyHi all, I am working on a File based #DataIntegration scenario where the source data contains a column which states the validity of the row saying "Active"/"Inactive" th…
-
Drill thorugh to ERP - Processing Quick Drill issueHi all, We are trying to Drill through to ERP application from a data form. On clicking “Drill through to Source” from the data form, the application remains stuck on “P…
-
Can anyone explain why the 'Saving Intergration' always hangs in Data Exchange?Hi, It's so frustrating and cannot figure out why at certain points(seems random) that Data Exchange will not save the integration. It just hangs on this screen. Anyone …
-
How to create the SFTP connect in EPBCS for Using a Copy from SFTP Job Type?How to create the SFTP connect in EPBCS for Using a Copy from SFTP Job Type for pipeline? I tried creating SFTP connection in connections in EPBCS Application. What shou…
-
Oracle EPBCS: Unable to execute CopyfromSFTP in pipelineHi all, In our current project, we are trying to bring a txt file from SFTP server to Oracle EPBCS Inbox folder. We have recently encountered a job "CopyfromSFTP" in pip…
-
How to rollup the budget prepared "Month-wise" and "YearTotal" for some scenariosSummary: I have scenario at a client where budget is being prepared on both YearTotal and month level in some scenarios. How can I cater this through the standard period…
-
EPBCS - Batch Timeout in Minutes SettingEPBCS: (Data Exchange>Actions>System Settings>Batch Timeout in Minutes). What is the default value for this setting? The max value? What is the recommended value? Is the…
-
How to check Enterprise recovery setup was enabled or not in EPBCS application?Summary: How to check Enterprise recovery setup was enabled or not in EPBCS application? Content (please ensure you mask any confidential information): Version (include …
-
Dynamic Calc SmartView retrieve times (Hybrid BSO)Hey all, I am swinging into post go-live EPBCS Hybrid BSO app, and trying to improve slow performance in SmartView retrieves. The ASO reporting cube runs fine, but for v…
-
How can we copy cell comments and attachments for a large data set?We are trying to copy comments and attachments from one cube to another, smart push is not applicable in our case. Because we want to push comments and attachments with …
-
REST API - Update a member using groovy ruleSummary Trying to use a groovy rule to update the entity outlineContent Hi all, I am trying to do a groovy rule to update my entity dimension using REST API. However it …
-
"Unknown Member used in query" error in Data Load RuleSummary: I am updating the Source Filter in an EPBCS data load rule, changing the spec for Accounts, but even using the member selector to ensure correct spelling, I am …
-
Dynamic Custom Business Rule to select the number of months for each scenarioSummary: I need to develop the custom business rule in EPM Planning so that user can set the number of months for Actual,Forecast and Budge Scenario for calculation. The…
-
Connect with Snowflake from PBCS applicationI am trying to connect Oracle EPM agent to Snowflake database to source the data from cloud Snowflake DB and load it in PBCS DB. Has anyone done ir?
-
Retrieve member alias for my DataExport File through DataManagementSummary Retrieve member alias for my DataExport File through DataManagementContent Hey all, I need to export on my data export to file, via Data Management, the member a…
-
Is there any possibility to retain Audit history data for two years in EPBCS?In Current EPBCS Audit, Maximum of 180 days audit data is only present. Can we increase this to One or Two years? Through EPM Automate command we see data can be exporte… -
Writing Back Budget from EPBCS To Fusion Budgetary Control and GLSummary: Content (required): Hi All, We are integrating budget data from EPBCS to Fusion ERP. Also we have a requirement to have the balances in both Budgetary Control a…
-
What Happens if a dimension hierarchy type is not set in an ASO cube?Summary: What happens if a dimension's hierarchy type is not set? Does the hierarchy type just default to "Stored"? Content (required): I recently set up an ASO cube for… -
Deleting multiple reports at onceSummary: How can you delete multiple reports in one go? Content (required): Hi all, Our reports (approx 50) are put in a folder structure. As we want to delete all of th…
-
Automate file transfer from SFTP to ePBCS using copyfromsftpI am trying to use copyfromsftp in groovy business rule, rule is working successful but file is not getting copied from sftp to data management inbox. Need help .
-
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" … -
Using Multiple Monthly calendar in a EPBCS applicationSummary: How to make use of multiple calendar in a EPBCS Application Content (required): Hello All, We would like to know is it possible to make use of multiple calendar…
-
HOW TO ADD PRE-DEFINED Substitution Variables TO ALL CUBEHello, I am currently using EPBCS. When checking the demo server, I noticed that the pre-defined variable (OEP_CurMnth) is registered for all cubes. How can I register i…
-
Is it possible to force a line on a form to read only by row/column vs by cell using Groovy?Summary: I would like to have a groovy business rule set security on an entire column or row to read only vs having to do it by cell. Content (please ensure you mask any… -
Multi-period multi-column data load using BIPI want to load multi-column multi-period data from the BIP report, in the report, the headers are like BUCKET_AMOUNT7 BUCKET_AMOUNT8 BUCKET_AMOUNT9 BUCKET_AMOUNT10 BUCKE…Rimjhim Gupta-Oracle 61 views 4 comments 0 points Most recent by Rimjhim Gupta-Oracle EPM Platform and Freeform