Handling BICC Extracts Exceeding 10 MB Stage Write Limit in OIC
Summary:
We are extracting data from Oracle using BICC and sending it to the SFTP server for downstream processing. However, the BICC extract file size often exceeds 10 MB, and when we try to fetch the file from UCM and write it to the SFTP using Stage File Action with Opaque Schema, OIC fails because of the 10 MB stage write service limit.
Error:
ora:doXSLTransformForDoc('resources/processor_34656/resourcegroup_34659/req_b2d72c0407fc4150a9ca2845da67a49c.xsl', $messagecontext_27892, 'GETZIPFILEUCM', $messagecontext_34436)" Error at line 28, column 184, oci-42F52ED09FE5BA1-202602101849/BFE4D744E2A67FA5AE7D8B69494144CA/F8851BA14AC1404F80E4CA49C4238C76InternalServiceLimitErrorstagefile-service-6d4579c797-twms9SF1001{http://schemas.oracle.com/bpel/extension}runtimeFaultfalseError occurred while processing activity readContent. Error : File size 15.68 MB exceeds maximum threshold size of 10.00 MB.Please make sure that the file size does not exceed threshold.