Automation
Discussion List
-
How to access file in DM Inbox using Groovy?Summary: How to access file in DM Inbox using Groovy? Able to access files in front end Inbox/Outbox explorer. Is it possible to access from DM Inbox or by default only … -
Do we have epmautomate command to export data management workbench data for a particular period?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Pipeline - Download Audit ReportSummary: Hi all, I have created a pipeline to execute the Audit Report in FCC, however, I want to send it by mail to the main users in the same process. Is it possible? … -
How to search a string variable in Groovy for a specific part of a string.Summary: How to search a string variable in Groovy for a specific part of a string. Content: We're currently using an pipeline that triggers everyday and processes the f…
-
Pipeline, can we backup application using pipeline feature in EPBCSSummary: We are trying to get rid of Batch scripts run on Windows machine and utilize the pipeline feature and schedule job using Schedule Job. Currently, we are running…
-
epm fccs to databrickSummary: hi team.. Can someone help me with how to integrate EPM FCCS to DataBricks.. What are the possible ways of achieving it? Content (please ensure you mask any con…Apple143-Oracle 21 views 1 comment 0 points Most recent by Pradeep Arjunan-Oracle Financial Consolidation and Close
-
CopytoObjectStore feature in pipeline doesnot copy file from Data Management specific locationSummary: I am using CopytoObjectStore feature in pipeline to copy file from Data Management specific location to Object Storage. In source path, I have selected Inbox an…Priyesh P. Rane 12 views 3 comments 0 points Most recent by Priyesh P. Rane EPM Platform and Freeform
-
Automate activity report download BUT the pattern?Summary: Download of Activity report works but however as part of automation would like to know how does the pattern change or is there any criteria at all to identify? …NarayananS 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Is there a way to tell the cube type using epmautomateHello, I am working on setting up automation for deploying our EPBCS applications into DR pods. As part of this, I am trying to find a way to programmatically determine …
-
How can I import a dimension file, from the inbox folder that is pipe delimited using APII have uploaded a file to my PCM application data exchange inbox folder. I was looking to use Import API call shown here to import the dimension from a csv/ txt file. Th…
-
Automate file transfer from SFTP to EPMOur current process with OIC renames the file on SFTP(Example file name: Testfile_MMDDYYYY_HHMMSS to Testfile MMM-YY) and moves the file to EPM then deletes the file on …
-
Has anyone attempted to setup Microsoft Entra Provisioning to EPM OCI Gen2 IAM?Summary: We want to leverage OCI Gen2 features available after EPM Cloud was migrated there, to allow User/Role Provisioning with Microsoft Entra. A similar setup works … -
EPM REST API SEND EMAIL V2 - Limitation in allowed characters or lines?Summary: Using REST API Send email v2. This does not trigger email when line exceeds >1 in Calc Manager (body of the email) Content (please ensure you mask any confident…
-
How to pass POV as parameters in URL from EPM as drill through to FDISummary: Hi, We want to drill through to FDI using direct drill option from EPBCS and pass the FORM POV selection as parameters in the URL used in direct Drill. Users re…
-
DATA EXPORT OUTPUTFILE(I.E CSV) MOVE TO DM FLODERSummary: Hi All, We created one data export rule and we want the export output file i.e csv it is automatically move to one particular dm folder after completing the dat…
-
Upload file to data management inbox via rest API using power user accessSummary: We need to upload file into data management inbox using rest API. However the upload file is only applicable for administrators. any other commands available to…
-
Changes to job scheduling in Data ManagementSummary: In the July 2024 Cloud EPM release, the platform job scheduling feature will now support Data Management and Data Integration jobs. In Q4 of 2024, the ability t…Mike Casey-Oracle 53 views 5 comments 2 points Most recent by AS2870-Oracle Enterprise Performance Management Resource Center -
Pipeline variables are unstable, When will this become stable?Summary: Pipeline variables are unstable, and we are hesitant in using our jobs for automations owing to this Content (please ensure you mask any confidential informatio…
-
EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Movement)Summary: EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Account - Movement) Hi All, We are trying to integrate metadata from Or…
-
Send Email REST - Allowed email attachment size is 10MB. Will this be increased?Summary: We have a requirement to attach more than 10MB files to Business Users. Content (please ensure you mask any confidential information): We have a requirement to …NarayananS 42 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Attributes)Summary: Hi All, We are trying to integrate metadata from Oracle ERP to FCCS. How do we set up the attributes, especially for the entity, to set it to ICP_Entity_Yes, an…
-
Pipelines Connections strings appears only for File OperationsSummary: Pipelines Connections strings appears only for File Operations and not for other jobs (Example: Metadata exports of remote PODs) Content (please ensure you mask…
-
Metadata Integration from Oracle ERP to EPM export is not working in Data ExchangeSummary: Metadata Integration from Oracle ERP to EPM export is not working in Data Exchange but working in Data Management Hi All, I've noticed that whenever I run and e…
-
EPM FCCS - out of the box integration for loading metadata from Oracle ERP Cloud to EPM (Consol Op)Summary: Hi All, we are trying to integrate metadata from Oracle ERP to FCCS Cloud using out of the box integration. We noticed that the Consol Operator were ignored. Wh…
-
generate user report for a specific group in EPMSummary: Hi Team, We are trying to export/generate all Users in a specific group on a regular basis and send to all approvers to verify/confirm that the list is accurate…
-
Bulk delete folders in data exchange file browser or Data ManagementSummary: How to delete multiple empty folders at once in the file browser in Data Exchange? Content We have setup an openbatch pipeline which processes all files placed …Jeroen Goudvis 25 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Groovy Pipeline execution - Variables are mandatory?Summary: Using a Groovy BR to trigger a pipeline (export mapping job) and it was working fine with no variables defined. When the rule was triggered today interestingly …NarayananS 1 view 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
Looking for Groovy Scripting samples to achieve File renaming & deletion in the Inbox/ OutboxSummary: We are looking for an automated way to manage the files in the inbox/outbox of the Planning Cloud instances. We are thinking of 3 usecases: keeping more than 1 …R Abel 114 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
How do we automate the Artifact Updates ReportSummary: Need a way to automate running the Artifact Updates Report for Audit. Content (please ensure you mask any confidential information): We need to provide an audit…
-
Groovy to access a file in Inbox/Outbox explorerSummary: Is there a way to access a CSV (precisely a metadata file) present Inbox/Outbox explorer using groovy? Intention is to Automate Metadata across apps Am able to …NarayananS 270 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform