Category 222
Discussion List
-
BIP reprot response payload truncated in OICSummary: oracle.cloud.connector.api.CloudInvocationException: ORABPEL-15236 Translation Failure.Failed to translate XML to JSON. Cannot write end element: ITEM_NUMBER Th… -
Reading first occurrence of the repeating element column from the JSON fileSummary: Hi Team, I am trying to read a JSON file ( sample content pasted below ) via OIC. My requirement - Pick the single/first occurrence of the repeating 'additional…
-
OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQLSummary: OIC > DB Adapter > SQL Issue > Passing Date Parameter > Validate SQL Content (required): Hello All, I am facing this issue in the screenshot when I use TO_DATE …
-
DB insert/merge from OIC DB adapter to MS SQL server failureSummary: I am doing a DB insert /Merge operation from OIC DB adapter to MS SQL server. I have passed all the columns but still getting below error. I have tried insert a…
-
Fusion REST API from integration with q parameter to check if date is nullSummary: Hi Experts I'm currently trying to fetch the work centers with below REST API and want to fetch the records where inactive date is null i.e. it shouldn't have n…
-
Calling OIC Integrations from SaaS BI PublisherSummary: Hi all, Please could someone elaborate about the steps to get "calling OIC Integrations from SaaS BI Publisher" , I have seen a comment in this forum and seems …
-
BIP report query community pageSummary: I have few queries on BIP report SQL query but not sure if there is any community page for the same. Please help me and share the community page for BIP report …
-
Oracle Integration3 instanceSummary: Is there any demo instance or a course in learn.oracle.com where we can get a OIC 3 instance for free? I do not have a credit card but i want to explore OIC gen…
-
VBCS invoking integration over REST protocol getting erroredSummary: I'm currently invoking integration over REST protocol from VBCS app, though the integration has to do lot of activities in a loop and it is getting automaticall…
-
OIC in bots4saas not availableSummary: Sorry if this is not the proper forum. Please can anyone provide info. about bots4saas instance. I cannot access OIC side, only VB. Thanks. Juan Content (requir…
-
Getting nxsd Schema errorSummary: Getting nxsd Schema error Content (required): Hi Expert, I am getting the following error while wrting the file Error in ReadFileScope - oracle.fabric.common.Fa…
-
Difference in rest api results count when fetched from OIC & postmanFacing a very strange issue. Calling the new hire atom feed api in OIC to fetch new hire data using rest adapter. Endpoint:- /hcmRestApi/atomservlet/employee/newhire Que…
-
Daily Outbound Mail notification limit exhausted in OICSummary: Dear Experts, Whenever daily outbound limit for email notifications has exhausted , we can see EMAIL SERVICE(USED 10000 of 10000) but is there any way to check …
-
Suggested contents of .gitignore for SOA Composite JDeveloper projectsHi community, What do you keep in your .gitignore when working with SOACS projects (or similar config for other source control systems)? I typically keep these entries i… -
Oracle Integration Update Webcast December 15th 2022Summary: Latest product announcements from Oracle CloudWorld and updates for Oracle Integration 3 including how, when and why to Upgrade. The product management team wil… -
Handle case in Integration when user not pass query parameterSummary: Hi, We have an issue when a user does not pass the query parameter in the REST URL then integration should through this error : valid rest URL : https://abc.com… -
OIC: Integration: OCI Streaming Adapter: Subscriber Error HandlingSummary: Content (required): How can we ensure guaranteed delivery in OCI streaming subscription Version (include the version you are using, if applicable): While subscr…
-
How to update checbox in custom application(made using app composer) in SaaS using REST API?Summary: Content (required): In the custom application, I need to update a checkbox value from 'N' to 'Y'. But my current API is supporting only POST operation but not p…
-
How to migrate decision model from UAT to PROD instanceSummary: Currently we already have decision model in PROD environment. We have done enhancements to few of the rules and want to migrate the decision model from UAT to P…
-
Oracle Integration Update Webcast December 15th 2022Summary: Latest product announcements from Oracle CloudWorld and updates for Oracle Integration 3 including how, when and why to Upgrade. The product management team wil…
-
Purchase Order Business Events not received in OICSummary: I have created a App Driven integration to listen to Purchase Order integration following the link After all the steps are followed I am not receiving the event…
-
Rest connection to Invoke ThirdpartySummary: Rest connection from to invoke a thridparty Content (required): Hi All, I am trying to invoke a thridparty using the rest API. Below is the curl command to get …
-
Checking the status of non FBDI ESS Jobs (parent and any child ESS Jobs spawned)Summary: We are long time oracle EBS customer and now we are starting our journey to cloud and we are using oracle OIC to automate some of the integrations we have. We k…
-
Possibility to change color/logo in oracle integration cloudSummary: Possibility to change color/logo in oracle integration cloud Content (required): Hey everybody, we are using two instances of OIC (one DEV and one PROD). Unfort… -
marking table column or any field based on form outcome in PCS to required is not workingSummary: I have created a on submit event to mark one of the field / column within the table as required based on the outcome of form if "APPROVE" then required else opt…
-
Get Base64 from REST API to Retrieve Attachment from a ProcessSummary: I am using following REST API to get the attachment and it works fine on postman. Content (required): I am not sure what or how should I configure the REST adap…
-
PCS - how to make attachment mandatory before approving a formSummary: Hi All I have a requirement to make attachment as required when user clicks on APPROVE button in PCS form. Please let me know how to achieve this as shown in sc…
-
REST API to get PCS task for any user by passing the name or email in query parameterSummary: Hi All I'm looking for REST API using which I can retrieve the list of all the tasks pending for action to be taken by user in Processes (PCS). I have used belo…
-
Any XSLT function to get the Last Day of a Month when the input parameter is sent as MON-YY?Summary: Any XSLT function to get the Last Day of a Month when the input parameter is sent as MON-YY? Content (required): We have a requirement to get the Last Day of a … -
Need sample payload for Create Invoice Attachment where attachments are already uploaded to UCMSummary: We are trying to attach an attachment to invoice from the OIC integration. Followed the below steps. Create an invoice with: /fscmRestApi/resources/11.13.18.05/…