Query to List Items, Structures and Components In Oracle Fusion

Please find the query to retrieve structure and components for an item: SELECT item.item_number Struct_Item, item.ORGANIZATION_ID, structb.ALTERNATE_BOM_DESIGNATOR, compb.item_num CompSEQ, complist.item_number Components, compb.EFFECTIVITY_DATE FROM FUSION.EGP_SYSTEM_ITEMS_B item JOIN FUSION.EGP_STRUCTURES_B structb ON item.INVENTORY_ITEM_ID = structb.PK1_VALUE JOIN FUSION.EGP_COMPONENTS_B compb ON structb.COMMON_BILL_SEQUENCE_ID=compb.BILL_SEQUENCE_ID JOIN FUSION.EGP_SYSTEM_ITEMS_B complist ON compb.PK1_VALUE=complist.INVENTORY_ITEM_ID and complist.ORGANIZATION_ID = item.ORGANIZATION_ID WHERE item.item_number='Toy Duck' -- Parent Item

Fusion: How To Create Password Protected BI Publisher Report

 

Fusion: How To Create Password Protected BI Publisher Report

Goal
How to create password protected BI publisher report outputs (pdf).

Solution
There are two types of password protected outputs (pdf) can be Created in the Fusion Cloud applications.
1. Static Password
2. Dynamic Password

1. Static Password
The below options required to update in the cloud application BI catalog services.
Navigation: Tools → Reports and Analytics → Browse Catalog

Navigate to appropriate report template folders and Click “Edit” the Template (which needed the password protection functionality) → Click “Properties” button.

Properties	Value
Enable PDF Security	True
Open Document Password

 Save the changes and Run the job.

The Report output will prompt the user to enter the password when open the output.

2. Dynamic Password

1. Create the Data Model (include/identify the field/value for password)

(ex, Supplier Number, Employee Number with DOB) 

(ex)

/DATA_DS/G_1/PASSWORD (Any customized/default password group)

/DATA_DS/G_1/SEGMENT1 (Supplier Number – Default Password, for supplier related reports)

2. Define RTF Template with the Custom Properties.

Navigation: RTF Template → File → Info → Properties → Advanced Properties → Custom

Add the below mentioned two custom properties.

Properties	Value	Type
xdo-pdf-security	true	Text
xdo-pdf-open-password	/DATA_DS/G_1/SEGMENT1	Text

Click “OK” and Save the Template.

Upload the template to BI catalog, Run the report and check the report output.

The Report output will prompt the user to enter the password when open the output.

Documents Reference

Oracle Support Documents

1. How To Set Password Protection For BI Publisher Report (Doc ID 2117187.1)

2. How To Password Protect PDF Documents At Runtime? (Doc ID 1355332.1)

Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher

Setting Report Processing and Output Document Properties → PDF Security Properties

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-300980F2-CC27-4DA5-9420-2D607CF132BF.htm#BIPRD2995

Limitations

The offered solution applicable for PDF outputs only and Oracle is working on EXCEL outputs.

Enh 26197461 - ER: PASSWORD PROTECTION FOR EXCEL FILES SENT THROUGH ORACLE BI PUBLISHER