Oracle Applications E-Learning Lab

List the files under the directories  find . -type f -printf "%T@ %p\n" | sort -nr | cut -d\  -f2- How to Create file in Unix Directory cat > file1.txt How to copy output in unix to out file  SomeCommand > file1.txt Or if you want to append data: SomeCommand >> file1.txt How to find file count in each folder sub folder in unix find . - type d -print0 | while read -d '' -r dir ; do files=( " $dir " /*) printf "%5d files in directory %s\n" " ${#files[@]} " " $dir " done How to find files in unix find / -iname 'jssl-1_1.jar' 2>/dev/null

  # Tutorial Link 1 Demystifying Oracle Visual Builder Cloud service and understanding its architecture 2 Developing and deploying a Hello World Page in VBCS 3 Building CRUD Application through Business object and deploying it on Visual Builder Cloud Services(VBCS) 3 Implementing Select One Choice or List of Values in Visual Builder Cloud Services(VBCS) 3 Developing Custom Search Page in VBCS

  # Tutorial Link 1 What is Oracle Integration Cloud Service? What is the various type of integration flows available in OIC? 2 Building Blocks and Life cycle operations of an Integration in Oracle Integration Cloud Services 3 Quick 3 steps to create Oracle Integration Cloud instance in Oracle Cloud Environment? 4 What are the Different Types of Integration Patterns available in Oracle Integration Cloud Services? 5 Explorations of Accelerators and Recipe in Oracle Integration Cloud Services 6   Build Sample REST integration using Oracle Integration Cloud services 7   Consuming External Rest API in Oracle Integration Cloud service 8   Decoding Agents in Oracle Integration Cloud Services and explore the prerequisites required to install the Connectivity Agent on your local network 9

Processing large files in any integration requires a lot of effort and complex coding. Every integration platform has a limit size to read a file, similarly, the OIC service provides a limit of 10MB to read the file, if the size exceeds, then the below error will be encountered  Error Reason: Translation Error. Translation Error. Error while translating message to native format. Please make sure that the payload for the outbound interaction conforms to the schema and payload size does not exceed threshold. Error occured as File size exceeds maximum threshold size of 10 MB : Application Error Error Summary: ICS runtime execution error  In this article, we will learn how to read the big-size file in OIC.  Note only XML and CSV formats are supported for larger file read operations.  Here we will build an integration with a source FTP connector to read files containing sizes more than 10 MB  &  read them through the "Read File in Chunks" features and create multiple files  at

Read CSV File from FTP server and insert data into On-Premise Database using OIC  In this article, we will learn how to reuse or call already built integration into another integration.  Use case:  REST integration needs to be developed with the capability to read CSV data from an external FTP server and insert the CSV data into Oracle On-Prem Database 1. Create another  REST Integration in OIC to read a CSV file based on JSON Payload Let's name it  Integration1 (ReadCsvandDatabaseInsert) 2.  Create REST Integration in OIC to insert data into the On-Premise Database instance, Let's name it  Integration2 ( OnPremDataInsert ) 3. Now will call  Integration2 ( OnPremDataInsert )    with the name  OnPremDataInsert  in  Integration1( ReadCsvandDatabaseInsert )  to read CSV data from an external FTP server and insert the CSV data into Oracle On-Prem Database Now let's create  I ntegration1 (ReadCsvandDatabaseInsert)    to read a CSV file based on JSON Payload Create the integratio