How data bursting works on oracle cloud using file-based data Import

Subject: Supplier Data Bursting on Oracle Cloud using File-Based Data Import

Oracle Standard Template Download Link: (Oracle Help Center)

https://docs.oracle.com/en/cloud/saas/procurement/19c/oefbp/supplier-model.html#importsupplieraddresses-3054

Step1: Download XLSM template (.XLSM)

Step2: Prepare data & read the instruction guide.

- Read Instruction:

- Prepare data

- Select Import Action Update/Create as per the business need.

Step3: Generate .CSV file.

- Click on Generate .CSV file button

-Save the .CSV file, It will save as .CSV and .zip format.

Step4: Required to upload .csv with .zip format on server. 

Navigator > Tools > File Import and Export.

- Click on + button to add .zip file

- Select .zip file

- Add Account details prc/supplier/import

- Click on Save and Close Button

- Data is not imported into the Interface table. For import data into interface required to run 'Load Interface File for Import' request

- Navigation File Explorer > Tools > Schedule Processor

- Run the 'Load Interface File for Import' request.

- Now data will be imported into the interface table.

Step5: Run Import Program.

- Navigate to Procurement > Suppliers > Task > Import Suppliers

-          Select Action> Import Supplier Address

-          Import Options: New

-          Click on Submit.

-          After successfully request completed we can verify the data. If at time of request run we get any error check request error log and correct the data and follow the same process again.

  

Note: For supplier master migration on cloud we have required to upload all listed category data one by one with the same process steps. Above all steps for supplier address migration steps only.

Purge Interface Table:

1. Select the ‘Purge Supplier Interface Records‘ process from the Actions menu on the Import Suppliers page.

2. Select which interface table to purge.

3. Select which interface records to purge.  To clear only records with errors, select Rejected.

4. Submit the process. 

How to fetch previous record amount value as reference in current record at BI Report RTF level

Example: Report level balance is required to calculate based on the following formula.

Opening Balance: CF_DR_OB (Opening Debit Balance) - CF_CR_OB (Opening Credit Balance)

Balance: Opening Balance + (Debit line amount – Credit line amount)

Note: CF_DR_OB & CF_CR_OB are RDF level defined formula column.

Report Output Format:

Step 1: Set Temp local variable tag at RTF level:

<?xdoxslt:set_variable($_XDOCTX, 'RTotalVar', (CF_DR_OB - CF_CR_OB))?>

Step 2: Create Line Amount Variable tag:

<?xdoxslt:set_variable($_XDOCTX, 'RTotalVar',xdoxslt:get_variable($_XDOCTX,'RTotalVar') + (xdoxslt:to_number(PAY_AMT_DR) - xdoxslt:to_number(INV_AMT_CR) ))?>

Now upload the RTF file and execute the report you will get the expected solution.