Mapping
Discussion List
-
Attachment service 'ErpObjectAttachmentService' attaching Invoice PDF Twice in OICSummary Attachment service attaching the InvoiceImage Twice using OIC for few invoicesContent Hi All, We are using the 'ErpObjectAttachmentService' service to upload the…User_2025-02-05-23-21-30-409 72 views 0 comments 0 points Most recent by User_2025-02-05-23-21-30-409 Integration -
Get child text from an xml element in a mappingContent Implementing the suggestion in this topic - Include mapped output as the value of another output..., I need to get the text content of an XML node returned from …User_2025-01-31-16-07-50-568 43 views 9 comments 0 points Most recent by User_2025-01-31-16-07-50-568 Integration
-
Date Conversion errorSummary Getting type/cast error when calculating Date 30 days before.Content Hi - trying to get date 30 days before but getting error FORG0001: invalid value for cast/co… -
DateTime Issues : DD-MON-RRRRContent Hi All, My requirement is to format the input date and subtract one day from the given date. The requirement sounds simple but the date is not getting formatted.…
-
Convert comma-delimited String to XML NodeContent Hi, I am trying to convert an input variable which contains comma-delimited string values into an XML nodeset using oraext:create-nodeset-from-delimited-string a…
-
OIC - handling nested Json array is failing when internal array is emptySummary OIC - handling nested Json array is failing when internal array is emptyContent Hi, I have a service provider response that should be mapped as-is to the OIC int…Noam Tamarkin-Oracle 439 views 3 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
How to convert/transform a simple csv file into FBDI template with master-detail data?Summary How to convert/transform a simple csv file into FBDI template with master-detail data?Content Hi Everyone, I'm using FBDI template for Account Receivables - Auto…Karthick Rajarathinam 58 views 2 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Integration
-
FTP Adapter - Master Detail CSV File - Unable to IDENTIFY master detail informationSummary FTP Adapter - Master Detail CSV File - Unable to IDENTIFY master detail informationContent Hi Everyone, Scenario- CSV placed in FTP location in the below format.…
-
Write JSON File to FTP in ICSSummary Write JSON Response from HCM to FTP Json FileContent Hi I have a scenario where I am receiving JSON payload from HCM rest api. I need to transform and write a JS…
-
Fixed Length to CSV conversionSummary File ConversionContent Hi Team, I am trying to convert Fixed length file to CSV The issue i am facing is: Some of the data lines in the fixed length file don't h…User_2025-02-04-21-30-51-376 29 views 11 comments 0 points Most recent by User_2025-02-04-21-30-51-376 Integration
-
OIC Email Notification - Dynamic HTML tableSummary How to send email notification with dynamic HTML table. The number of rows in table will vary.Content I have a requirement where i need to send email notificatio…
-
What's the difference of "For Each" action and adding for-each during mappingContent Hi experts, In integration we are reading one file which has multiple lines, after that we want to call a DB procedure for each line(line value as input paramete…
-
Order by array variableSummary Order by array variableContent Hello, We have a webservice that returns an array for us with two dimensions “Name and Sequence”. I need to sort this array by the…
-
Are business event available to capture customer account creation/update?Summary Are business event available to capture customer account creation/update?Content Hi Everyone, I'm looking for a business event that triggers when a (Trading Comm…
-
User Type SettingsSummary User Type SettingsContent Good Morning, Someone with this problem or some guidance please. In the types of users, I made a copy of an administrator profile (see …Erlin Garcia-132843 33 views 1 comment 0 points Most recent by User_2025-02-03-21-22-33-570 Field Service -
Multiple line within a single mapping elementContent I have used the below wsdl to generate scheduled report from fusion; WSDL: http://:/xmlpserver/services/v2/ScheduleService?wsdl The request mapper for the above …User_2025-02-04-21-30-51-376 29 views 13 comments 1 point Most recent by User_2025-02-04-21-30-51-376 Integration
-
How to load overtime information into Oracle HCM?Summary How to load overtime information into Oracle HCM?Content Hi Everyone, I have a requirement to load overtime information of an employee from a 3rd party system to…
-
How to run a integration by clicking a single url/linkContent Requirement: I want to send the url of integration in a mail notification. On click of that url, the integration should be triggered in OIC. I initially used the…
-
Array variable OIC (ICS)Summary Array variable OIC (ICS)Content Hello, We have a "foreach integration" and I would like to create an array variable with the result of that integration. After th…
-
2Ability to define any attribute from integration as business identifier for trackingOrganization Name Infosys LimitedDescription In the Integration cloud service, while creating the interfaces, Oracle allows to use upto 3 fields as business identifiers …Sachin Suresh Deshpande -- Infosys 6 views 0 comments 2 points Most recent by Sachin Suresh Deshpande -- Infosys Idea Lab – Integration Cloud -
3Need Webservice or REST API to derive country and currency code from city or stateOrganization Name Globaltranz Enterprises, Inc.Description I am doing the integration of Supplier from Third party to Oracle ERP Cloud, I am getting City and State Infor…User_2025-02-01-03-13-08-161 15 views 1 comment 3 points Most recent by User_C1E0A Idea Lab – Integration Cloud
-
Subtraction functionContent Hi, Requirement: I want to subtract two value from various response and show in the final response. Problem: One value coming as string, so I tried to convert as… -
I made a get call-in REST adapter. I am providing XML SCHEMA (XSD) as response payload format. butSummary I made a get call-in REST adapter. I am providing XML SCHEMA (XSD) as response payload format. but Live payload is JSON.Content HI, I made a get call-in REST ada…LoguPrasanth-LP 35 views 6 comments 0 points Most recent by User_2025-02-04-10-48-20-265 Integration
-
7Assignment Variable - Data typeDescription We can able to create String data type only in Assign variables. If the result is other type, we have to explicitly use Conversion function to convert it. It…Mohana Gopal S-Oracle 3 views 0 comments 7 points Most recent by Mohana Gopal S-Oracle Idea Lab – Integration Cloud
-
Handling Null value in the mappingContent Hi, In my integration, I got the Null value as response in one of my source as shown below. I used this field in my mapper to map to target. { "x_total_deposit":…Mohana Gopal S-Oracle 1.9K views 12 comments 1 point Most recent by Mohana Gopal S-Oracle Integration
-
6Handling Null value in the mappingDescription If we pass null value to target system we got the below translation error. We need OOB function to handle this. { "type" : "10.5.3", "title" : "exception occ…Mohana Gopal S-Oracle 19 views 1 comment 6 points Most recent by User_2025-02-04-10-48-20-265 Idea Lab – Integration Cloud
-
OIC add millisecond to dateTimeSummary Add a millisecond to a given dateTime Value in OICContent I have an Integration where I need to add a millisecond to a given dateTime Value. For example: I get t…
-
How to send HTTPS 200 response Immediately to When Client make POST call? in App driven OrchestratioSummary We are using APP DRIVEN ORCHESTRATION to Create a Purchase orderContent My Workflow Step 1 - Client post the metadata to OIC Endpoint. Step 2 - In the same flow,…
-
LookupContent Hi, We have requirement like, based on the input parameter value, we have to pass different value to 5 columns. If the BU = Sales then Owner = Sales Admin, Proce…Mohana Gopal S-Oracle 34 views 10 comments 2 points Most recent by Mohana Gopal S-Oracle Integration
-
Using Newer version of PCS application in OICContent Hi All, I could see that when we try to use a newer version of PCS application in OIC the mapping seems to be deleted automatically. Is there any work around ava…User_2025-02-04-15-03-25-028 15 views 5 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration