“[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”
View details Articles
Tobi Y.
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).
View details 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.
View details 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.
View details 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.
View details 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.
View details 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.
View details 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.
View details 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.
View details Yes you can write PL/SQL Functions on Oracle Fusion Cloud Applications
Starting with Oracle 12c, a powerful new enhancement lets you define PL/SQL functions and procedures directly inside a SQL query’s WITH clause.
View details