How To Retrieve Query for BICC VO in Oracle Fusion Cloud

So, you are wondering how to retrieve the actual database query behind any VO in BI Cloud Connector (BICC) ? Here's how we can do it.

- Log in to BI Analytics as user with BI Administration privilege.

Navigation path: BI domain → Analytics → Administration

- On Administration page, navigate to Issue SQL option

- Enter physical SQL as below:

select_physical * from

"<VO Name>"

WHERE 1<> 1

e.g. 

select_physical * from

"FscmTopModelAM.FinApInvTransactionsAM.InvoiceHeaderPVO"

WHERE 1<> 1

- Click Issue SQL

- Click View Log option and download the log file

- In the log file, search for string "query to database". It should looks like this -

- Copy the complete query and format it. It will look like this -

- Now, this is the true underlying query issued at database level.

Read More

How to access Descriptive Flexfields in Oracle Fusion Pages

In Oracle EBS, Descriptive Flexfields, if configured, can be accessed from Oracle forms by locating [ ] field that presents a modal window containing all configured attributes along with available contexts. 

However, in Oracle Fusion/ERP Cloud, we don't have this field. By default, the pages may not show DFF section at all but there's a very simple way to hide/unhide them.

Below example shows us a Journal entry page that' doesn't show any DFF sections for Journal header -

Now, let's say we want to find the all Descriptive Flexfields available on this page. 

To do this, navigate to Settings and Actions menu located at top right corner under your account name.

In the dropdown menu, you will see Highlight Flexfields section.

Click on this option and your page will reload and you'll be able to see Descriptive Flexfield section -

Read More