BI Publisher (MOSC)

MOSC Banner

XML Publisher RTF to Excel TEXT format issue

edited Mar 26, 2016 5:02AM in BI Publisher (MOSC) 6 commentsAnswered

Hi,

I am having an issue with a few columns on a pretty straight forward XML publisher report. In the RDF report I have a column defined as text "SCHEDULE_NAME", this column is being queried from the database. Underlying the RDF I have an RTF which is being displayed as <?SCHEDULE_NAME?>. The report is defaulted to be opened in Excel.

The issue I am having is when ever the name field fetches data with two or more consecutive spaces in between the column/field value, the spaces are being displayed as Non breakable space which seems as Space in Excel. But when I copy the same value and query in the database against the SCHEDULE_NAME column I am not getting the result in TOAD or front end.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center