Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF)
Showing posts with label
CLOB
.
Show all posts
Showing posts with label
CLOB
.
Show all posts
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
Older Posts
Home
Subscribe to:
Posts (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...
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...
To find SERIAL_NUMBER_CONTROL_CODE Values in MTL_SYSTEM_ITEMS_B table
Serial_number_control_code column contains values as 1,2,5 &6 in mtl_system_items_b table. Inorder to find meaning for this values r...