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.

Data Security in Procurement BI Publisher Reports

Securing Procurement BI Publisher Reports, ensuring users only access requisitions assigned to BUs they are agents of or where they are the assigned buyer.

Calling a Subtemplate from a BI Publisher Template

Oracle BI Publisher allows report developers to create modular and reusable templates by using subtemplates within a main template.

Records are merging across rows when exporting output into Excel

One common formatting issue arises when rows in the Excel output file appear merged together into a single block instead of displaying as distinct lines. 

Data Security in General Ledger BI Publisher Reports

Oracle Cloud ERP provides flexible and granular tools for securing General Ledger (GL) data, ensuring users only access ledgers and accounts relevant to their roles.

Generating a Single Invoice for Transactions with multiple installments

This post details the steps required to deliver BI Publisher report outputs/documents to an employee’s Document of Record (DOR) using HCM Extracts.

Duplex Printing in Oracle Fusion Cloud Application

Utilise this BI Publisher command to support duplex printing, by force page counts to end on even numbers.

Sending Invoices, Statements and Dunning Letters to an SFTP Location

This post describes the steps required to send AR Invoice, Statement and Dunning Letters to an SFTP Location

Print Receivables Transactions – One Invoice for Multiple Installments

Print Receivables Transactions – Printing one invoice for Invoices with multiple installments

Reporting on Period-End Accruals

Tracing back Period-End Accrual Journal Lines to the originating Purchase Order.