Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF)
Friday, December 20, 2024
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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
APEX$TASK_PK
APEX$TASK_PK is a substitution string holding the primary key value of the system of records
FNDLOAD to Download and Upload XML Publisher Data Template (.xml) Report
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
Query to get OM Order Types in Oracle Apps
SELECT HAOU.NAME "Operating Unit", OTTT_H.NAME "Transaction Type", OTTT_H.DESCRIPTION "Descripti...
SQL Query To Get Invoice Validation And Accounting Status For The Given Check Number (Doc ID 2975480.1)
SELECT aca.check_number ,aia.invoice_id ,aia.invoice_num ,aia.invoice_amount ,distribution_line_number ,aida.accrual_p...
No comments:
Post a Comment