To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Data Integration
Discussion List
-
HCM Extract - How to avoid sending blank fileContent Hi Everyone, We are developing a HCM extract to send email with attachments. The interface will be a changes only interface and will be scheduled daily. We don't… -
How to use "Web service" as data source to send data to Service Now from OracleSummary How to use "Web service" as data source to send data to Service Now from OracleContent Hi we are implementing Procurement module in Oracle cloud. we need to send…
-
Stored ProcedureSummary Stored ProcedureContent Hi All, Please help me to how to call a stored procedure in document script section in SQL -
When ODICS certification will be released?Summary When ODICS certification will be released?Content Hi, Could you please let me know the date of ODICS certification available date?
-
Redshift Data server connectivity issue with standalone agent in ODI 12.2.1 on windows serverSummary Redshift Data server connectivity issue with standalone agent in ODI 12.2.1 on windows serverContent I have configured Redshift Data server in ODI for this i hav…
-
Merge datapump filesSummary Merge datapump filesContent Hi , I have a requirement to export and later import table partitions using dbms_datapump API. Going by the standard process, this wi…User_2025-01-31-16-41-25-303 26 views 0 comments 1 point Most recent by User_2025-01-31-16-41-25-303
-
HCM tiles/homepages copying over to Campus SolutionsSummary HCM tiles/homepages copying over to Campus SolutionsContent Why do my tiles carry over from HCM to Campus Solutions in the 8.55 environment? What permissions all…
-
ODI Market Place accessIs there any way to access ODI-MP apart from VNC viewer/ Tiger VNC & Mobaxterm Due to customer security policies the above three applications are not accepting is there … -
FDMEE report for 1st load and last loadWanted a report which can give details on when was the 1st trial loaded for an application and how many times the trial was loaded, and what was the last trial load? Can…
-
is oracle going to deprecate Soap services like Order Import?Summary: Want to understand more Soap Deprecation by oracle. especially on OrderImportServiceSoapHttpPort Content (please ensure you mask any confidential information): …
-
creating two period mappings for the same period key to load from ERP Fusion to P12 P13 (Adjustment)We have a requirement to create two period mappings for the same period key to load December month TB data from Oracle ERP Fusion to P12 (December month TB) and P13 (Dec…
-
Best Approach for Moving Oracle Fusion ERP Data to ADWSummary: Hi We are exploring an approach where we need to extract various Oracle Fusion ERP data entities (such as Suppliers, Supplier Sites, Projects, Items, etc.) and …
-
how do I find out which Fusion base tables are used in ADW/FDI tables and view?I have an FDI report that uses a view (OAX_USER.CER_PO_DETAILS) that is only available on the ADW side but doesn't exist on the ATP side. This view is made of "OOTB" tab…
-
OIC HCM Cloud payroll integration architectureSummary: Hi all, We are building an OIC integration from HCM Cloud to 3rd party system. The downstream payroll system is expecting 11 txt files containing over 150 field…
-
Run a BIP report via SOAP APII'm trying to run a BIP report via ExternalReportWSSService SOAP API and getting 'does not have permission to run the report. What roles or privileges need to be assigne…
-
Do we have CI/CD Process for ODI code movementSummary: We need to migrate the ODI code to higher environment. I would like to know if there is CI/CD pipelines for ODI . Content (please ensure you mask any confidenti… -
What Is the Oracle‑Recommended Best Practice for Loading Legacy Item Master Data into Oracle Fusion?Summary: Hello Team. We are planning a legacy Item Master data migration to Oracle Fusion Cloud SCM and are evaluating different data-load approaches. What is the Oracle…Koda V V Satya Sai Surya Ramakrishna 13 views 0 comments 0 points Most recent by Koda V V Satya Sai Surya Ramakrishna -
Connecting OTBI data models to Power BIHi everyone, I’m facing the following question: I need to use/consume from Power BI the data models that my team has built in OTBI. I also need it to be a direct query/c…
-
OCI IoT Domains with external LoRaWAN: high ingestion complexity compared to other cloud platformsHi experts. Anyone tried a new Oracle IOT PaaS? We are designing an IoT telemetry ingestion architecture on OCI, with the following characteristics: LoRaWAN devices Exte…
-
HR users are unable to view data in a critical OTBI reporti have created a custom OTBI report in Oracle Fusion HCM. When Managers run the report, they are able to see data correctly for both direct and indirect reports, includi…
-
can't update attribute in odiODI: 14c I have created a datastore, and use reverse engineer to get the attributes, but I want to update the type for a column, after update, I can't save the changes, …
-
Oracle Opera APIs requiredSummary: Oracle Opera Receivable Invoice and Receipt APIs required Content (please ensure you mask any confidential information): Hi, We want to integrate our Oracle Fus…
-
Schedule OIC integration to run on 2nd business day (should consider Holidays)We have a requirement to run the integration on 2nd Business day of the month. Currently with iCal we are able to schedule the integration on 2nd Day of the month but un…
-
Custom Script in OIC to read and load data into APEXHello, I'd like to know if it's possible or doable to create a script in OIC that reads excel files stored on cloud as far as I know, then these files should be imported…
-
How to integrate Oracle Fusion with Oracle APEX ATP Database?Hi, As we all know Oracle Fusion is Saas based and customization is always needed. Locally Oracle EBS always having lot of customization. Now my question is to extend ce… -
How to call OIC integration from ESS job synchronously?We have a requirement to call a OIC integration from an ESS Job. This ESS job will run in a Job set . Once this job is complete then only next job should run. The proble…
-
Correct the cause of the read-only state and reopen the workbook to proceed. (ADFDI-07555)Hello friends, We have downloaded and installed the latest ADFDI executable, removed the read-only option, and granted folder privileges. However, whenever we open the E…
-
Detailed explanation or document to create external storage configuration in BICCHi Team, We want to configure external storage in the BICC to extract data from oracle fusion. Kindly share the related document or detailed step to perform the same.
-
Is it possible to schedule a JOB with same business object more than once!?Hi Team, We have ran the below mentioned business object in BICC (test instance) with immediate. If we re-run it whether the whole data will be extracted or only increme…
-