Integration
Discussion List
-
Export multiple years data to a fileHello everyone, This post is for sharing purposes. Today I’d like to share with you a topic related to multi-year data export to a file. While going through the Oracle c… -
Can we filter out data before processing an integration?Summary: We have a file from which 50% of data is ignored by the data integration built in EPBCS. Is there a way to filter out the unnecessary data in EPBCS before it pr… -
Migrating files in the Home Directory Data ManagementSummary: We are working on cloning environment from one instance to another. For Data Management, the client would like all the files in the inbox and Home directory to … -
ORA-01427: single-row subquery returns more than one rowhello, Getting this message when tried to load a via data integration from epm to erp. has anyone ever faced this type of error ? -
Multi-Year Data Export to FileSummary Data Export to File is incorrect if run over multiple yearsContent Hi all, I've noticed that running a 'Data Export to File' in data management over mutliple yea… -
Unable to use RTP while running a data map using Groovy as smartlist to member mapping is presentSummary: We have a requirement to use RTP while running a data map using Groovy, users need the flexibility to run the data map for their organizations. But the data map…
-
Period and Year extracted from Oracle database in columns - not working in FCCS Data ManagementSummary: Period and Year extracted from Oracle database in columns - not working in FCCS Data Management Content (please ensure you mask any confidential information): W… -
Unlock all locations in EPBCS Data Exchange is not working as expected.Summary: Unlock all locations in EPBCS Data Exchange is not working as expected. Content (please ensure you mask any confidential information): In Data exchange when we …
-
PBCS Concurrency Issue During Data loadWe are loading data from Fusion to PBCS using Data Management, and the process is triggered through a pipeline. In our setup, we have multiple Data Load Rules within the…
-
Control Budgets that share same Budgetary Control Cube in hyperion planning (not financials module)hello I have 2 Control Budgets that share the same Budgetary Control Cube in ERP and I want to do a data integration from hyperion planning cloud (not financials modules…
-
Unable to export data from EPBCS to ERP Budgetary ControlSummary: When we try to export data from EPBCS to ERP Budgetary Control, we get an error : ORA-01427: single-row subquery returns more than one row Content (required): W…
-
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…
-
Issue in Extracting GL Balances from Fusion GL to EPM ApplicationSummary: Issue in Extracting GL Balances from GL to EPM with General Ledger Cube Balances Content (please ensure you mask any confidential information): Hi, We are tryin…
-
Export Budget data from EPM to ERP Cloud Budgetary controlSummary: When I try to export data from EPM to ERP, I get an error: [NULL ACCOUNT VALUE] Content (please ensure you mask any confidential information): Hello everyone,I'… -
Integration of EPM Agent with ERP Subledger Using SQL & Loading Fixed Asset Depreciation Data in EPMHello, We are looking to integrate Oracle EPM with our ERP subledger using the EPM Integration Agent. Specifically, we would like to: Use SQL queries to extract data dir…
-
How to create attribute dimension members through DMSummary: I have Project dimension for which there are 3 attribute dimensions - ATTR1, ATTR2, ATT3 I am able to assign the already existing attribute values to the projec…Rimjhim Gupta-Oracle 28 views 2 comments 0 points Most recent by N.S - Navulla Saikrishna-Oracle Planning -
How can we load Attribute dimension into EPBCS using Data Management?Summary: Hello Experts, Is there a way to load the Attribute Dimension into EPBCS application using Data Management? Content (required): Loading through flat file is an … -
Upgrade to Essbase 21.7.x for 25.11 Connections failingThere was an error rendering this rich post.
-
Maximum Number of Explicit Mapping Creating in Data Management using fileSummary: Maximum limit of creating Explicit Mapping in Data Management Content (please ensure you mask any confidential information): Hi!!, What is the Maximum row Limit…
-
Predictive Cash Forecasting seeded integrations to Receivables, Payables, and Cash ManagementSummary: Is there a confirmed timeframe for the release of the seeded integrations to receivables, payables, and cash management for Predictive Cash Forecasting? Content…
-
pipeline file name that changes every monthSummary: my file in SFTP serveur is PBCSFILE_XXXX where XXXX changes every month (202508, 202509) is it possible to make this dynamic ? i tried with substitution variabl…
-
How to bring budget data from EPM to back to Oracle GL and where to store that so that we can use thSummary How to bring budget data from EPM to back to Oracle GL and where to store that so that we can use the budget data in the FRS report out of GLContent How to bring…
-
Issue with loading entity currency data to multiple currency for FCC to Planning integrationWhile loading data from FCC to Planning, we are receiving data from FCC for Entity Currency, but we want to load data into Planning by currency. We have a potential solu…
-
FDMEE Query Result Limit OFC to PlanningSummary: Hello, I currently have a Data Integration between our OFC and Planning applications. This is something we've had setup for a long time and has worked without i…
-
Data Exchange - 2 members accounts with smartlistGood morning everyone, I have a CSV file containing two member accounts with smartlists (Position and Scale). In my Import Format, I have the File Type set to "Multi Col…
-
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…
-
Data load between EPM PBCS and FAWHi Team, need suggestions in data load from FAW into Oracle EPM PBCS - any reference of connections / blogs etc? Inbound integration into Oracle EPM (PBCS - Planning Bud…
-
Data Exchange Oracle Write Back on EPM Agent folders appdata/data staging data not createdSummary: PBCS Oracle Data write back rule does not create the staging file Content (please ensure you mask any confidential information): Data Exchange - DLR Run does no…
-
Performance issue with writeback operations to Snowflake table using EPM Integration agentHello, I am trying to load some data in Snowflake table using EPM Integration agent. It is crossing default batch timeout of 30 minutes to load just 5k rows and integrat…
-
$value is being considered as variable in REST API get method (SharePoint Integration)Hi guys, I am trying to get data from a CSV file which is uploaded in SharePoint to EPBCS application. From Sharepoint REST API, using the following Source URL GET https…