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
-
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 are the significant differences between ODI12and ODI 14cSummary: Significant differences between ODI12c and ODI14c Content (please ensure you mask any confidential information): What are the significant differences between OD…
-
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 1 view 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…
-
-
OIC Integrations are getting stuck with IN PROGRESS statusHi, Our OIC Integrations are getting stuck with "IN PROGRESS" Status. It was working fine until now. We don't see any errors as well. Thanks in advance. Regards, Vikas
-
ODI 14c with Java EE agent connectivity to Oracle Fusion BIP connectivity failedSummary: Unable to connect to Oracle Fusion BIP with error "Cannot connect". "Https not supported" Content (please ensure you mask any confidential information): Version…
-
How to create a self invoice from a customer in Oracle Cloud ARAs part of France e-invoicing reform, companies have to the obligation of integrating all their AR invoices into electronic form (UBL). However, Oracle seems (From is do…
-
How can I check the upgrade schedule for OIC gen3 in 2025?Where can I find the official upgrade schedule for OIC Gen3 in 2025? I heard upgrades are supposed to happen every two months, but the link(※) below only shows informati…
-
OCI ODI-14C MP with ATP DR SolutionSummary: ODI 14 C MP with ATP DR Solution We are seeking a Disaster Recovery (DR) solution for Oracle Data Integrator 14c (ODI 14c) MP ( ATP Repo) environment. Please pr…
-
Cancel Invoice (Business REST Resource) request is not working as expectedSummary: Cancel Invoice is not working as expected using ERP Adapter in OIC Content (please ensure you mask any confidential information): Hi Experts, I am calling a Bus…
-
Missing parameter after changing OIC DB adapter into ATP AdapterHi All, Good day! Our team is migrating from DB oracle into ATP database. We replace out DB oracle Adapter in OIC into ATP adapter. Configuring adapter-invoke procedure,…
-
CDATA driver for Oracle HCM cloudHow to connect to Oracle HCM Cloud application using CDATA driver or any appropriate driver to connect Oracle Fusion?
-
Is it possible to use APEX Package apex_web_service to call ODI Web Service for execute ODI Load PlaSummary: Is it possible to use APEX Package apex_web_service to call ODI Web Service for execute ODI Load Plan ? Content (please ensure you mask any confidential informa…