Oracle Apps Notes

A collection of my random notes, primarily on Oracle Apps

EBS BI Publisher tables

I faced some issues recently where I had to check the date when the RTF template, data template and bursting control file of a BI Publisher report in Oracle EBS were last updated. The following tables came in handy and I am jotting them down here lest I forget.

  • XDO_TEMPLATES_B – Stores the report template details
  • XDO_DS_DEFINITIONS_B – Stores the data template details
  • XDO_LOBS – Stores the bursting control file details
--template file
select * from apps.xdo_templates_b where template_code = 'Report_Code';
--data template
select * from apps.xdo_ds_definitions_b where data_source_code = 'Report_Code';
--bursting file
select * from apps.xdo_lobs where LOB_CODE = 'Report_Code';
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: