Oracle Fusion BIP: Customizing Seeded Reports the Right Way

-

 Oracle Fusion BIP: Customizing Seeded Reports the Right Way

When a client asks to see only specific columns in a Standard/Seeded BIP Report, you have two main paths. 

Choosing the right one depends on whether you want to change the View 

or 

the Engine.

Option 1: Create a Custom Layout (Recommended)

This is the "cleanest" approach. You keep the standard logic but change the visual output

The Move: Create a new Layout (RTF/Excel/Online) using only the required columns from the existing Seeded Data Model.

Why it wins: It’s low maintenance. Since you’re still using the seeded Data Model, you benefit from any logic updates Oracle pushes during quarterly patches.

Best for: When the data is already there, you just want it to look tidier.


Option 2: Customize the Data Model

This is a deeper "under the hood" change.

The Move: Copy the seeded Data Model to the Custom folder, edit the SQL script to remove unwanted columns, and link it to a new report/layout.

Why it wins: Performance. If the seeded query is pulling massive amounts of unnecessary data that slows down the report, trimming the SQL can speed things up.

Best for: Complex reports where performance is a bottleneck or where you need to add custom logic/joins.

Comments

Post a Comment

Popular posts from this blog

Importance of Incremental Data in Oracle Fusion

-
 What is incremental data? Incremental Data Loads ----------------------- If you are sending employee data to a third-party payroll provider on every Friday, we don’t want to send all employees instead we only want the ones who changed current week. In this scenario, "LAST_UPDATE_DATE" column in the table plays vital role. LAST_UPDATE_DATE tells us when the record was physically saved. */ --Examples: ------------------------------- select count(1) from ( Select  papf.person_number, ppnf.FULL_NAME from  per_all_people_f papf, per_person_names_f ppnf WHERE 1=1 and papf.person_id=ppnf.person_id  and papf.LAST_UPDATE_DATE >=sysdate-7 --(Incremental) and ppnf.NAME_TYPE='GLOBAL' and sysdate between papf.EFFECTIVE_START_DATE and papf.EFFECTIVE_END_DATE and sysdate between ppnf.EFFECTIVE_START_DATE and ppnf.EFFECTIVE_END_DATE ) Result:  55 Records(Only Changed Records in current week) --------------------------------- select count(1) from ( Select  papf.person_n...
Read more

REST Web Service in Oracle Fusion to manage Banks

-
 REST Web Service  ================= Rest Resources Resources would have 5 end-points(methods) usually.  Ex: Create a Bank Read-Get a/all Banks Update Bank Delete a Bank Fusion Navigation for managing Banks  Setup and Maintenance Tasks Global Tasks Manage Banks Get All Banks  /fscmRestApi/resources/11.13.18.05/cashBanks https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks Get a specific Bank  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Create a Bank  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks patch  Update  https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Put https://fa-eubg-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks/{BankPartyId} Delete  https://fa-eubg-saas...
Read more