Importing Custom Roles along with Data Security policies

 Hi

This blog is in continuation to the post "Exporting custom roles along with Data Security Policies". Please check it before this post.

Step 1: Go to Setup and Maintenance

Goto Task list and click on Manage Configuration Packages

Click on "Upload"

Choose the Configuration package downloaded in the previous post and click on get details

Click on Submit

Step 3: After Upload is successful, Click on Import Setup Data

Click on Submit

Once it is Completed Successfully, role has been successfully migrated

Exporting custom roles along with Data Security Policies

 Hi

This blog is regarding exporting custom roles from an instance.

Step 1: Goto setup and maintenance > Click on Manage Implementation Projects

Step 2: Click on + and create new implementation project

Specify Name and click on Save and open Project

Click on + sign again

Search Tasks

Search Manage Job Roles , select and apply

Search Manage Data Security Policies , select and apply

Click on Done

Step 3: Now Setup and Maintenance and click on Manage Configuration Packages

Click on + sign and create new configuration package

Select the Implementation Project created in the earlier step

Click on Next

Change Application Data Security Policy from 150 to 350

Select Function Security Custom Roles and click + sign at the scope level

Search for custom role name that has to be exported and click on apply

Click on Submit

Step 4:  Under Export and Import process, check status, if it is Completed Successfully , click on Download , click on Download Configuration Package. If Status is In Progress or Not Started , wait till Completed Successfully appears

Query to fetch Supplier Attachments

 Hi

Following query can be used to see Supplier Attachment related details in Fusion.

select psv.SEGMENT1 Suppliernumber,

          fdv.FILE_NAME, 

      fdv.TITLE,

  fdv.URL

from 

fnd_attached_documents    fad,

fnd_documents_vl               fdv,

POZ_SUPPLIERS_V         psv

WHERE  1=1

AND    fad.document_id = fdv.document_id 

AND    fad.entity_name = 'POZ_SUPPLIERS'

AND    fad.pk1_value                             = psv.vendor_id