Data Integration
Discussion List
-
Why is there a difference loading data with service administrator and user loads to FCCS app?Currently we are loading data at our client through data exchange. When we loaded our dec-23 data we found that the numbers in PL and BS were not the same when we loaded…Ritesch Malhoe 41 views 4 comments 0 points Most recent by Erringc Financial Consolidation and Close -
Pushing data from FCCS to client's on-premise HFM applicationSummary: The requirement is to push data from FCCS to client's on-prem HFM system. Requesting your recommendation/best practices regarding whether this integration (Data…Giridhar Kumar-280189 51 views 3 comments 0 points Most recent by SureshM-Oracle Financial Consolidation and Close -
FCCS pipeline to run PCMCS rule setSummary: Hi Mike Casey, We are trying to find out the whether the FCCS pipeline can call PCMCS rule sets We have created connection in FCCS (for PCMCS) Created a pipelin…Sreekumar Hariharan 111 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Missing File When Using an Export Dimension by Name (EDMCS) Job Type in PipelineSummary: I am testing export Dimension by Name (EDMCS) Job Type in Pipeline. I created EDM connection: https://edmcs-test-domain.epm.****.oraclecloud.com/epm Parameter: … -
How to use Substitution Variables in Data Management-EPCMCSSummary: Hi All, Is this possible to use Substitution Variables in data load mapping?. Let say we already run 12 month data for working version and now we want to copy t… -
Customizing default integration with DFF (Flexfields) between EPM and PPMSummary: Is it possible to adjust "Import Project Actuals" (EPM side) to pick up 2 flexfields from PPM? Customer uses 2 flexfields into PPM (Oracle Project Management) t…HMMgl-Oracle 55 views 2 comments 1 point Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform -
FCCS Drill Through from PODSummary: I'm working with my Cyber security team and I'm building a case for a Web Server the architected defined to allow drill through to Oracle (OCI) PS tables via th…Jeff Gilliam 31 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close -
How to load parent member (store data type) with dynamic cal children account?Summary: I did integration from FCCS to PBCS but always failed to load parent member (store data type) with dynamic cal children account. FYI In FCCS the parent account … -
Data Management Loading Differently for Power Users vs. AdminSummary: Data seems like it is loading differently for Power User's vs. and Admin into FCCS. Content (required): We have recently loaded data into FCCS using a Power Use…Matthew Gregory-137392 141 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Load Oracle Fusion GL to FCCS - P13 DataSummary: Content (please ensure you mask any confidential information): I'm trying to load P13 Trial balance data from Fusion GL to FCCS as normal using data integration… -
Data Management : Unknown Member [Company] used in querySummary: We are in Data Management and we are importing data from ERP Cloud to FCCS. Import does not run if i set a single source company on Data Load Rule Filter. Conte…Stefano Francese 82 views 2 comments 0 points Most recent by Stefano Francese Financial Consolidation and Close -
FDMEE artifact migration issues since 24.02 patchSummary: Since the 24.02 patch we are unable to import snapshots without errors for the FDMEE artifacts. The process we took was: Overview -> Remove application Import f… -
Importing data records surrounded by quoteHello. I'm trying to import data into FCC and the records, while comma delimited, are surrounded by quotes. They look like this: "Account,CostCenter,Amount" So the whole…ericerikson 21 views 4 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform -
GL to EPCM inbound integration failing with Replace modeSummary: GL to EPCM inbound integration failing with Replace mode for Entity dimension members only. Error message says failing to clear data for Entity members which ar…Bala Vishwa Gautam 51 views 9 comments 0 points Most recent by Pratap Ball EPM Platform and Freeform -
Unable to get "Parent Currency" expression in Data Export to File option in FCCS Data ManagementSummary: Data Load Rule has been created to export all the data in FCCS to flat file and in DLR filter, Against currency dimension, "Parent Currency" is used. When we ge…Harshith J Rao 11 views 2 comments 0 points Most recent by Harshith J Rao Financial Consolidation and Close -
Data Integration Pipeline Administration Mode failingSummary: I am adding the Administration Mode As per documentation regarding pipeline, but it keeps failing, we have Type: EPM Platform; Job Type: Administration Mode; I …Vero Ortiz 81 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can a pipeline validate metadata in FCCS?Summary: Can a pipeline validate metadata in FCCS? Content (please ensure you mask any confidential information): I'm building an automation using EPM pipeline to load m…Handel Zhuang 22 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Extract Data with the Full Qualified Name for All AccountsSummary: Content (please ensure you mask any confidential information): Hi All, We are extracting data using the data export feature in data integration and it is extrac…Ayeshan 51 views 3 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform -
Data Exchange - Clear Region broke after Jan-24 UpdateHi, Unable to select members from the hierarchy in the 'Clear Region' option in Data Exchange on all DLR's. Anyone else notice this? Our last successful run was Jan 19th…Hyperion_Junkie 71 views 8 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform -
Super user cannot Export data using Call AIP. Getting error that user doesn't have privilege.Summary: We wanted use API Call to export the information created in the Jobs. Super user has Data integration roles (Drill Through, Run, Create) but still we are gettin…wojciech.furmanek 31 views 4 comments 0 points Most recent by wojciech.furmanek Financial Consolidation and Close -
Pipeline Move from Outbox OR Download/Upload File OperationSummary: Pipeline as per 23.09 includes 'Move' from Inbox. Could we know about 'Move' from Outbox? OR Download/Upload File operation availability? Content (required): Pi… -
Pipeline Start and End Period failing though REST API but successful when executed manually.Summary: Pipeline variables for start and end period work properly when executed manually but fail whenever the job is executed through a REST API call. Content: I've cr… -
DLR Members Selected if no Source Filter GivenI have a DLR which is pulling data from an FCCS application to a TRCS application. The DLR has no Source Filter specified for the dimension Data Source. The structure of…annaschmult 51 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform -
Can a User run a pipelineSummary: Is there any way that a "User" can run a pipeline, removing the dependency on the Service Administrator? Content (please ensure you mask any confidential inform…