For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Earlier in ICS, you could run replicate on-premise behaviour by using Execution Agent. However, there is no support for Execution agents yet in OIC.
Can you please attach nxsd generated for writing this file? We might have something there.If you look at file it has written an empty record in first line. Also column A is not empty it is just has lot of spaces before. Please open csv in text editor
OIC allows you to schedule an integration with an interval of 1 minute.
you can try something like FREQ=MINUTELY;INTERVAL=5; this Should schedule integration every 5 minutes.
Thank you.
Hello,
You can user service catalog web service to find out web services available -
https://(FADomain,FSCMServices)/fscmService/ServiceCatalogService?WSDL
Agent is required only for applications which are behind firewall and not accessible over internet. however, since your SalesForce and ServiceNow are on Cloud(assuming public cloud). You would not require agent for the same.
You can use BICC/BIP/OTBI reporting to extract data from cloud and then use another ODICS to replicate data with your on-premise DWH.
https://blogs.oracle.com/dataintegration/data-integration-platform-cloud-for-saas-applications
https://www.ateam-oracle.com/bi-cloud-connector-download-data-extraction-files
There is also a license for IACS (Integration Access Cloud Service) and with option of using Golden Gate with SaaS Approval. Please note these maybe separate license. There was a session in OWW18 on the option - Please refer to archive @ https://static.rainfocus.com/oracle/oow18/sess/1524507438679001h3mP/PF/OOW18_PRO4557_DIPCSaaS_NRAO_15405078465010019BR4.pdf (For IACS refer page 21).
Can you please edit xslt outside OIC to put the value in one variable and then use it in access specifier.
Something like
<xsl:variable name="soureId" select="../nsmpr2:SourceTransactionLineIdentifier"/>
And then use $ReadFileFlete/nsmpr9:ReadResponse/nsmpr13:DATA_DS/nsmpr13:G_1[nsmpr13:SOURCE_LINE_ID = $sourceId ]/ nsmpr13:VALOR_FLETE
Then import this edited xslt in mapper. It should work.
In Order to update existing EFF - you will also have to pass EffLineId In your response you can find EffLineId (of findItem and in this case your response xml), please pass this EffLineId in Request and it should work.
<ns7:EffLineId>300000010934653</ns7:EffLineId>
Can you please the JSON once again - problem is
"WorkOrderSubTypeCode": "ORA_EMERGENCY" "," is missing here. Please try below one.
{
"WorkOrderNumber": "MSIMDDXB2",
"WorkOrderTypeCode": "CORRECTIVE",
"WorkOrderSubTypeCode": "ORA_EMERGENCY",
"WorkOrderDescription": null,
"OrganizationCode": null,
"OrganizationId": 300000002812765
}
You might have to find a work-around for the issue something like - Create an integration which has all the logic. Create another integration which is scheduled to run Monthly from 28th till 31st.
And then decide in this integration whether it is last working day of quarter or not, if it is then invoke previous integration. Please see if this is possible.
Hello Punit,
From your post, you are trying to schedule the request on every last working day of the quarter.
FREQ=MONTHLY;BYMONTH=3,6,9,12;BYDAY=MO,TU,WE,TH,FR;BYMONTHDAY=24,25,26,27,28,29,30,31;BYSETPOS=-1
The rule is evaluated as follows:
FREQ=MONTHLY;
BYMONTH=3,6,9,12 : expand to 3rd, 6th 9th and 12th Month each year.
BYMONTHDAY=24,25,26,27,28,29,30,31: expand to the 24th till 31st day of each month
BYDAY=MO,TU,WE,TH,FR: filter by week day, retain only work days/remove weekend days
BYSETPOS=-1: retain only the last record of the set
Thus you will have last working day of every Quarter.
You can test this iCal expression @ http://recurrence-expansion-service.appspot.com/
However, I am don't think, OIC supports "BYSETPOS" yet. You can try raising SR to confirmation regarding the same.
Can you please check if you can invoke the url mentioned in attachments from POSTMAN or SOAPUI as REST Service. Some of these URLs are actually a rest services endpoints which you can just pass some parameters and download it. In case you are able to invoke the endpoint from POSTMAN / SOAPUI. You can create an REST connection to this service. The output can be taken as attachment and you can pass the file reference in you next service to upload it in another service.
could not create pool connection for datasource 'ErpSaaSExtnNonXA'. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection. You may need to configure the connection settings in the deployment descriptor (i.e. DbAdapter.rar#META-INF/weblogic-ra.xml) and restart the server.
This error is communication error between WebLogic and DB Instance. I would check below :
We may get clue from diagnostic logs. Please check those.
1. Connectivity with port between using telnet from all machines where weblogic is installed.
2. Check if you are able to create a new datasource and test it successfully or not. Please check connection url whether it uses ":" or "/" (service name vs id) and correct if necessary . And then correct it across database connections.
3. Please check if Plan.xml is copied on every node in clustered.
Once all above things are done. Please restart all nodes and test connectivity. Hope one of the above step helps in resolving issue.
Thank you.