python - all links together

 

Install required software and validation

pip install

Modules, Comments & Pip

Variables and Data Types

Strings

Lists and Tuples

Dictionary and Sets

Conditional Expressions or Decision making statements

Loops

Functions and Recursions

File I/O

Object-Oriented Programming

Inheritance & more on OOPs

Exception handling

Virtual env, pip freeze, Lambda function, join method, format method and map, filter, reduce

django - all blog links together

 

🔗Introduction & Install django and PyCharm CE

🔗create your first project and runservers and urls and views

🔗how to use templates

🔗homepage - fetch form textarea value from template to views

🔗webpage to have personal navigations

🔗webpage to input text and remove punctuation from it.

🔗adding Bootstrap to django website

🔗POST request and CSRF tokens

🔗Creating E-commerce website with apps setups

django - Creating E-commerce website with apps setups

Here, We will be creating a django E-commerce project named "myEcommerceSite" with 2 apps named "shop" and "blog" within it.

Django Apps :

• Apps in Django are pluggable web applications.
• Django apps are the self-sufficient sub module of a project. A project can contain more than one apps, and an app can be used in more than one project.

Follow the below steps:

Step 1: Click on File and then select New Project.

Step 2: After clicking on New Project, a pop-up window will appear. Select the location(PycharmProjects folder recommended) and name the file as myEcommerceSite

Step3: Start the project

C:\Users\Srinanda\Desktop\python\djangoCodeSource\myEcommerceSite>django-admin startproject mes

Step 4: Run the command in following format to create the app.

python manage.py startapp name_of_the_app

C:\Users\Srinanda\Desktop\python\djangoCodeSource\myEcommerceSite\mes>python manage.py startapp blog

C:\Users\Srinanda\Desktop\python\djangoCodeSource\myEcommerceSite\mes>python manage.py startapp shop

The project looks like :

Step5: Create urls.py file in both apps.

shop\urls.py:

from django.urls import path
from . import views
urlpatterns = [
path('', views.index, name="ShopHome"),
]

blog\urls.py

from django.contrib import admin
from django.urls import path
from . import views
urlpatterns = [
path('', views.index, name="blogHome"),
]

Step6: create views.py as below:

shop\views.py:

from django.shortcuts import render
from django.http import HttpResponse

def index(request):
    return HttpResponse("index shop")

blog\view.py:

from django.shortcuts import render
from django.http import HttpResponse

def index(request):
    return HttpResponse("index blog")

Step7: Update the main "mes" project urls.py with the following to include blog and shop apps urls.py

from django.contrib import admin
from django.urls import include, path
urlpatterns = [
    path('admin/', admin.site.urls),
    path('shop/', include('shop.urls')),
    path('blog/', include('blog.urls'))
]

Step8: run server:

C:\Users\Srinanda\Desktop\python\djangoCodeSource\myEcommerceSite\mes>python manage.py runserver

Step9: open following urls and  test:

http://127.0.0.1:8000/blog/ 

http://127.0.0.1:8000/shop/

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
4. OIC - how to create rest ics 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. 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
6. 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
7. 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
11. OIC - How can we adjust a date to ensure it falls on a valid working day, excluding weekends and public holidays while comparing the feeded input day with the header record date in javascript?
12. OIC - Convert DateTime from one timezone to another with Daylight saving in OIC
13. OIC - validate date format as mm-dd-yyyy
8. Synchronous Integrations Occasionally Fail with a 504 Gateway Time-out Erro
9. Use of lookup functions related:
1. Use of Lookup | Create a Lookup and use in an Oracle Cloud Integrations
2. OIC - How to update lookup from a csv file
3. OIC - Import (Replace) a Lookup | Update an existing OIC Lookup based on base64 encoded CSV file as rest feed
4. OIC - Update OIC lookups based on BI reports invoke and config file
10. 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 - GL Daily rated fbdi import to ERP and subscribe callback events
   
