Insights – Page 6 – Advised Solutions – Oracle Consulting & Managed Services

Records are merging across rows when exporting output into Excel

Deep DiveBy Tobi Y.1 July 2023

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

Deep DiveBy Tobi Y.3 June 2023

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

Deep DiveBy Tobi Y.6 May 2023

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

Deep DiveBy Tobi Y.1 April 2023

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

Deep DiveBy Tobi Y.4 March 2023

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

Deep DiveBy Tobi Y.4 February 2023

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

Reporting on Period-End Accruals

Deep DiveBy Tobi Y.7 January 2023

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