Integration
Discussion List
-
Did Feb-25 Update Break Datamaps in Pipelines?Hi All, All jobs in Prod post Feb-25 update on Friday 3/21 now fail once it hits the DATAMAP jobs. I tried re-creating a new DATAMAP and continues to fail. Anyone else s… -
How to Update Stages in Pipeline via LoadWe have Pipelines in Oracle Cloud Planning that easily can have a dozen stages where the same substitution variable is used between running business rules. Is there a wa…
-
Limitations on REST API import data sliceHi! There is some kind of limitations regards to number of row/columns when using the Import Data Slice REST API? Import Data Slices Because it is returnig Error 400 onl… -
Scheduled Pipeline Jobs are failing in EPMCSSummary: Pipeline jobs in EPMCS are failing, these jobs are responsible to push data from EPBCS to EPMCS Content (please ensure you mask any confidential information): V…
-
Application registration failed - HCM CloudSummary: We are setting up integration with HCM, Test connection is successful but under Applications > Add Data source > HCM Cloud - "Application registration failed" e…
-
Drill Through to SourceSummary: After creating a successful file based data integration, we want to use the right click menu on a form to Drill Through to the Source just to see the workbench … -
Issues using the new Data Management Adapter to load data from Oracle CloudSummary Can I load data using a custom report with the new adapter - data from HCMContent With the new toys that came out in the latest Planning patch release I was inte… -
ability to add schema prefix for EBS GL Balance AdapterSummary: We have created a custom schema SVC_HYPERION2EBS in Oracle EBS and have provided grants to the Custom schema to access all the required tables for the EBS GL Ba…
-
Specifications when the status is "Failed" with 3303 in Data IntegrationAfter running the integration, when I checked the process, the job failed with 3303. Then, when I checked the data in SmartView,all the data except the record that cause…
-
Copy Object storage to EPM and Vice VersaHi All, I am facing issue while copy data from Object storage to EPM. Step 1: I have created Bucket and uploaded a file and created a Auth Token. Step 2: In EPM i have c…
-
Data Integration - target cube 'missing' in DLRSummary: Content (please ensure you mask any confidential information): When I try to create a new DLR in data exchange or modify an existing DLR, I've noticed that the …
-
Incremental data load FailingDear experts, Trying to do incremental data load for view based integration. It's failing at import stage. Account dimension is driver and we are trying to load numeric … -
HCM Integration to OEP_WF and OEP_WFSCSummary: Wanted to see if anyone has experience with the HCM data integration to Workforce Planning. We are using the OOTB extracts and one of the feilds in the Asignmen…
-
Data Integration rule in PBCS how can load several lines to the same point of viewSummary: I am creating a data load rule in PBCS in data exchange to load data through a file. The file had several lines that need to be loaded on the same point of view…
-
Drill Through to Source not workingI'm attempting to Drill Through to Source directly from Planning, and it doesn't seem to be working for me. Briefly, the URL comes up (https://xxxx.fa.ocs.oraclecloud.co…
-
Using PBCS Cloud, how to use the REST API to Get the attachment after executing a jobSummary: Using PBCS Cloud, how to use the REST API to Get the attachment after executing a job from Application > Overview > Export Data. I see the job execution & can m…
-
Integration Pipeline process failed for power user to load data from Planning to FCCSSummary: Content (please ensure you mask any confidential information): Hi all We have an issue were a power user set to be a proxy user so they should be able to load d… -
Period mappings not working properly for data integrationI'll admit; the title of the question isn't totally accurate as I know for a fact it's something I'm doing wrong, but for the life of me I can't figure out how to fix it…
-
"Unable to retrieve source budget name" error during EPM to ERP (BC) integrationWe've run integrations several times over the past couple of years to move data from Planning to Budgetary Control in ERP, but this is the first time I've gotten this er…
-
Create Choice List for Integration FiltersSummary: Create a drop-down list for Integration filters Content (please ensure you mask any confidential information): Hi, I found this document using "Choice List" to …
-
Is there a way to automate updating data map member mappings?Summary: We have a cross pod data map with member mappings. There is no ability to do dynamic member maps so we need to manually update it every time a new member is add…
-
The member [NONE] does not exist for the specified cube or you do not have access to itSummary: The member [NONE] does not exist for the specified cube. It is currency dimension. Content (please ensure you mask any confidential information): I found this s… -
Using groovy to move a file from the Data Management Inbox To the Oracle Planning Inbox ExplorerI am working with OTBI report(s), and this report holds master data which needs to come into EDMCS. OIC is being used as the facilitator from Oracle Fusion into the Orac…
-
is there any direct integration between planning PBCS Custom cube and fusion Project accountingSummary: I want to import budget data from project accounting to PBCS at high level without the projects name. The project's budget is already in project accounting and …
-
Data Exchange - File based Multi Period data loadSummary: For File based Multi Period data load, we are trying to load data for a single month, but it considered all the months defined in the Amount (using driver funct…
-
Not getting option to export multi-column flat file from EPBCS using data management.We have a requirement of generating multi-column flat file from EPBCS using data management. But there is no option as such in data management or data exchange. How to a…
-
cube refresh in pipelineTrying to create a Cube Refresh job in the Pipeline but facing below error 2024-04-02 11:29:36,906 INFO [AIF]: Process ID : 296 2024-04-02 11:29:36,906 INFO [AIF]: Job N…
-
Oracle Data Intergrator Patch 2025 JanSummary: Oracle has provided Patch for Jan2025, upon verifying ODI patch is not listed. is any patch available for ODI for Jan? Content (please ensure you mask any confi…
-
Drill through option not available in Forms 2.0Summary: Drill through has been setup from FCGL to Planning and works through Workbench, Reports in NR as well as Smart View (after installing chrome addon and setting a…
-
Epm agent Integration for Oracle JD Edwars and Oracle PBCSSummary: Integration data Content (please ensure you mask any confidential information): I need to integrate pbcs standard release 25.01.31 with jde release 9.2.7.3 and …