Schedule BIP report to FTP with output file name with date format dynamically

 Schedule BIP report to FTP with output file name with date format dynamically 

Required File name format :  Invoice_total_report_yyyymmdd_hhmmss.csv

Output file name :  Invoice_total_report_%y%m%d%H%M%S.csv

Under schedule >>Output>>Destination>FTP>> 

FTP Server: FTP Connection name given in BIP Admin>Delivery Channel>FTP

Remote Directory (Path):/Inbound/admin/InvoiceReport

Remote file name : Invoice_total_report_%y%m%d%H%M%S.csv

Integrate Salesforce and ERP Cloud

 Salesforce Integration                      Back to OIC

• In this integration, We will integrate Salesforce and ERP Cloud with Oracle Integration Cloud. 

• Use case - As soon as account is created in salesforce, it should also get created in ERP Cloud

• For this integration, you will need below accounts:

•  Salesforce - https://developer.salesforce.com/signup

•  Oracle ERP Cloud

Integration gets triggered as and when new customer is created in Salesforce.

Create FLOW in salesforce 
    

Create SFDC Account using https://developer.salesforce.com/signup

Login to http://login.salesforce.com?lt=de using SFDC logins -created in previous step
1)Create Flow 
  Navigation to create Flow
   Home >>Process Automation>>Flow>New Flow 

   Record Triggered Flow --When a record is created or updated .

   Triggering point :"when ever record is created ,updated or deleted "

   Object : Account

   Configure Trigger : A record is created or updated 

   Set entry conditions :like only account no starts with 500

   Save the Flow with Flow name and API name 

2)Create Action of type Outbound Message under workflow actions

  Create Outbound message 

  Business Object:Account 

  End point URL :as New integration to be created in next step in OIC 

  Account fields to send :Move attributes from avilable to required fields 

  select all attributed from salesforce to be needed in Cloud ERP to create         customer account 

 Save Outbound Message --It will generate Abstract WSDL file --Save it 

3) Create Connection in OIC   View 

Salesforce Connection

 Salesforce Connection Configuration                        Back to OIC

Basic details

Name

Salesforce

Display name

Salesforce

Version

23.4.1

Integration role

Trigger and Invoke

Description

Integrates Salesforce.com CRM with your Enterprise Resource Planning, Marketing, Human Capital Management, Financial System, Social, SaaS and on-premises applications.

Security details

Default policies

Custom Security Policy

Supported policies

Custom Security Policy, Authorization Code Credentials, Resource Owner Password Credentials

Documentation

https://www.oracle.com/pls/topic/lookup?ctx=appint&id=ICSSF-GUID-6054F924-9BC5-4875-BCE7-BD77EF347241

Release notes

The Oracle Cloud Adapter for Salesforce.com enables customers to easily integrate their on-premises or SaaS applications with Salesforce.com application without having to know about the specific details involved in the integration.

Steps to create Connection in OIC using Salesforce adaptor
Login to OIC >Project>Connection>Create
Connection created with below error "You must add a security token to your password to login. To get your new security token log into salesforce from your personal settings ,enter reset my security token in quick find box , then select reset my security token ."

Login to salesforce with your user account >>User profile >>Settings >>My Personal Information>>Reset My Security Token .

A new security token sent to the email address for your account,

salesforce account user password + new security token sent to the email address

Devi@125 +   U3ItX5EqDP5XlXkd23b6gmLhD= Devi@125U3ItX5EqDP5XlXkd23b6gmLhD

Copy the new password >> salesforce account user password + new security token sent to the email addressPaste it in OIC SFDC Connection password field.Save and test the connection as shown in below pic 

Navigate Back to Integration