Using @INLINES in your BI Publisher RTF Template

BI Publisher RTF templates support powerful markup commands to control data rendering, formatting, and logic in output documents. One advanced command is @INLINES

“[nQSError: 27047] Nonexistent table” when Querying a PVO

When querying Public View Objects (PVO), developers can encounter the dreaded error: text[nQSError: 27047] Nonexistent table: “TABLE_NAME”

Access to BICC Console and UCM Content in Oracle Fusion Cloud

To use BICC effectively, users need appropriate roles for both extracting data and accessing the output files stored on Oracle Universal Content Management (UCM).

How to Add a Filter to a Data Store in BICC

Oracle BI Cloud Connector (BICC) empowers organisations to control and optimise their cloud data extractions by enabling precise filtering at the Data Store level.

Extracting data from Oracle Fusion Cloud BI PVOs using Logical SQL

Logical SQL interacts with the Oracle BI Server, which translates user queries into requests against presentation-layer objects, such as subject areas in the repository.

Session and System Variables in Oracle Fusion Cloud BIP Reports

When creating BI Publisher reports, session and system variables are powerful tools that enable you to personalise report data dynamically based on the logged-in user.

Secured Lists Security for HR and Payroll Reports in Oracle Cloud HCM

Oracle BI Publisher Oracle BI Publisher supports robust security controls in HCM through Secured List Views, enabling organisations to restrict report data dynamically based on users’ roles.

Retrieve the XML Extract for Payments and Funds Disbursement Reports

Retrieving the XML extract for payment file reports and related funds disbursement outputs is a common need when customizing or troubleshooting Oracle Cloud ERP.

Identify the Oracle Fusion Cloud POD Name using SQL

Identiying the POD Name is an important aspect of report delivery. This should be used in bursting queries to determine where to send outputs on PROD vs NON-PROD environments, amongst other use cases.

MOAC Security for AP and AR Reports in Oracle Cloud ERP

Securing sensitive financial data is crucial in Oracle Cloud ERP. Robust Multi-Organisation Access Control (MOAC) can be used to safeguard data access for AP and AR.