BI Publisher (MOSC)

MOSC Banner

BI Publisher(11g) XML Not Pulling data for Date columns in Teradata

edited Jan 23, 2013 2:40AM in BI Publisher (MOSC) 1 commentAnswered

Hi,

we have some reports which are displaying date columns from teradata database so what we observed is that these columns data or the xml tag itself is not displayin in the UI when we generate XML for the report.

We have tested few scenarios by selecting only the date columns in the data set and then generating the XML but these were not displayin in the XML.

there is no problem with the SQL as this is working fine in the Tearadata Client when executed( we are able to see the DATE Columns and also the data in it) we also tried by removing the conditions that were put on these date columns but that doest not display these in the Generate XML.

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