Category 222
Discussion List
-
Can we use sql hints in OIC DB adapter while running a SQL statement?Summary: I want to use a SQL hint in OIC DB adapter to run a SQL statement . When I click on validate query it says success . But on finishing the configuration the proj… -
Issues with jobDetails portion of importBulkData SOAP callSummary: I am getting an 'HTTP/1.1 500 Internal Server Error' whenever I try to make an importBulkData SOAP call. I have tried with 2 different import job processes with… -
Oracle PaaS Consultant-Oracle 7 views 2 comments 0 points Most recent by Jan Kettenis-Oracle Integration
-
How to trigger an Integration in OIC from ESS Job in Oracle Fusion SaaSSummary: How to trigger an Integration in OIC from ESS Job in Oracle Fusion SaaS Content (required): I have an Integration in OIC and I want it to be triggered by submit…
-
OIC Workday Adapter For Journal EntriesSummary: OIC Workday Adapter for Journal Entries to Oracle Content (please ensure you mask any confidential information): Hi Team, we are trying to see if OIC predefined…
-
Salesforce SOAP Message Notification LimitSummary: We have an integration from Salesforce to Oracle SaaS using OIC . Outbound SOAP message with notifications were used to send the invoice lines to OIC. A single …
-
Configure access token in PostmanHi, Kindly assist how to configure new token in Postman for the type OAuth 2.0 -
How to change the 'Incomplete' status of created requisition using REST API to 'Pending approval'?Summary: I created requisition using REST API goes to Incomplete status, how to change it to Pending Approval? Content (please ensure you mask any confidential informati…
-
Upload Files to UCMHi Team, we have a use case where files need to be uploaded (FTP) from third party systems to UCM server. Know that webservices/Rest service is available to load the con…
-
Oracle DBAAS Connection Error: ORA-12504 - Listener Not Given SID in CONNECT_DATAHi, I'm encountering an issue with our Oracle DBAAS connection. We've got this connection type set up, which use an agent to link with our on-premise Oracle database. Od…
-
Async Stored Procedure Call from OIC through Oracle ATP AdapterSummary: Currently, we are having timeout issue (exceeding 240 seconds) when executing a Stored Procedure through ATP Adapter. I don't think there's any problem on the D… -
-
Unable to pass parameters in ESS Job REST APISummary: I am trying to use ESS Job REST API to submit ESS Job requests from VBCS application. The PATCH operation of the REST API works fine , but it does not pass the …sksaran_5 246 views 3 comments 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration
-
Compartment level access for a user in OIC in addition to predefined roles such as ServiceDeveloperSummary: Compartment level access requirements for a user in OIC in addition to predefined roles to Oracle Integration users and groups: ServiceAdministrator, ServiceDev…
-
WLS-JMS & OIC Kafka QueueSummary: WLS-JMS & OIC Kafka Queue Content (please ensure you mask any confidential information): Hi Team, We are looking out for the documentation between WLS-JMS and O…
-
How to run OIC end point in PostamanSummary: Hi how to run OIC end point url in Postman Content (please ensure you mask any confidential information): Version (include the version you are using, if applica…
-
Attachment is in BLOB FormatSummary: Hi As per screenshot, Attachment stored in DB in BLOB format. I need to read and attach the attachment in AP invoice using REST api. How to achieve? Content (pl…
-
jsPDF javascript library not allowing me to activate integrationSummary: Hi Experts I have created an integration which makes use of jsPDF library. I'm able to import the library into OIC and also i'm able to pass parameters to libra…
-
How "security" works for a "trigger and invoke" REST API connection?Summary: To my understanding, the Security for a "Trigger" REST API connection means the authentication requirement of the OIC connection (and peer system need to follow…
-
REST API concat in OIC giving extra characterSummary: I am calling a REST API: https://abc.oracle.ocs.oraclecloud.com:443/hcmRestApi/resources/11.13.18.05/workers?q=PersonNumber='4' I have used the REST API Adapter…
-
Pub/Sub Gen 3Summary: We've recently upgraded to OIC Gen 3. With Gen 2, we're looking for Pu/Sub pattern via OCI stream. Now with Gen 3, we've gotten this "Event" feature. Need to kn…
-
How to increment numberSummary: Hi I am trying create AP invoice using rest api. I want increment value 1 based on row in "getInvoiceLinesOutput" and then need to assigned value to Line number…
-
How to convert date in desired formatSummary: Hi I am getting date 2024-03-20 in this format from VBCS page and need to convert this date in 20-MAR-2024 format and further need to send date to OIC. Input da…
-
Working of CreditCheckingService SOAP WebserviceSummary: Working of CreditCheckingService SOAP Webservice Content (please ensure you mask any confidential information): Hello Team, We would like to know how the Availa…
-
Does Fusion Apps (HCM, ERP) honour the X-Forward-For (XFF) HTTP header for client IP decisions?Summary: Does Fusion Applications (HCM or ERP) honour the X-Forward-For (XFF) HTTP request header for client IP decisions like environment IP "allowlisting" or LBAC? Con…
-
Best practice documentation for managing Fusion Apps Scheduled ProcessesSummary: Where can I find Oracle's best practice documentation for managing the Scheduled Processes within Fusion Apps? Content (please ensure you mask any confidential …
-
ATP Database "Perform operation on table" operation error while invoking the connection errorSummary: I am invoking the Oracle ATP connection in integration, While I select "Perform an operation on a table" I am getting below error: Please help me with the solut…Veera venkata satya Ranga Prasad 16 views 4 comments 0 points Most recent by Veera venkata satya Ranga Prasad Integration
-
OIC: EBS adapter REST API response is always returning null fieldsSummary: EBS adapter is used in OIC to query batch details by passing batchID as input to the REST service. EBS REST API called from SOAP UI returns expected response bu…
-
BICC Mappings in ODI Will Not Load Data to ADW After BICC Object Structure ChangesSummary: Oracle Support Document 2718083.1 (BICC Mappings in ODI Will Not Load Data to ADW After BICC Object Structure Changes) can be found at: https://support.oracle.c… -
Need steps to enable dependent LOVs Based on Table based LOV parameters in Custom ESS JobsSummary: Need steps to enable dependent LOVs Based on Table based LOV parameters in Custom ESS Jobs Content (required): We have made use of a static list of values and c…