Sunday, August 1, 2021

Oracle Integration Cloud Service(OICS) links

Please find the following links for OIC hands on and relevant information:

  1. Oracle Integration Cloud Introduction | Benefits | Services offered | Aspects or components of Integrations | Use cases | Integration Styles | Mapper | Integration workflow
  2. Create connections:
    1. Create a DB connection
    2. SOAP Trigger type connection creation
    3. OIC Create Trigger Type REST Connection
  3. Create different basic integrations:
    1. OIC Rest Trigger to DB invoke data fetch Integration using basic routing | Use of Basic Routing Pattern
    2. Publish to OIC and Subscribe to OIC
    3. Enrichment in basic routing integration
    4. Integration using App Driven Orchestration Integration Style | SOAP to DB Insert
    5. Scheduled Orchestration part 2 | FTP to FTP file transfer in Oracle Integration
    6. Scheduled Orchestration | FTP to Database Integration
    7. Integration using File Transfer StyleScheduled Orchestration part 2 | download zip file , list files and write them to a remote directory using FTP
  4. How to do tracking an Instance
  5. Use of Lookup | Create a Lookup and use in an Oracle Cloud Integrations
  6. Exception Handling related:
    1. Exception Handling | Scope level error handler | Global fault handler
    2. Scope level error handling
    3. Global Fault handling in app driven orchestration
    4. OIC - How to handle errors for outbound flow respect to Oracle ERP
    5. OIC - Fault return action - custom HTTP error response in rest flow
    6. OIC - Fault return - send custom fault to a modeled soap trigger.
    7. OIC - out of the box - error handling in easy steps.
    8. OIC - fault handling in details
    9. OIC - different ways of throwing faults | defferent fault throwing mechanisms
  7. Connectivity agent related:
    1. OIC - About Connectivity Agents | Connectivity Agent Architecture
    2. Connectivity Agent part 2 | Connectivity agent install in Linux system
    3. OIC - Install Connectivity agent in windows system.
    4. OIC - File poll as trigger type using Connectivity agent | Oracle Integration Cloud
  8. Custom Javascript related:
    1. OIC - Use of Javascript in oracle integration | use javascript to add two numbers to fixed number of decimal points
    2. Javascript - to remove carriage return
    3. Javascript - Return boolean status based on ERP result status
    4. OIC - Javascript - Replace String
    5. OIC- Javascript - return count of string using Regular expression
    6. OIC - Javascript - find name and value parameters from a string
    7. OIC - NVL in javascript
    8. OIC JS - return last day
    9. OIC JS - return today's date in yyyymmdd format
    10. OIC Generate Random number using custom function
  9. Synchronous Integrations Occasionally Fail with a 504 Gateway Time-out Erro
  10. Use of Translate function in Oracle Integration
  11. OIC to ERP Import and ESS Job Related:
    1. OIC - ERP - Import AP Invoice to cloud ERP using FBDI detailed implementation steps.
    2. OIC - ERP - Detailed implementation steps to import transactions to ERP Fusion accounting hub or ERP FAH sub ledger accounting
    3. OIC to ERP FBDI imports different technique:
      1. OIC - Import to ERP Technique 1 - Import Payables Invoices using import bulk data into Oracle ERP Cloud option | Enable Callback | Subscribe Callback
      2. OIC to ERP Import Technique 2 - importBulkData using ErpIntegrationService and Oracle Erp Cloud Adpapter
      3. OIC - ERP Import Technique 3 - Multi steps
    4. ERP - Import AP Invoice using FBDI files from ERP scheduled Processes
    5. OIC ERP supplier import and receive callback
    6. Sample supplier callback payload from oracle integration
    7. OIC ERP - How to download Oracle FBDI template | Generate CSV files from the template file
    8. OiC understand of fbdi properties-file
    9. OIC - ERP - How to get Job Package and Name
    10. OIC - ERP - How to get the Job parameters for bulk import job
    11. ERP - Register the CSF key | Subscribe to Oracle Fusion Cloud | Subscribe to Fusion Business events and FBDI Callback
    12. OIC ERP - How to download Import Payables Invoices Report using ERP Cloud adapter from Oracle Integration
    13. OIC - Import PGP private and public keys in the setting certificates
    14. OIC - ERP Payable invoice callback - Custom report
    15. OIC ERP - Get Source Name for invoice callback | fixed asset etc.
    16. OIC ERP - BI report SQL query for invoice custom report
    17. OIC- How can OIC integration subscribe to business events raised with Oracle ERP cloud
    18. OIC - ERP - how to get child process id from import request id using otbi report
    19. ERP BI SQL query for custom import response or callback
    20. OIC To ERP - Design steps for Import and Custom callback | Oracle Integration Cloud
    21. OIC - ERP - custom callback BI report | What we can do after the FBDI import
    22. OIC to ERP : Move custom report | download custom report based on ess job id and then move to desired folder
    23. OIC - Custom callback from erp | How we can leverage a custom callback using BIP report feature
    24. Sample erp job details account name parameters
    25. how to show the import response id to the activity stream for better support
    26. ESS Job related:
      1. get ESS JOB Status of a ESS import job
      2. OIC - get ESS job status of the child process of the import job
      3. Oracle Fusion ess job definition tables | ERP ESS job Schedule processes tables
      4. OIC - Submit the ESS job and get status of the ESS job from Oracle Integration
      5. OIC - ERP - Monitor Progress of ESS job and return status | Reusable component to monitor the ESS job run status
      6. OIC - ERP - Download ESS job execution output and log using Erpintegrationservice in Oracle Integration
      7. ESS job run for delta calculation
  12. OIC ERP Outbound Integrations related:
    1. OIC - ERP - create an integration to send outbound ERP File using BI bursting FTP delivery channel and ESS job | How to create an erp Outbound flow in Oracle Integration
    2. OIC ERP - submit ess job - sending multiple parameters | call BI Bursting - sending two reports| FTP delivery channel Usecase:
  13. How to handle more than 10 mb file or large file poll
  14. File adapter vs FTP adapter
  15. OIC - Process large file (above 10MB)
  16. OIC - Fetch name and value params from a input string
  17. Target REST endpoint response payload processing failed.[Content received of length XXX bytes exceeds the maximum allowed threshold of 10485760 bytes
  18. OIC - send Notification - email, log file and create incident
  19. Global variable and Data Stitch action
  20. Replace existing connection with the new connection in OIC integration
  21. OIC - Integration properties
  22. OIC - dynamic email send with html table content
  23. Configre rest trigger to get CSV file
  24. Common Integration Pattern Pitfalls and Design Best Practices
  25. OIC - Integration Metadata Access
  26. log file naming convention
  27. Schedule parameters to get last run Date and Time
  28. Why to avoid creating too many scheduled integrations
  29. Convert a Scheduled Integration to a REST Adapter-Triggered Orchestration Integration
  30. OIC - Run a schedule integration now using rest api
  31. OIC - Opaque schema for creating base64Binary file
  32. OIC - substring a string using index-within-string() function.
  33. SFTP operations - Move and delete
  34. OIC - callback action
  35. OIC - Resolved - Stage read file in segements - XML-22031 : Error variable not defined.
  36. OIC - 1z0-1042-21- topics to be covered for certification
  37. OIC Schedule Integration schedule types:
    1. OIC - How to schedule OIC integrations using simple type
    2. OIC - How to schedule an integration using iCal expression
    3. OIC - ical expression to run each month on specific day and time
  38. OIC - How to modify an existing schedule.
  39. OIC - Oracle Feature Flasg overview
  40. OIC - convert string yymmdd to date yyyy-mm-dd using substring() function
  41. OIC- change date time format using xp20:format-dateTime() function
  42. OIC - Migrations | how to migrate integrations in oic
  43. OIC - how to include existing integration to a package
  44. Encrypt and Decrypt and PGP key related:
    1. Create PGP key to use in FTP connection
    2. OIC - Create FTP connection with PGP
    3. OIC - Encrypt and Decrypt using FTP PGP connection and write operation
    4. OIC - decrypt file using download FTP operation and read reference with Stage
    5. OIC - using Stage file action to encrypt and decrypt files
    6. pgp tool to encrypt or decrypt the file
  45. OIC - why to reactivate integration after connection details get changed
  46. OIC - add header or line file field names with easy technique
  47. OIC - about virtual file system | VFS
  48. OIC - how to modify xslt for complex logic using Jdeveloper IDE
  49. OIC - validate date format as mm-dd-yyyy
  50. OIC - convert json to string
  51. OIC - how to create rest ics connection
  52. OIC - How to update lookup from a csv file
  53. OIC - send binary object as rest response
  54. OIC - search data from a csv file
  55. OIC - about business identifiers
  56. OIC - secure rest api with oauth security policy
  57. OIC - Merge two different schema files into a single csv file
  58. OIC - Retry logic in detailed steps with a scenario
  59. OIC How to create a fixed lemgth file using fixed length schema
  60. OIC - How to group data using for each group XSLT 2.0.html
  61. OIC - Read Json data received as json string
  62. OIC - Convert String XML to XML using parseXML() | Use of ParseXML() function
  63. OIC - Invoke a rest service whose request and response payloads as XML | Invoke Rest API with XML payloads
  64. OIC - Post XML payload with Rest API | Rest API with XML Request Response
  65. OIC - Managing Multiple Operations in OIC SOAP Adapter
  66. ERP BI sql query to fetch output based on ESS REQUEST HISTORY Table last run date | Fetch Processstart from ESS_Request_History table
  67. OIC ERP BI publisher call Retry logic Usecase 2
  68. OIC Techniques - Decode base64 encoded BI publisher report | Call an Oracle Fusion Applications Business Intelligence Publisher Report Synchronously
  69. OIC - How to read file size up to 1 GB in oracle integration
  70. OIC | Embedded file server in Oracle integration | using file server in oracle integration generation 2
  71. OIC | Oracle Cloud Integrarions | Restrictions using Oracle Integearion Generation 2
  72. OIC | Oracle Integrations Editions | Standard vs Enterprise features
  73. OIC Service limits | Generation 2 Resources limitation
  74. OIC Gen 1 vs Gen 2 | Benefits of OIC Generation 2
  75. OIC Retention period | Impact of increasing the retention period | Standard and Warning settings
  76. Cloud ERP | How to create an OTBI report | create BI publisher report
  77. OIC | Add Package Name for an Integration
  78. OIC | Package Migration | Multiple Integration Migration
  79. OIC | Migration of integration from one environment to another | Single integration Migration | Multiple Integration Migration
  80. OIC - Prerequisites for creating Oracld ERP Cloud Connection
  81. OIC Rest path parameters vs Query Parameters
  82. OIC | Convert UTC Date and Time to another timezone in Oracle integration cloud servic
  83. OIC to Database related:
    1. OIC - DB Procedure call | DB adapter 10 MB limit overcoming solution | Offset Fetch
    2. OIC - Call DB package insert operation | one to one database insert using Package
    3. OIC - unable to convert string in xml to date format while inserting into database
    4. OIC - Database package call to insert Varray size of data | DB package insert in oracle integration
    5. OIC Oracle Database polling | Oracle Integration cloud DB Polling
    6. OIC - Difference between Oracle Database, DBaaS adapter and ATP adapter
    7. OIC - How to access Database sequence value in Oracle Integration
    8. OIC - How to use DB sequence while do insert or merge to database table in Oracle Integration
    9. OIC - Save Integration request payload XML or JSON into database table
    10. OIC - Create a resuable component or integration to pass the request payload any format and save to database table as clob type.
    11. OIC - DB polling and logical delete from oracle database in Oracle Integration
    12. OIC - PLSQL - Feed comma separated field values as input and fetch table of records as output using Stored procedure
    13. OIC - PLSQL - Feed table of record types and fetch table of records details using stored procedure
    14. OIC - How to call db procedure asynchronously from oracle integration
  84. OIC | Merge two CSV files into one CSV file based on a common field or primary key
  85. Oracle Integration Cloud | Merge two CSV files into a single file without any primary key or common field
  86. OIC | Split a CSV file into multiple CSV files based on a column distinct values in Oracle integration cloud
  87. OIC Certificate Management | Different type of Certificates in Oracle Integration Cloud
  88. OIC - Export an Integration using REST API | Rest API for Oracle Integration export
  89. OIC - Limitation of using staging area
  90. OIC - ERP - Debugging of Business Events subscription for outbound integration
  91. OIC - Import an OIC integration using REST API | How to use Multipart/form-data in Rest adaptet
  92. Encode Base64 function strips off XML Tags in the payload | Oracle Integration cloud
  93. OIC - Create a header file based on sequential unique lines Transaction number | Oracle Integration cloud
  94. OIC Tracing | How to enable and use OIC Tracing | Oracle Integration Cloud
  95. OIC to OCI resources:
    1. OIC to Object storage related:
      1. OIC How to use OCI Object storage from the Oracle Integration Cloud | Put a file to OCI Object storage from Oracle Integration Cloud
      2. OIC - Get object from OCI object storage using OIC | Oracle Integration Cloud
    2. Function:
      1. OIC - How to invoke OCI oracle function from Oracle Integration Cloud
    3. API gateway:
      1. OIC - Create an API gateway in OCI and route to REST Oracle Integrations | OCI API Gateway
  96. OIC - Create a Retry logic to overcome putting file to S3 using rest time out issue
  97. OIC - Use REST adapter with multiple resources or Multiple Verbs in Oracle Integration Cloud
  98. OIC - Twilio adapter - send SMS / WhatsApp from Oracle Integration
  99. OIC - ERP - Supplier import failed due to Supplier type is inactive or invalid
  100. OIC - Design time audit logs | How to monitor design time audit logs
  101. BI report related:
    1. How to create BI report in Oracle ERP
    2. OIC - Invoke ERP BI report | Create ExternalReportWSSService wsdl connection in oracle integration
    3. OIC - ERP - xsl template to create control file BI report
    4. OIC - ERP - BI report bursting using email delivery channel.
    5. OIC - invoke BI control report and store in s3 bucket using rest connection.
    6. OIC - ERP how to test sql query in BIP data model
    7. ERP - BI Report using ETEXT template
    8. RTF template related:
      1. ERP - BI publisher installation and Enable add Ins the word | RTF Template
      2. ERP - BI report using RTF template
      3. Create RTF tamplate on MSword based on exported data model xml
      4. How to create RTF template on msword with more details
    9. Create eText template based BI report
      1. ERP - Create EText EFT template based BI report | Create etext fixed position based BI Report
      2. ERP - Create EDI template based BI report | Create Delimiter based report
    10. ERP - BI report XML output using XSL template
    11. ERP - Create a BI report text output using XSL template
    12. OIC ERP BI Bursting using FTP delivery channel
    13. OIC ERP About BI Bursting
    14. OIC Invoke BI Publisher report with Name value parameters
    15. OIC | How to call and read BI publisher report in OIC Integration
    16. ERP - BI report using Excel template
    17. OIC - Schedule BI Publisher Report through OIC | Oracle Integration cloud | Schedule report service
  102. OIC - Convert CSV file data to JSON | Oracle Integration
  103. OIC - How to continue FOR EACH loop for any failure case | Oracle Integration
  104. OIC - Read Multiple records are of different types CSV file in Oracle Integration | Create Multiple records are of different types XSD file to read CSV file
  105. OIC - Read multiple records are of different types CSV file in Oracle Integration whete 1st column does not have default values
  106. OIC - Upload attachment file in Rest API in oracle integration
  107. OIC - Upload multiple attachment files in REST API in oracle Integration
  108. OIC - how to call "upload attachement as in REST Integration" from another caller integration
  109. OIC - Maximum duration for integration flows | time out time for OIC services | Service limit for Scheduled orchestration or Async or Sync service
  110. OIC - Why Scheduled Integrations are not executing on Time.
  111. OIC - How to change From address for email Notification
  112. OIC - Advantages using Oracle Integration Publish and Subscribe model
  113. Upload and Download files to UCM:
    1. OIC - Upload and Download file to/from UCM ERP | Different options to upload & download files to/from UCM
    2. OIC - Download files from UCM using webservice | GenericSoapPort service
    3. OIC - Upload file to UCM using web service | GenericSoapPort web service
    4. OIC - download file from UCM using webservice | ErpIntegrationService
    5. OIC - Upload file to UCM using webservice | ErpIntegrationService
    6. OIC - upload file to ucm using rest service
    7. OIC - Upload file to UCM using Oracle ERP cloud adapter | ErpIntegrationService
    8. OIC - Download file from UCM using Oracle ERP Cloud Adpater | ErpIntegrationService
  114. OIC - Exposing Rest service supporting a file as attachment and JSON request using Oracle Integration
  115. OIC XSD - How to validate if any field is empty while reading the file | add restriction to a schema field
  116. OIC - How to configure Custom SOAP http headers
  117. OIC - How to convert XML data to Json data and store it in a variable
  118. OIC - Different types of translation failres while doing mapping in the mapper using xsd as a contents structure.
  119. OIC - what is the maximum concurrent / parallel OIC scheduled flows limit?
  120. OIC - Best Practice - Run large number of scheduled integrations at the same time | avoid creating too many scheduled integrations
  121. OIC - How many different scheduled integrations can run in parallel in Oracle Integration | Decoupled scheduler and Business Logic pattern.
  122. OIC - Read latest file from FTP location using oracle integration
  123. OIC Gen 3 New Features:
    1. OIC - Oracle Integration Generation 3 New Features
    2. OIC - Gen 3 - New feature - RBAC - Resource based access control
    3. OIC - Gen3 - How to publish and subscribe events | What is oracle integration events | what is publish event action
    4. OIC - Gen3 - Read in segment - set your own chunk or sement size
    5. OIC - Gen 3 - Parallel action
  124. OIC - Split comma separated string values to Array | Use of create-nodeset-from-delimited-string() function in XSLT
  125. OIC - Import (Replace) a Lookup | Update an existing OIC Lookup based on base64 encoded CSV file as rest feed
  126. OIC - Update OIC lookups based on BI reports invoke and config file
  127. OIC - Get files from AWS S3 bucket using rest
  128. OIC - Run a Schedule Integration now from oracle integration and retrieve Scheduled Integrations Run Status
  129. OIC ERP - How to select a Layout while invoking BI Report | use of attributeTemplate of ExternalReportWSSService
  130. OIC ERP - Create a Reusable Outbound integration | Run outbound interface reports to create outbound files
  131. OIC - ERP - create an integration to send outbound ERP File using BI bursting FTP delivery channel and ESS job | How to create an erp Outbound flow in Oracle Integration
  132. OIC ERP - submit ess job - sending multiple parameters | call BI Bursting - sending two reports| FTP delivery channel
  133. OIC ERP - Send custom Invoice report using Ess Job call and BI bursting report
  134. OIC ERP - Two Methods to receive Callback/Business Events from ERP – OAuth(New) and CISF Keys(Old)
  135. OIC -XSLT - find out total sum of invoice line item where each line having quantity and price using call template.
  136. OIC to HCM HDL integration | HDL import | Upload to UCM | Subscribe to atom feeds etc.

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...