CLOB column splitting(one empty row and other actual data) data into multiple rows in Oracle Fusion

When working with CLOB columns in Fusion Reports we may face challenges like data splitting into multiple rows for the CLOB Column.

We faced challenges when generating report in Excel Output. The Description column showing one empty row followed by actual data as shown below.

Data Model Query:

When pasted in Excel File:

To overcome this issue convert clob value into Character using TO_CHAR function.

Ex: TO_CHAR(DESCRIPTION) 
here DESCRIPTION is a CLOB Column 

Thousand Separator((,)comma) in e-Text Report

AMOUNT column want to print thousand separator in Oracle Fusion e-Text Report use  Number, ###,###.00

Number, ###,###.00

R, ' '

AMOUNT

Reconciled & Unreconciled Transactions Reports in Oracle Fusion

• Reconciled Transactions Report provides details of clearing account journal lines that have been successfully reconciled by both automatic and manual reconciliation processes.

• Unreconciled Transactions Report lists all unreconciled clearing account journal lines, specifically the unreconciled lines that weren't subjected to reconciliation yet, those lines rejected by previous automatic or manual reconciliation processes, and those lines that were marked as reviewed.

Journals Day Book Report in Oracle Fusion

• This report provides posted journal entries and journal details chronologically by accounting date for a specified range of dates, journal source, and journal category.
• Report sorts journal entries for each accounting date by document number.
• It prints the accounting date, document number, journal entry name, journal source and category, subledger document name and number, currency, and conversion rate.
• Report prints for each journal line, the line number, account segment value and description, functional debit and credit amounts, description, and cost center segment value.

Journals Details Report in Oracle Fusion

• This report provides information about manually entered journals prior to posting, including field by field, all data entered into the applications or data imported from external sources.

Journals Batch Summary Report in Oracle Fusion

• This report lists posted journal batches for a particular ledger, balancing segment value, currency, and date range. 
• It provides information about actual balances for your journal batches, source, batch, and posting dates, total entered debits and credits. 
• Report sorts the information by journal batch within each journal entry category.
• This report includes totals for each journal category and a grand total for each ledger and balancing segment value combination.
• It doesn't report on budget or encumbrance balances.

General Journals Report in Oracle Fusion

• This report provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

Journals Report in Oracle Fusion

• This report provides Journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.
• It also prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal.
• Report includes a total for each balancing segment and a grand total for all the activity. 

Average Balance Audit Account Analysis Report in Oracle Fusion

• This Report displays the detail account activity that created the aggregate balances and related average balances.
• It displays daily Average Balance information for the selected accounts for the specified range of dates.
• It contains parameters such as the As-Of reporting date, average balance type (period,quarter, or year average-to-date), and account ranges.

Account Analysis for Contra Account Report in Oracle Fusion

• This report Prints balances by account segment and a secondary segment.
• It lists the contra account for each journal entry and the subledger document number for transactions imported from subledgers.
• It prints by date range, accounting Flex Field range, contra account, and amount range.

General Ledger Account Details Report in Oracle Fusion

• Provides journal information to trace each transaction back to its original source.
• Prints a separate page for each balancing segment value.
• For each journal line it prints the account affected, the concatenated description, the journal line amount, and the beginning and ending account balance.
• It also prints Journal details including source, category, journal name, and effective date.
• Report lists accounts in ascending order by account segment value.
• It prints a CR next to credit amounts

Account Analysis Report in Oracle Fusion General Ledger

• Prints balances by account segment and a secondary segment for each journal entry.
• Lists the subledger document number for transactions imported from subledgers. 

Set Oracle Report(rdf) Concurrent Program ends with Warning Status

Create a user parameter as P_CONC_REQUEST_ID as shown in below screenshot.

In before report trigger initialize using user exists as shown in below screenshot.

Below is our requirement:

We have two optional parameters Account and Parent Account. User has to select either of the one parameter. If user selects both Parameters then the report output will be blank. So we are completing program with Warning status so that user can go review the log file.

As shown in above screenshot write srw.message to see the message in log file.

Assets by Cash Generating Unit Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Assets by Cash Generating Unit Report:

• Lists all assets by cash generating unit. 
• The report extracts the details of all of the asset impairment transactions, such as asset number, cash generating unit, cost, net book value, accumulated impairment reserve, and year-to-date impairments from Oracle Fusion Assets.

Hypothetical Depreciation Analysis Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Hypothetical Depreciation Analysis Report:

• Lists depreciation projections for hypothetical assets based on the specified depreciation parameters.

Property Tax Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Property Tax Report:

• Lists the assets at a particular location as of the specified cutoff date. 
• This information is used for property tax forms. 
• The report is sorted by and groups totals for each balancing segment, location, asset account, and year acquired.

Revaluation Reserve Summary Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Revaluation Reserve Summary Report; 

• Lists asset level revaluation reserve account balances for the specified periods. 
• The report is sorted by and groups totals for each balancing segment, reserve account, and cost center.

Revaluation Reserve Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Revaluation Reserve Detail Report:

• Lists asset revaluation reserve account balances for a specified period for an asset level. 
• The report is sorted by and groups totals for each balancing segment, asset cost account, and cost center.

Reserve Summary in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Reserve Summary Report:

• Lists reserve account summary balances for the specified periods. 
• The report is sorted by and groups totals for each balancing segment and reserve account.

Reserve Detail Report in Oracle Fusion

Oracle Fusion Assets provides predefined reports that are used in the close process and to verify asset transactions. The Assets reports run from the Scheduled Processes work area found on the Navigator.

Reserve Detail Report:

• Lists asset level asset reserve account balances for the specified periods. 
• The report is sorted by and groups totals for each balancing segment, reserve account, and cost center.