Oracle Fusion

Multi Sheet Excel output using RTF Template

Hello Everyone,

Today let us see how to place multi sheets in Excel.

In the rtf document, enter required data to be shown in the First Sheet

Now in the Microsoft word, goto Layout tab

Select Breaks

Select Page

This will place your cursor in a new page which will be like a new sheet in the excel.

Enter Second sheet info now

Insert your xml and run it. Output Format: Excel

Checking output

Hope this works..

How to show Parameter along with its description but link data set with only parameter in Fusion

In this post let us see how to link parameters and BIP report data set when we want to show both field and description in parameter but in data set only field is present.

Go to your datamodel and edit LOV

Sample Query: Select field||'-'||description, field from table1

This query shows the corresponding field along with description in parameter selection part but internally it returns field to the data set.

Example: P_Item: select item_number||'-'||item_description, item_number from items_table

How it is shown in parameters

Item Number : Item1-Test Item

Internally value passed will be "Item1"

Hope this helps...

Some steps that can be followed while creating or customizing a role in Fusion

Hello Everyone,

Let us see some tips that can be useful while creating or customizing a role in Oracle Fusion.

1. Before creating a custom role, search if any seeded/ Oracle provided role is close to the one you require, if you find any such go with customizing i.e., copying of seeded role and work on it. If not starting creating a new role.

Recommending to find a close role since there will be many data security policies associated with role and underlying privileges which will be difficult to find and add if working from scratch.

2. Role name can be changed at any point of time but role code cannot be changed once we save, so make sure of the role code before doing final submit.

3. Generally we don't need to touch data security policies unless the requirement is very specific. So make sure before deleting any data security policy.

4. Unnecessary Function Security Policies can be deleted.

5. In Function Security Policies, we can see few privileges are inherited other role. These privileges can be removed only if inherited roles are removed.

6. While working on Role hierarchy tab, make sure to not remove _obi roles if corresponding role is used since these might be related to running corresponding report outputs

7. Similarly do not delete any roles with _hcm and _crm if corresponding roles are used in Role hierarchy

Query to fetch Chart of Accounts Value Set Values

Hi,

Following query can be used to see the values in Manage Values page.

select

fv.value,

fv.DESCRIPTION,

fv.ENABLED_FLAG Enabled,

fv.START_DATE_ACTIVE Start_Date,

fv.END_DATE_ACTIVE End_Date,

fv.SORT_ORDER,

fv.SUMMARY_FLAG Summary,

fv.FLEX_VALUE_ATTRIBUTE1 Posting_Allowed,

fv.FLEX_VALUE_ATTRIBUTE2 Budget_Allowed,

gl.Meaning Account_type,

fv.EXTERNAL_DATA_SOURCE

from

fnd_vs_value_sets fvvs

,FND_VS_VALUES_VL fv

,gl_lookups gl

where

fvvs.VALUE_SET_ID=fv.VALUE_SET_ID

and fv.FLEX_VALUE_ATTRIBUTE3 =gl.lookup_code

and gl.LOOKUP_TYPE='ACCOUNT TYPE'

Importing Custom Roles along with Data Security policies

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

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

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