8. OIC ERP - How to download Oracle FBDI template | Generate CSV files from the template file
9. OiC understand of fbdi properties-file
10. OIC - ERP - How to get Job Package and Name
11. OIC - ERP - How to get the Job parameters for bulk import job
12. ERP - Register the CSF key | Subscribe to Oracle Fusion Cloud | Subscribe to Fusion Business events and FBDI Callback
13. OIC ERP - How to download Import Payables Invoices Report using ERP Cloud adapter from Oracle Integration
    
14. OIC - Import PGP private and public keys in the setting certificates
15. OIC - ERP Payable invoice callback - Custom report
    
16. OIC ERP - Get Source Name for invoice callback | fixed asset etc.
    
17. OIC ERP - BI report SQL query for invoice custom report
    
18. OIC- How can OIC integration subscribe to business events raised with Oracle ERP cloud
19. OIC - ERP - how to get child process id from import request id using otbi report
20. ERP BI SQL query for custom import response or callback
21. OIC To ERP - Design steps for Import and Custom callback | Oracle Integration Cloud
22. OIC - ERP - custom callback BI report | What we can do after the FBDI import
23. OIC to ERP : Move custom report | download custom report based on ess job id and then move to desired folder
24. OIC - Custom callback from erp | How we can leverage a custom callback using BIP report feature
25. Sample erp job details account name parameters
26. how to show the import response id to the activity stream for better support
27. 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
11. 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:
   
3. OIC ERP - Create a Reusable Outbound integration | Run outbound interface reports to create outbound files
   
