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...
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...
SQL query to get list of Jurisdictions for which Tax Rates has been defined in Oracle APPS R12
SELECT zj.tax ,zj.tax_jurisdiction_code ,hzg.geography_element2_code state_code ,hzg.geography_element3_code county_code ,...
No comments:
Post a Comment