Calc Manager
Discussion List
-
Create or Update All Substitution Variables Defined for the ApplicationHello, I am trying to leverage "Update Substitution Variables " REST API and below is the code: Through Postman it is working fine. I am trying to execute it as I did fo… -
Is it possible to have a specific message show when throwing veto exception on a form rule?Summary: If a rule has a veto exception triggered when launched on save of a form it doesn't show the message on the pop up on the form, just that the rule failed. Conte…
-
Download CSV file from EPBCS inbox using GroovySummary: We are looking for a groovy code to download a file from epbcs inbox/outbox explorer to local machine. Unfortunately, we can't use epmautomate. Content (please …
-
How do I fetch salary rates by Pay Type on new requisitions in Oracle Planning (EPBCS)?Summary: We added Pay Type (Exempt/NonExempt) to our Salary Grades table in Workforce Planning; We're no longer able to pull the new rates when using the Salary Grade op…
-
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…
-
Can we display member alias instead of member name after selecting the members in Business Rules RTPSummary: Can we display member alias instead of member name after selecting the members in Business Rules RTP's in Forms. Currently system is displaying only member name…
-
@remove not workingSummary: Content (please ensure you mask any confidential information): Hi We need to clear all accounts value, except a few. But when launched it is deleting all data. …
-
Business rule execution timed out. Please increase the Batch Timeout and execute the process.Summary: I am running an integration to load TB data and I have added a post-load rule business rule which is doing aggregation at the total level. The rule is failing w… -
Groovy Rule using Substitution variable for colouring forecast monthsHi, Can we color forecast months using substitution variables (Jul to Dec)? Let's suppose I have Substitutions variable FCSTMonths (Jul to Dec). Is there any way to colo…
-
ASO Copy data from one member to anotherSummary: How to copy data from one member to another Content (please ensure you mask any confidential information): Hi All, I am trying to copy data from one member to a…
-
ASO Calculation Script Very Slow!Hi, We have an ASO Freeform application and I am trying to calculate prior year retained earnings using the formula template using the following script, but it is taking… -
EPBCS Datamanagement groovy rule - with Json loopSummary: Hi Expert, I'm trying to call a groovy rule which will execute Data integration , changes source filter based on subvar for ent1 and ent2, First ent1 filter sho…
-
run scripts parallelySummary: Content (please ensure you mask any confidential information): Hi is there a way i can tell the system to run the highlighted in yellow color scripts - to run p…
-
Populate a Smart List with a Parent of a value from another Smart ListSummary: I have two Accounts, ProjectChild & ProjectParent. Both have Data Types of Smart List and both Smart Lists are referring to Dim members in the Entity Dimension.…
-
Security for Funds Reserve menu item?I am wondering how we can view and modify security on the Funds Reserve menu item in the Revision Management action menu. I've tried a few different things, but nothing …
-
How can move Artifact Snapshot from instance to other instance by scheduleHello everyone, I have one question. I need to move the artifact snapshot from the Production instance to the Test instance automatically. How can I do it without using … -
Is there a way that Supplemental calculation can pick up the shortness from the Regular calculation.Summary: Hi All, The payroll calculation set up for Regular paycheck and Supplemental paycheck are default to calculate separately. In the case of low regular earning, s…Eswar Kishore 11 views 0 comments 0 points Started by Eswar Kishore Payroll and Global Payroll Interface (GPI)
-
How do i create a member formula to pull for children as wellI would like to create a scenario member with a member formula that will calculate the variance between two columns in my management report. Then when I drill into the, …
-
Dynamic calc members crossing dim with smart list member does not calculateSummary: Content (please ensure you mask any confidential information): Hello, I have the following calculation Sparse_DimA = @MEMBER(@CONCATENATE("HSP_ID_",@HSPNUMTOSTR… -
Functions Not Supported for Hybrid AggregationHello! I've been reading the below document and it confuses me Does it means that any of this functions are not allowed if Hybrid is enabled? I've performed some test wi… -
Currency conversion rule not working for certain currenciesSummary: Multi Currency Planning application has been set up and up until now, the currency conversions have been working fine for all scenarios. Now there is a new scen…
-
I am trying to use Groovy scripting to return the current user name for an account within Planning.Summary: In Planning, I am trying to return the logged user name (full name if possible) for an account which shows the initiator of the process. For example, if I log i… -
Business rule is not executing for selected members and not working when the calc block has logicSummary: We have encountered an issue with a newly created business rule where the if condition and fix statements do not execute as expected. The problem manifests as f…
-
Simple Calc Script QuestionI'm coming in on the tail-end of an EPM implementation. We're about a year into the process, and I don't have formal training, so I've been attempting to reverse enginee…
-
ASO GROOVY Script to export data to a file for a specific scenario excluding the shared membersSummary: Hi All, Im trying to write a calc manager groovy script to export the data out of ASO reporting cube for specific scenario to a file which excludes the shared m…
-
Unallowed commands on BRHello everyone! I'm migrating a planning application from on-premise to EPBCS cloud. I'm aware that there are not allowed commands on EPBS such a "SET CACHE HIGH" and si…
-
Copy amount to many different combinationSummary: Hi, I need some ideas for my case. So, in my case, I want to copy the amount from the specific combination to many combinations (Entity-Division-Account level),…
-
How to Extract Shared Parent member name for a member in a shared hierarchyWe have an alternate shared hierarchy in the Account dimension. We want to extract the shared parent member name for a given Account in the alternate shared hierarchy. I…
-
Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using GroovySummary: Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using Groovy Content (please ensure you mask any confidential information): I want to Cop…
-
How to know CECOs and Accounts that have in different formsHello Experts, I have an assignment to do, in planning process we have all the accounts and all de cecos covered by different forms. I have maybe 50 forms with different…