How to enable Oracle fusion report GL Level User Security Profile

Requirement: Oracle Report will give output for specific code combination only which is based on User Security profile option.

Step1: Required to create a parameter

Step2: Create Flexfield with following details. 

- Now when you run the report it will give output for only those account which is enabled at User Security profile for that user.

Note:

1.       we have to use the table GL_CODE_COMBINATION_KFVS main Dataset table alias name in Code Combination Table Alias  name in configuration

2.       We can enable User Security profile on Dataset level only not on Parameter level using this process.

How to arrange decimal numeric string in sequence using order by syntax in SQL

Requirement: 7 decimal numeric string required to arrange in numeric sequence.

Example:

2

2.1

2.1.1

2.1.2.3

2.1.2.3.4

2.1.2.3.4.5

2.1.2.3.4.5.6

2.1.2.3.4.5.6.7                         

Solution:

SQL Order BY syntax:

Note: Required to replace the ‘COLUMN_NAME’ as per your requirement and add into the SQL query.

order by

         to_number(substr( '.'||COLUMN_NAME||'.',

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 1 )+1,

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 2 )-instr( '.'||COLUMN_NAME||'.', '.', 1, 1 )-1 ))

            nulls first,

         to_number(substr( '.'||COLUMN_NAME||'.',

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 2 )+1,

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 3 )-instr( '.'||COLUMN_NAME||'.', '.', 1, 2 )-1 ))

            nulls first,

         to_number(substr( '.'||COLUMN_NAME||'.',

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 3 )+1,

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 4 )-instr( '.'||COLUMN_NAME||'.', '.', 1, 3 )-1 ))

            nulls first,

                                to_number(substr( '.'||COLUMN_NAME||'.',

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 4 )+1,

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 5 )-instr( '.'||COLUMN_NAME||'.', '.', 1, 4 )-1 ))

            nulls first,

                                                to_number(substr( '.'||COLUMN_NAME||'.',

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 5 )+1,

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 6 )-instr( '.'||COLUMN_NAME||'.', '.', 1, 5 )-1 ))

            nulls first,

                                                to_number(substr( '.'||COLUMN_NAME||'.',

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 6 )+1,

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 7 )-instr( '.'||COLUMN_NAME||'.', '.', 1, 6 )-1 ))

            nulls first,

                                                to_number(substr( '.'||COLUMN_NAME||'.',

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 7 )+1,

                   instr( '.'||COLUMN_NAME||'.', '.', 1, 8 )-instr( '.'||COLUMN_NAME||'.', '.', 1, 7 )-1 ))

            nulls first

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.