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.

Issue: Oracle Custom Form Enable List Lamp does not appear in Date field Property Palette LOV level.

At the time of open custom form or compilation time into Form builder following Error received.

ERROR

FRM-18108: Failed to load the following objects.
Source Module: APPSTAND Source Object: STANDARD_PC_AND_VA
Source Module: APPSTAND Source Object: STANDARD_TOOLBAR
Source Module: APPSTAND Source Object: STANDARD_CALENDAR

Solution: Required to load all standard object source file before compiling the form or opening the form.

Step 1: Download APPSTAND.fmb  file from ($AU_TOP/forms/US)  using FTP server.

Step 2: Copy this APPSTAND.fmb file at local machine Form Path Level and paste it at the local machine level form path location.

We can check the local machine form path.

Navigation:

My Computer > Right Click > Property > Advance System Settings > Advanced > Environment Variable > FORM_PATH

Upload .fmb file

Step 3: Open the APPSTAND.fmb file into the form builder after that open your custom form .fmb file.

Step 4: Now an onward custom form will never give any error for missing source object files.

Step 5: Now you can able to see ENABLE_LIST_LAMP option in text field Property palette LOV level.

After loading the APPSTAND.fmb many standard object subclass also you can able to use.