-
Forums
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
DashboardB2C Service
Field Service
Marketing
-
Human Capital Management
Human Capital Management
DashboardTalent Management
HCM ANNOUNCEMENT: Deadline Approaching Responsive UX - Urgent Action Required! -
Enterprise Resource Planning
Enterprise Resource Planning
DashboardRisk Management
Project Management
Reporting and Analytics
Integrations, Extensions, and Security
-
Supply Chain Management
Supply Chain Management
Dashboard -
Reporting and Analytics
Reporting and Analytics
DashboardSolutions for Applications (OTBI)
- Reporting & Analytics for HCM
- Reporting & Analytics for Taleo Enterprise (TEE)
- Reporting & Analytics for Taleo Midsize (TBE)
- Reporting & Analytics for Taleo Learn
- Reporting & Analytics for ERP
- Reporting & Analytics for SCM
- Reporting & Analytics for Sales
- Reporting & Analytics for B2C Service
- OBIEE for Applications
Business Analytics
- Applications Security
-
More
More
-
Infrastructure (IaaS)
and Platform (PaaS)Infrastructure (IaaS) and Platform (PaaS)
DashboardContent and Experience
Business Analytics
Security
System Management
-
Partners
OPN Technical Assistance Forums for Partners
BUILD: Partner Technical Assistance
For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
SERVICE: Partner Technical Assistance
For partners that provide implementation or managed services around Oracle Cloud Applications
- Announcements
Forums
Use our discussion forums to pose questions, explore ideas, and discuss Oracle Applications. -
-
Ideas
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
My IdeasCustomer Experience
-
Human Capital Management
Human Capital Management
My Ideas -
Enterprise Resource Planning
Enterprise Resource Planning
My Ideas -
Supply Chain Management
Supply Chain Management
My Ideas -
Reporting and Analytics
Reporting and Analytics
My IdeasReporting and Analytics
-
More
More
My IdeasPublic Sector
Oracle Education
-
Platform (PaaS)
Platform (PaaS)
My Ideas
Ideas
Share your ideas on product enhancements, vote, and comment on your favorite ideas. -
-
Events
-
Events
Sales and Service
Human Capital Management
-
- Contribute
- Hall of Fame
- Learning
- Success
- Documentation
- Support
Comments
- posted December 1, 2019 in Integration > Integration
- Permalink
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.
- posted November 27, 2019 in Integration > Integration
- Permalink
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
- posted November 6, 2019 in Integration > Integration
- Permalink
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.
- posted November 5, 2019 in Integration > Integration
- Permalink
Hello,
You can user service catalog web service to find out web services available -
https://(FADomain,FSCMServices)/fscmService/ServiceCatalogService?WSDL
You can also use Developer Connect to find web service you are looking for. Login to your ERP Cloud - Tools --> Developer Connect. https://docs.oracle.com/en/cloud/saas/supply-chain-management/18c/oessc/Developer-Connect.htmlBelow url gives services for SCM (18c)- posted October 31, 2019 in Integration > Integration
- Permalink
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.
- posted October 31, 2019 in Integrations and Extensions
- Permalink
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).
- posted October 27, 2019 in Integration > Integration
- Permalink
Hello Digvijay, I was just going through oracle blog for feature flag and found oic.cloudadapter.adapters.mqjms feature flag available for MQ JMS connectivity. I have not tried it yet, but thought of sharing with you. Please refer - https://blogs.oracle.com/integration/enabling-the-future-today-feature-flags-in-oracle-integration-cloud Regards, Kanchan- posted October 23, 2019 in Integration > Integration
- Permalink
You can manually add variable in xsl for each loop only. But you will have to download iar locate xsl file and then edit it as mentioned above. You may not be able to add it directly in mapper UI. Maybe others can help you with how to do it on UI.- posted October 23, 2019 in Integration > Integration
- Permalink
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.
- posted October 22, 2019 in Integrations and Extensions
- Permalink
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>
- posted October 22, 2019 in Integration > Integration
- Permalink
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
}- posted October 22, 2019 in Integration > Integration
- Permalink
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.- posted October 22, 2019 in Integration > Integration
- Permalink
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 setThus 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.- posted October 22, 2019 in Integration > Integration
- Permalink
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.
- posted October 22, 2019 in Integration > Integration
- Permalink
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.