PinnedBiman Dey SarkarWhy you should migrate to OIC Gen3Oracle is updating its OIC Platform to OIC Gen 3, which is the next generation, as most of you are undoubtedly aware. If the Gen 1 to Gen…Mar 6Mar 6
PinnedBiman Dey SarkarFetching BLOB data from ATPDB and use it in BIP ReportWe recently had a requirement to generate a ID card with dynamic data, where all data stored in ATP DB including pictures in BLOB. So we…Apr 7, 2023Apr 7, 2023
Biman Dey SarkarStoring input JSON payload in ATP using OIC for AuditWhen an integration is activated in OIC GEN3, three levels of tracking are available — Production, Audit, and Debug. But it is not…Jul 11Jul 11
Biman Dey SarkarConfigure Confidential Application to connect Oracle Process Automation(OPA) from OICIntroduction:Jul 5Jul 5
Biman Dey SarkarMerging 2 JSON Array into One in OIC using XSLTWe encountered a requirement wherein a target system’s API would return a set of data, and we would have to call another API to obtain the…Jun 201Jun 201
Biman Dey SarkarSchedule Start/Stop of an OIC instance with Visual Builder StudioIntroduction:Jun 13Jun 13
Biman Dey SarkarRead unstructured flat-file using PLSQL in OICIn one of my previous Blog I showed how to read a complex flat File using nXSD. However, there may be situations in which creating an nXSD…May 15May 15
Biman Dey SarkarList Files with dynamic dates in Oracle Integration CloudThere is no way to pass Minimum Age dynamically when utilizing list files via any FTP connection. This “Minimum Age” must be provided while…Apr 30Apr 30
Biman Dey SarkarUse native XSD (nXSD) file formats in OIC to process complex structured filesRecently, I came across a complex Bank Statement file from one of our customer. Currently, one shell script reads each line of each file…Apr 12Apr 12