Category 222
Discussion List
-
Return a json collection from a REST integration involving Oracle DBAdaptorHi All In Oracle 19c I have setup a proc that returns a nested table which references a plsql record. Back in OIC when trying to reference the proc I encountered a 'JCAB…
-
BI Report read issue in OICSummary: When i am trying to read BI Report in oic using stage activity but getting error . attached xsd file for reference. Content (please ensure you mask any confiden…
-
How to enable postman header field in OICSummary: Hi While doing Post activity , i need to enable Upsert-Mode =True . Now How i can do same thing in OIC Content (please ensure you mask any confidential informat…
-
OIC AppDriven Rest API LimitationsHi, Would like to understand the limitation of AppDriven Rest API's like maximum concurrent runs, maximum queue limit and number of underlying threads. Any documents wou…
-
How many "In Progress" instances can there be in OIC Gen 2?Summary: On the "Track Instances" page, running OIC instances are shown with an "In Progress" status. How many instances will OIC allow to be in this status before it st…
-
Notification activity (no) fault handling?Summary: Hi all, Any help with the following would be appreciated. I need to send mails with notification activity in a very controlled way because it is used as interfa…
-
Enhance REST call in OIC IntegrationSummary: Enhance REST call in OIC Integration Content (please ensure you mask any confidential information): I'm looking for some ideas on how I can improve the performa…
-
HcmTopModelAnalyticsGlobalAM.OrganizationAM.LegalEmployerPVO not returning latest valuesSummary: We are using HcmTopModelAnalyticsGlobalAM.OrganizationAM.LegalEmployerPVO to extract legal employer details. OrganizationUnitTranslationPEOName is updated in Fu…
-
Get specific data group from BI reportHi, request := ' …
-
Attaching PDFs to Multiple InvoicesSummary: Content (please ensure you mask any confidential information): Hi all, I am attempting to attach PDFs to multiple invoices (a one to one). The way things are se…
-
Possible to take a file from Object Storage to OIC File Server?Summary: There's plenty of examples of how to go from the OIC File Server to Object Storage but I can't find anything to show how to take a file from Object Storage and …
-
FBDI Callback event is failing when OIC is allowlisted from specific networkAnybody, could you please suggest how to allowlist fusion events in OIC? What is CIDR/IP Range of fusion instance and how to get it? Please share you insights. Anybody, …
-
Websocket APISummary: How to call the WebSocket API from OIC? Is there an adapter available for WebSocket API calls? We have a scenario where a third-party API built on WebSocket tha…
-
' value coming in mappingSummary: Hi While Assigning business unit value , i am getting extra character like "'" in it. How to handle this ? Content (please ensure you mask any confidential…
-
Callback from ERP Cloud stopped workingSummary: Hi Team, In our project FBDI call back from ERP SaaS Cloud stopped working post 24A upgrade. Anyone encountered similar issue and resolved? Callback from SaaS t…
-
Is it possible to call a web service or function created in ERP through a REST?Summary: We have a GET type API we can't call from OIC, so we'd like to know if it would be possible to call this API through a web service or server script in Fusion, a…
-
bulk data import not workingSummary: ATP Connector for Bulk Data Import Failing when Importing Integration Content (please ensure you mask any confidential information): Hello all, Has anyone run i…
-
Oracle CPQ Quote Creation API/IntegrationSummary: CPQ Quote creation Content (please ensure you mask any confidential information): Hi Team, we need an API to create/Update Quotes in Oracle CPQ. currently using…
-
Creating Connectivity Agent in OIC Gen3 ErrorSummary: we create Integration 3 instance, create confidential application add created integration instance as scope to The application ,under Allowed Grant Types we cho…
-
Validating and manipulating Received JSON data inside the integrationHello everyone, I created an Integration that receives a JSON file when triggered, and it then sends the mapped data to another endpoint through a new REST API request. …
-
Licensing fee question on Human Resource Specialist roleWe are implementing a few of Oracle fusion could Finance modules (GL, P2P, R2R, inventory and expense). There is a need to login to fusion and verify the employee conver…
-
Update null value to a table column not working with ATP connectionSummary: Hi Team I'm using ATP connection to update the column value to null, but passing null here is not updating existing value in the table column. How to update any…
-
Strange double quotes appearing in transferred txt fileSummary: SCENARIO: HCM Extract creates .txt files on webcenter (delimited with '~'). OIC picks these files up and transfers these to a DMZ server. The recipient is seein…
-
Is it possible to have dynamic routing in Oracle PCS (Process Cloud Service) workflowsSummary: Is it possible to have dynamic routing in Oracle PCS (Process Cloud Service) workflows ? We have a requirement to dynamically fetch the approvers and based on w…
-
OIC Question re: File PatternSummary: We often do a FTP list files command in OIC. This will look for an explicit file pattern (eg: *.csv). How do we set this up to allow *.csv and *.CSV (all caps)?…
-
How to get the UniqId to pass it as a parameter in OICHow to get this UniqId and pass it to the URI e.g., we need the gradeUniqId to pass it to the following endpoint: /hcmRestApi/resources/11.13.18.05/grades/{gradesUniqID}…
-
convert json body to text/plainSummary: How can we convert a json body to be returned as text/plain to map to an external webservice which accepts stream ref (text/plain)? Content (please ensure you m…
-
how to fetch specific stringSummary: Hi I want to fetch specific string from given string. Whatever value is present in "()" that need to be fetched. Industrial Minerals Company (IMC) ---> IMC Ma'd…
-
Create XML file signed with P12 PKCS #12 fileHi Gurus! I need to create a XML file with signature based on a P12 (PKCS #12), how can i reach that ?. Is there any configuration to upload this file and sign in OIC ? …
-
Populate Hyperlink in EDI file with OICHi, I have been trying to add a URL as hyperlink using href html tag into the EDI file via OIC mapper. Instead of a hyperlink it is coming as a string, not sure if the h…