4. 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
12. How to handle more than 10 mb file or large file poll
13. File adapter vs FTP adapter
14. OIC - Process large file (above 10MB)
15. OIC - Fetch name and value params from a input string
16. Target REST endpoint response payload processing failed.[Content received of length XXX bytes exceeds the maximum allowed threshold of 10485760 bytes
17. OIC - send Notification - email, log file and create incident
18. Global variable and Data Stitch action
19. Replace existing connection with the new connection in OIC integration
20. OIC - Integration properties
21. OIC - dynamic email send with html table content
22. Configre rest trigger to get CSV file
23. Common Integration Pattern Pitfalls and Design Best Practices
24. OIC - Integration Metadata Access
25. log file naming convention
26. Schedule parameters to get last run Date and Time
27. Why to avoid creating too many scheduled integrations
28. Convert a Scheduled Integration to a REST Adapter-Triggered Orchestration Integration
29. OIC - Run a schedule integration now using rest api
30. OIC - Opaque schema for creating base64Binary file
31. SFTP operations - Move and delete
32. OIC - callback action
33. OIC - Resolved - Stage read file in segements - XML-22031 : Error variable not defined.
34. OIC - 1z0-1042-21- topics to be covered for certification
35. OIC Schedule Integration schedule related:
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
4. OIC - How to modify an existing schedule.
5. OIC - iCal expression for scheduling a task to run at 4 PM on June 30th and December 31st each year in the Oracle Integration Cloud (OIC) scheduler?
6. OIC - We need to execute a schedule job in oic that will run only on weekdays excluding public holidays?
36. OIC - Oracle Feature Flasg overview
37. OIC - Migrations | how to migrate integrations in oic
38. OIC - how to include existing integration to a package
39. Encrypt and Decrypt and PGP key related:
1. Create PGP key to use in FTP connection
2. Signing vs verifications keys
   
3. OIC - Create FTP connection with PGP
4. OIC - Encrypt and Decrypt using FTP PGP connection and write operation
5. OIC - decrypt file using download FTP operation and read reference with Stage
6. OIC - using Stage file action to encrypt and decrypt files
7. Types of encryption techniques
8. OIC - AES encryption and decryption in javascript using CryptoJS
9. OIC - Extract RSA Public Key from a Certificate – Two Easy Methods (OpenSSL & Java)
10. OIC - How to Generate JWT CID Token with SHA256 Hash in Oracle Integration Cloud (OIC)
11. pgp tool to encrypt or decrypt the file
40. OIC - why to reactivate integration after connection details get changed
41. OIC - add header or line file field names with easy technique
42. OIC - about virtual file system | VFS
43. OIC - convert json to string
44. OIC - send binary object as rest response
45. OIC - search data from a csv file
46. OIC - about business identifiers
47. OIC - secure rest api with oauth security policy
48. OIC - Merge two different schema files into a single csv file
49. OIC - Retry logic in detailed steps with a scenario
50. Fixed length file related:
1. OIC How to create a fixed lemgth file using fixed length schema
2. OIC - How to create Multiple type fixed length file native schema(NXSD)
51. OIC - Read Json data received as json string
52. OIC - Invoke a rest service whose request and response payloads as XML | Invoke Rest API with XML payloads
53. OIC - Post XML payload with Rest API | Rest API with XML Request Response
54. OIC - Managing Multiple Operations in OIC SOAP Adapter
55. OIC Techniques - Decode base64 encoded BI publisher report | Call an Oracle Fusion Applications Business Intelligence Publisher Report Synchronously
56. OIC - How to read file size up to 1 GB in oracle integration
57. OIC | Embedded file server in Oracle integration | using file server in oracle integration generation 2
58. OIC | Oracle Cloud Integrarions | Restrictions using Oracle Integearion Generation 2
59. OIC | Oracle Integrations Editions | Standard vs Enterprise features
60. OIC Service limits | Generation 2 Resources limitation
61. OIC Gen 1 vs Gen 2 | Benefits of OIC Generation 2
62. OIC Retention period | Impact of increasing the retention period | Standard and Warning settings
63. OIC | Add Package Name for an Integration
64. OIC | Package Migration | Multiple Integration Migration
65. OIC | Migration of integration from one environment to another | Single integration Migration | Multiple Integration Migration
66. OIC - Prerequisites for creating Oracld ERP Cloud Connection
67. OIC Rest path parameters vs Query Parameters
68. 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
69. OIC | Merge two CSV files into one CSV file based on a common field or primary key
70. Oracle Integration Cloud | Merge two CSV files into a single file without any primary key or common field
71. OIC | Split a CSV file into multiple CSV files based on a column distinct values in Oracle integration cloud
72. OIC Certificate Management | Different type of Certificates in Oracle Integration Cloud
73. OIC - Export an Integration using REST API | Rest API for Oracle Integration export
74. OIC - Limitation of using staging area
75. OIC - ERP - Debugging of Business Events subscription for outbound integration
76. OIC - Import an OIC integration using REST API | How to use Multipart/form-data in Rest adaptet
77. Encode Base64 function strips off XML Tags in the payload | Oracle Integration cloud
    
78. OIC - Create a header file based on sequential unique lines Transaction number | Oracle Integration cloud
    
79. OIC Tracing | How to enable and use OIC Tracing | Oracle Integration Cloud
    
80. 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
3. OIC - Delete file from OCI Object storage bucket using rest connection
   
4. OIC - How to Rename a File in Oracle Object Storage using Oracle Integration (OIC)
   
5. OIC - How to List Files from Object Storage in OIC Without Using Wildcard Patterns
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
4. Secret Vault:
1. OIC - Create Secret in OCI Vault to store your keys and access from OIC
81. OIC - Create a Retry logic to overcome putting file to S3 using rest time out issue
    
82. OIC - Use REST adapter with multiple resources or Multiple Verbs in Oracle Integration Cloud
83. Twilio for sending sms, email or whatsup
1. OIC - Twilio adapter - send SMS / WhatsApp from Oracle Integration
2. OIC - How to Send Email Using Twilio SendGrid API in Oracle Integration Cloud (OIC)
84. OIC - ERP - Supplier import failed due to Supplier type is inactive or invalid
85. OIC - Design time audit logs | How to monitor design time audit logs
86. 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
18. ERP BI sql query to fetch output based on ESS REQUEST HISTORY Table last run date | Fetch Processstart from ESS_Request_History table
19. OIC ERP BI publisher call Retry logic Usecase 2
20. Cloud ERP | How to create an OTBI report | create BI publisher report
87. OIC - Convert CSV file data to JSON | Oracle Integration
    
88. OIC - How to continue FOR EACH loop for any failure case | Oracle Integration
    
89. 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
    
90. OIC - Read multiple records are of different types CSV file in Oracle Integration whete 1st column does not have default values
    
91. OIC - Upload attachment file in Rest API in oracle integration
    
92. OIC - Upload multiple attachment files in REST API in oracle Integration
    
93. OIC - how to call "upload attachement as in REST Integration" from another caller integration
    
94. OIC - Maximum duration for integration flows | time out time for OIC services | Service limit for Scheduled orchestration or Async or Sync service
    
95. OIC - Why Scheduled Integrations are not executing on Time.
    
96. OIC - How to change From address for email Notification
    
97. OIC - Advantages using Oracle Integration Publish and Subscribe model
    
98. 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
99. OIC - Exposing Rest service supporting a file as attachment and JSON request using Oracle Integration
    
100. OIC XSD - How to validate if any field is empty while reading the file | add restriction to a schema field
     
101. OIC - How to configure Custom SOAP http headers
     
102. OIC - How to convert XML data to Json data and store it in a variable
103. OIC - Different types of translation failres while doing mapping in the mapper using xsd as a contents structure.
104. OIC - what is the maximum concurrent / parallel OIC scheduled flows limit?
105. OIC - Best Practice - Run large number of scheduled integrations at the same time | avoid creating too many scheduled integrations
     
106. OIC - How many different scheduled integrations can run in parallel in Oracle Integration | Decoupled scheduler and Business Logic pattern.
107. OIC - Read latest file from FTP location using oracle integration
108. OIC - Get files from AWS S3 bucket using rest
109. OIC - Run a Schedule Integration now from oracle integration and retrieve Scheduled Integrations Run Status
110. OIC ERP - How to select a Layout while invoking BI Report | use of attributeTemplate of ExternalReportWSSService
111. OIC ERP - Send custom Invoice report using Ess Job call and BI bursting report
     
112. OIC ERP - Two Methods to receive Callback/Business Events from ERP – OAuth(New) and CISF Keys(Old)
113. OIC to HCM HDL integration | HDL import | Upload to UCM | Subscribe to atom feeds | configure HCM Extracts bulk data in an OIC integration etc.
     
114. OIC - OTBI report creation | Invoke the otbi report from Oracle integration | Invoke otbi report webservice from soap ui tool
     
115. OIC - About ATP Integration | Can we poll data from ATP as Trigger | ATP adapter Capabilities
     
116. OIC ERP - FBDI ImportBulkData using Erpintegration REST API | Get import status using Erpintegration REST API
     
117. OIC - There are large number of scheduled orchestrated integrations need to run at the same time. What we can do to avoid backlogged or queued integrations ?
     
118. OIC - How to embed image in email notification body
     
119. OIC BI - How to call oic web service from fusion BI report
     
120. OIC - How to extract large data from Oracle Fusion using REST APIs | How to overcome REST APIs limitation which can return only 499 records in a single request
121. OIC Javascript Function - Gen3 - the function definition contains unsupported synstax. The output parameter must be named.
     
122. ERP BI - How to invoke OIC rest integrations from BI report.
     
123. OIC ERP - How to enable Oracle ERP Cloud Business Events | Subscribe Business Events Raised within ERP Cloud
     
124. OIC - Error occured in fetching the attachment for Email
     
125. OIC - Append operation in Data stitch action | Incrementally build a messags payload using Data stitch
     
126. OIC FTP - FTP adapter write to file - File name pattern not taking the pattern specified in the mapper
127. OIC Gen3 related:
1. OIC generation 3 features links | OIC gen3 topics | OIC gen3 blogs
2. OIC Gen3 - New Feature - File Polling Feature using FTP trigger in OIC
3. OIC Gen3 - About OAuth setup to call integration and Factory APIs
4. OIC Gen3 - How To Extend Oracle Integration Cloud Gen3 Accelaretor Project.
5. OIC Gen3 - SAAS to SAAS integration | Get Oracle Right Now Incidents for Oracle CRM (Oracle CX Sales application)
   
6. OIC Gen3 - Retrieve CRM account details uaing Oracle CX Sales and B2B service adapter
   
7. OIC Gen3 - using Projects - Create a hello world integration with rest trigger.
8. OIC Gen3 - New feature - File Server Action in OIC 25.x
9. OIC Gen3 new feature - Simplified file handling using system events
   
10. OIC Gen3 New features 25.04 version
    
11. OIC Gen3 New Feature - Add Default Values in the Mapper
    
12. OIC - Gen3 New feature - Add Retry Logic to Invoke Connections in Projects
    
13. OIC - Gen3 new feature - Sign or verify a file using stage action
128. OIC - Error occurred while processing activity decryptsf4. Error: java.io.IOException: Error in decrypting the stream for file f:
129. OIC - How to get the outbound ip address of your oracle integration 3 instance
130. OIC - Comparison of OIC Stage Action and FTP Connection Capabilities referring digital signature.
     
131. OIC - How to rename a connection name in oracle Integration
132. OIC - Handling Two Different Types of REST Responses in a REST API Call
     
133. OIC - How to import prebuilt integrations from oracle market place | Oracle Utility CCS
     
134. OIC - Implementing Robust Error Handling with Backup Service and Custom Fault Response
135. OIC - Input Validation: Ensuring Mandatory Fields Are Filled, else reject the payload
     
136. OIC - when to use client credential flow vs Authorization code flow
     
137. Using XSLT functions:
1. OIC XSLT - Dynamic XPath Mapping in Oracle Integration: Handling Nested Transactions | use of current() function
2. OIC XSLT - Use of fn:format-number() | Formatting Large Amount Values to Two Decimal Places in XSLT
3. OIC - substring a string using index-within-string() function.
4. Use of Translate function in Oracle Integration
5. OIC - How to convert from one timezone to another timezone
6. OIC - "Using local-name() in XPath to Retrieve XML Data Without Namespace Prefix"
7. OIC - convert string yymmdd to date yyyy-mm-dd using substring() function
8. OIC- change date time format using xp20:format-dateTime() function
9. OIC - how to modify xslt for complex logic using Jdeveloper IDE
10. OIC - How to group data using for each group XSLT 2.0.html
11. OIC - Convert String XML to XML using parseXML() | Use of ParseXML() function
12. OIC | Convert UTC Date and Time to another timezone in Oracle integration cloud servic
13. OIC - Split comma separated string values to Array | Use of create-nodeset-from-delimited-string() function in XSLT
14. OIC -XSLT - find out total sum of invoice line item where each line having quantity and price using call template.
15. OIC - Need to format a dateTime object with a three character month
16. OIC - Converting one XML Field Values to distinct Comma-Separated Entries" | How do I generate a comma-separated list with XSLT/XPath?
17. OIC - how can I use XSLT functions to remove leading zeros from numeric and alphanumeric fields?
    
18. OIC - XSLT - "Using format-number() to Add Leading Zeros to Single-Digit Numbers"
    
19. OIC - XSLT - "Dynamic Payment Date Adjustment with XSLT: Handling Conditional Date Formatting"
    
20. OIC - Splitting Fixed-Length File Based on batch header Terminal Numbers into 2 separate files using xslt mapping.
21. OIC - How to retrieve previous node value using preceding-sibling in OIC XSLT
22. OIC - Converting standard DateTime to Unix Time in OIC Using XSLT functions
23. OIC - Understanding self::node() XSLT function in Oracle Integration cloud
24. OIC - Transforming anyType XML to a Namespaced Fragment using XSLT in Integration Flows | Dynamic XML Transformation: Namespace Remapping with xsl:apply-templates in XSLT
25. OIC - Padding leading zeros to a number field using xslt format-number()
26. OIC - Commonly Used XSLT Functions in Oracle Integration Cloud (OIC)
138. OIC ERP - How to extract Incremental data from ERP using BIP report in Oracle integration
     
139. OIC - Automating SFTP File Listing in OIC Based on Dynamic Date Filters and Adhoc Runs for past date files
     
140. OIC - Solution for 404 Not Found Error When Calling a Local Integration dynamically in OIC project
     
141. OIC - Oauth initiation error at runtime - Access token is not available. Please re-initiate the oauth flow to obtain an access token | Provide consent issue.
     
142. End to End Securing Data in Oracle Integration Cloud (OIC) with OCI Vault: AES for Encryption & Decryption & RSA for Signing and verification | Implement message-level encryption in Oracle Integration using OCI Vault
     
143. Signing vs Verification keys
     
144. OIC - Extract Microsoft 365 Outlook Email Attachments and upload them to OCI Object storage
145. OIC - difference between SOAP and REST
     
146. OIC - Can we send XML input in rest adapter?
     
147. OIC - Use of nested DVMs or lookups to implement conditional logic | Enhancing Error Handling in OIC with Conditional DVM Lookups
     
148. OIC - How to Skip OIC Schedule During Public Holidays
     
149. OIC - How to Retrieve Email Attachments Using Microsoft Graph API: Automating Payment File Processing
     
150. OIC - Source File Validation Using Stage File and Throw New Fault in OIC
     
151. With Microsoft Sharepoint:
1. OIC - Creating Folders in SharePoint Using Microsoft Graph API 1.0 in Oracle Integration Cloud
2. OIC - How to download file from sharepoint using Microsoft Graph API 1.0
3. How to use Microsoft graph explorer to test graph APIs
4. OIC - How to upload file to sharepoint using Microsoft graph API
152. OIC - Extracting File Name Before the Last Dot and Changing extension from .txt to .csv in OIC
     
153. OIC - Adjusting Dates in XML Transformations Using XSD Date Functions
     
154. OIC - Processing files using Multiple File Name Patterns in OIC File or FTP Adapter
     
155. OIC - How to configure Dynamic Decryption in OIC
     
156. OIC - Processing CSV Files with a Header and Unbounded Detail Records in Oracle Integration Cloud (OIC) | CSV file having 2 different types of records
     
157. OIC - How to Copy an Integration from One Project to Another in Oracle Integration Cloud (OIC)
     
158. OIC - Automating File-Based Integrations in OIC: A Scheduler-to-SFTP Flow Using Object Storage and Child Integrations
159. OIC - How to skip File Processing Excluding Hong Kong Public Holidays in Oracle Integration Cloud Using 1823 API
     
160. OIC - Automated Notification for Zero-Size Files in OIC SFTP Polling
     
161. OIC - Fixing WSDL Import and Element Errors While Configuring External Partner Adapters in Oracle Integration (OIC)
     
162. OIC - Convert dd-MMM-yy to MM-dd-yyyy date format using Call Template in Oracle Integration Cloud (OIC)
     
163. OIC - Date Conversion: Convert dd-MMM-yy Format to MM-dd-yyyy using javascript
     
164. OIC - Dynamic WSDL in OIC: Accept Any Payload with xsd:anyType
     
165. Postman - How to Test a OIC exposed SOAP Service Using Postman
166. OIC - Handling any Type Field Mapping in Oracle Integration Cloud (OIC) | Use of Local-namespace() function and apply template
     
167. OIC - Simulating External SOAP Service Calls in OIC Without Agent Using a Stub Integration
     
168. OIC - Resolving "SOAP Header Security was not understood" invoking Web Services
     
169. OIC - Combining Source File Records into a Single Line in Oracle Integration Cloud (OIC)
     
170. OIC - How will you handle error in OIC integration? If you are processing multiple records, how will you ensure all the records are processed even if a single record errors out?
     
171. OIC Lookup Import Error – "The Type, Name and Description Line is Invalid" [Resolved]
172. OIC - How to Add Blank Spaces When Creating Fixed-Length Files using javascript
     
173. [OIC Error Fix] Fixed length File Translation Failure While Writing File: 'Element CreationDate Not Expected'
     
174. OIC - Managing Integration Limits in Oracle Integration Cloud (OIC) Using Projects and Shared Connections
     
175. OIC - How to Exclude Header Lines in NXSD (Oracle Integration) Using nxsd:hasHeader
     
176. OIC - Fixing WSDL Import and Element Errors While Configuring External Partner Adapters in Oracle Integration (OIC)
     
177. OIC - Moving a File using FTP connection now throws IO operation failed error
     
178. OIC - Can we use/call plsql in OIC xslt for complex logic processing?
179. OIC - How to Avoid Storing Duplicate Data in a Database When Integrating ERP with Oracle Integration Cloud (OIC)
     
180. OIC - Handling Null or Empty BIP Report Files in Oracle Integration Cloud to Prevent Flow to Downstream Applications
     
181. OIC - Enrichment Service in Oracle Integration Cloud (OIC)
     
182. OIC - Resubmit Failed Messages
     
183. OIC - Versioning in Oracle Integration Cloud (OIC) - Generation 3
     
184. OIC - Using REST API vs ERP Cloud Adapter in FBDI Import
     
185. OIC - Oracle Integration-Bulk load into Oracle ATP OR Oracle ADW
     
186. OIC - Convert a package to a project
     
187. OIC - Restrictions on Using Stage File Action Operations with the File/Attachment Features of the Connectivity Agent
     
188. OIC - "Dynamically Configuring Relative URLs for REST API Invocations in Oracle Integration Cloud" | Dynamically invoke local integration
     
189. OIC - How to add days to date YYYY-MM-DD using prebuilt functions
     
190. OIC - Javascript - How to add days to a date (YYYY-MM-DD) format.
     
191. OIC - Managing Sequence Numbers using lookup in OIC for Dynamic Target File Naming
     
192. OIC - Seamless Integration: SCM to SAP EFMS Inventory Transactions Flow
     
193. OIC - Major steps to import HDL file To HCM | Upload to UCM and Run import and load data job
194. OIC - Grouping Payment Data with XSLT: Using for-each-group to Transform Headers and Details in Oracle EBS
     
195. OIC - Handling Mixed File Inputs in Oracle Integration (OIC): Smart Zip Check and Transfer to SFTP
     
196. OIC - Smart File Polling from OCI Object Storage with Dynamic Day-Based Logic and Datadog Logging
     
197. OIC - Streamlined OIC Scheduled Integration for GL Fuel Cost Data Using ESS Job Callback and Event-Based File Processing Without Timeouts
     
198. OIC - How to add Filters while subscribing ERP business events in Oracle Integration
     
199. OIC - End-to-End OIC Integration for AP Invoice Payment Request Processing and Status Callbacks in Oracle Fusion | AP invoice Payment Request FBDI import and callback
     
200. OIC - Tracking AP Invoice Import Status Using SQL for BI Publisher and OIC Integration
201. OIC - Lessons Learned & Improvements in OIC Integrations
202. OIC ERP - How to Restore Missed or exhausted business events in OIC
     
203. OIC - Designing a Reusable Callback Integration for Multiple FBDI Uploads
204. OIC - Monitoring and Troubleshooting Integrations in Oracle Integration Cloud (OIC) Gen 3: A Practical Guide
     
205. OIC - Line-by-Line Data Parsing in OIC Using Custom XSD Schema
     
206. OIC - Verifying RSA Signatures Using OCI Functions and Java – A Seamless OIC Integration
     
207. OIC - What is the difference between synchronous and asynchronous integrations? Can you give examples in OIC?
     
208. OIC - Converting Unix Timestamps to Standard Time in JavaScript