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.
Integration
Discussion List
-
SOAP ResponseSummary: in OIC sending the request to SOAP adapter and getting the response . as you can see in attached code , the ImportResult is the string in XML format,and i need … -
Send human approve task of Process automation App to Assignees emailSummary: how could sent human approve task in Process automation app start with message event to Assignees email,where they could take actions Content (required): Versio…
-
Restricting OAuth Client Credentials to specific IntegrationsSummary Create two scopes for two integrations and give access to two different clients such that the first client can access only scope A and the second client can only… -
how to read OAuth scope in OIC trigger REST APISummary: Hi, We have a requirement to access OIC REST API endpoints using OAuth flow by 3rd party clients. The use case is we want to create custom scopes for each clien…
-
Oracle Fusion Financials rest api - Fetch AP invoices with status selected for paymentHi, I need to fetch the AP invoices who's status changed to 'selected for payment'. By default, "/fscmRestApi/resources/11.13.18.05/invoices" does not return the 'select…
-
findorganization - How to fetch Active Phones alone from an OrganizationSummary: How to fetch the Active phones alone (status = A) from findorganization service ? Content (required): Hi , I am trying to use (FoundationPartiesOrganizationServ…
-
[OIC] Connect to Nirvana JMS queue (JMS context “com.pcbsys.nirvana.nSpace.NirvanaContextFactory”)Summary: Hello All, In OIC (Oracle Integration gen. 3), is it possible to connect directly to a Nirvana JMS queue (JMS context “com.pcbsys.nirvana.nSpace.NirvanaContextF…
-
Permanently delete from trashHi, Once the VBCS application is moved to trash how can this be permanently deleted. Thanks -
Read text in file with special characters (Finland) and store in db does not work for me.Summary: Hi, I would thank for help with the following. I am importing a text file into db. but special characters are not ok. Example: I have this in the file: and I ha…
-
Read text file and store in db respecting the orderSummary: Hi, please I would like your help with the following: I receive a file with this pattern: line to remove line to remove line to remove **** **** **** line to …
-
Is it possible to manipulate the "response-wrapper" as a JSON-like parameter?Hi, I am currently developing a JavaScript function that involves integrating two APIs using Oracle Integration Cloud (OIC). In this process, I retrieve two JSON objects…
-
OCI integration with OCI QueuesSummary: Hi All, There is an integration which is publishing messages to OCI queue. Integration is working for small payloads. But when we tried with huge payloads integ…
-
Oracle OIC integration pods integrations grouping criteria - Best PracticesSummary: I would like to know if anyone has a followed a defined criteria in your organization in placing the different integrations across multiple OIC pods? Content (r…
-
Oracle Integration Cloud File Server use authenticationContent Hi Experts, I have enabled a File server on the OIC instance and configured & enabled a user from the user's menu under File Server. I have selected the Password… -
OIC Gen3 - Calling Oracle REST API and getting 400 Bad Request ErrorSummary: We are getting the following error: 400 Bad Request While invoking the OIC Gen3 REST API - Run a Scheduled Integration Now (POST) We have sent the Content-Type … -
salesOrdersForOrderHub API - Unable to add linesSummary: salesOrdersForOrderHub API - POST- adding order lines returns "SourceTransactionSystem and SourceTransactionId are mandatory when creating a new order" Content … -
Error invoking Local integration in OICSummary: We have a critical integration related to invoices and billing and it calls multiple sub process. So the parent main process failed as it received error invokin…
-
OIC Gen3 > Stage File Action ‘Read File in Segments’ > For Each Loop > Activity StreamSummary: OIC Gen3 > Stage File Action ‘Read File in Segments’ > For Each Loop > Activity Stream Content (required): Hello All, I am using a For Each Loop within a Stage …
-
DB Adapter reflects new columnSummary DB Adapter DOES Not reflects new columnContent When we add a new column in table, in OIC we have to delete the whole mapper which comes along with the adapter. I…
-
Do we have Bold characters in MICR MT font and is there any possibility to make a micr font as bold?Summary: Could not make a micr font bold while generating the output Content (required): Version (include the version you are using, if applicable): Code Snippet (add an… -
Is there a way to add a new line above header csvSummary: I am trying to use a write file action in an integration that I have developed, and I feel like I have hit a limitation. Content (required): The recipient of th… -
Attachment of log file of ESS job request not coming correctly in email notificationSummary: Hi I ran ESS job "Generate Receipt Advice" for single PO in OIC and looking for same log file in email attachment. i am getting email attachment but it is of 1k…
-
Having problem creating connection to HCM Cloud Adapter from oracle IntegrationSummary: We have Oracle OCI tenancy and Oracle HCM Cloud. We want to develop some integration. When we tried to create a connection using HCM Cloud Adapter and entered t…
-
OIC translation error : HTTP 502Summary: OIC endpoint throws HTTP 502 error while parsing an error message in a scope fault Content (required): We have an OIC interface that invokes an external REST en…
-
Working with timezones in OICSummary Working with timezones in OICContent From the integration source, I receive two data: 1) A "datetime" in YYYYMMDDHHMISS format and a timezone (like "America/Los_…
-
TZ_OFFSET equivalent in xslt?Summary: is there an xslt function equivalent to the sql function TZ_OFFSET Content (required): I'm extremely new to OIC and xsl...I need to find a way to get the timezo…
-
Fusion Cloud Sales Order Holds API not Working as expected.Summary: Fusion Cloud Sales Order Holds API not Working as expected. POST: https://XXXX.us6.oraclecloud.com/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub/acti…
-
Can OIC consume BLOB or CLOBSummary DB Adapter is invoking a PL/Sql Procedure which is returning CLOB/BLOB as out parameter, Can we consume the same in OIC.Content DB Adapter is invoking a PL/Sql P…
-
best approach to insert into multiple tables from OICSummary: Looking for the best way to proceed to bring in data with many collections of data within it Content (required): Hi. I am extremely new to OIC and just stumbled…
-
Pub/Sub with different OIC environments and versionSummary: Hi Folks I think I know the answer (no) but always good to check here Is it possible in Gen3 to setup pub/sub (event handling) between two different OIC instanc…