3 Uploading Data Files

After you prepare data in the .csv format according to the required templates, you must use the PAR URL that is mentioned in the Object Storage to access the bucket.

Enter the details of the .csv file path, PAR URL, and the .csv file name in the HTTP utility such as cURL to upload data files into the Object Storage. The PAR URL, which you use to access the Object Storage is refreshed every seven days. Multiple users can load data into the Object storage concurrently from different locations. If there are any corrections required in the data files, you can modify the .csv data files and upload them using the same PAR URL. The modified data files overwrite the previously loaded data files in the Object Storage.

Note:

  • You can not download or delete data files after you upload them to the Object Storage.
  • The maximum size for an uploaded object (data file) is 10 TiB.
  • Object parts must be no larger than 50 GiB.

If there are any issues with the file upload, you must contact My Oracle Support.

For every instance of OFS FCCM provisioned, two buckets are created - a Standard Storage Bucket and an Archive Storage Bucket.

Figure 3-1 Object Storage

This image shows how Object Storage is managed. Standard Storage Bucket:This storage bucket is accessed daily to load data. This bucket stores data for seven days. After seven days, data files are archived into the Archive Storage Bucket. This bucket is also used to process data from the Object Storage to the staging tables.Archive Storage Bucket: This storage bucket is used to access data rarely. For example, weekly or monthly. You cannot load the data files into this bucket directly. The Data file is archived in this bucket from the Standard Storage Bucket after seven days. The archived data file is preserved for one year. After one year, the archived data files are deleted from this bucket.
  • Standard Storage Bucket: This storage bucket is accessed daily to load data. This bucket stores data for seven days. After seven days, data files are archived into the Archive Storage Bucket. This bucket is also used to process data from the Object Storage to the staging tables.
  • Archive Storage Bucket: This storage bucket is used to access data rarely. For example, weekly or monthly. You cannot load the data files into this bucket directly. The Data file is archived in this bucket from the Standard Storage Bucket after seven days. The archived data file is preserved for one year. After one year, the archived data files are deleted from this bucket.

Data Loading via Object Storage supports two versions of FSDF, namely, the latest version (8.1.2.4) and the previous version (8.0.8). To specify which FSDF version the template you are using to upload data to Object Storage is compatible with, you must update the parameters in the AMLDataLoad batch.