我在哪里可以找到我在 Oracle EBS R12 的 XML Publisher 中上传的 .rtf 位置?我只是想知道我发布的所有 rtf 的位置? [英] Where I can find the .rtf locations I uploaded in XML Publisher of Oracle EBS R12? I just wanted to know the locations of all the rtf I published?

问题描述

在哪里可以找到我在 Oracle EBS R12 的 XML Publisher 中上传的 .rtf 位置?我只是想知道我发布的所有 rtf 的位置?

Where I can find the .rtf locations I uploaded in XML Publisher of Oracle EBS R12? I just wanted to know the locations of all the rtf I published?

请告诉我linux的命令，通过它我可以知道..或任何东西

Please tell me the command of linux through which i can know..or anything

推荐答案

BI Publisher .rtf 模板未上传到操作系统级别，它们作为 blob 存储在 DB 表 xdo_lobs.file_data 中，如下所示(请参阅 Blitz Report 中的完整查询 XDO 发布者数据源)

BI Publisher .rtf templates are not uploaded to OS level, they are stored as blobs in DB table xdo_lobs.file_data as below (see full query in Blitz Report XDO Publisher Datasources)

select
xtv.template_name,
xtv.template_code,
(
select
xl.file_name
from
xdo_lobs xl
where
xtv.template_code=xl.lob_code and
xtv.application_short_name=xl.application_short_name and
(
(
xl.lob_type='TEMPLATE' and
xl.xdo_file_type<>'RTF' and
xtv.template_type_code=xl.xdo_file_type
or
xl.lob_type='TEMPLATE_SOURCE' and
xl.xdo_file_type in ('RTF','RTF-ETEXT')
) and
xtv.default_language=xl.language and
xtv.default_territory=xl.territory
or
xl.lob_type='TEMPLATE_SOURCE' and
xl.xdo_file_type='RTF' and
xtv.mls_language=xl.language and
xtv.mls_territory=xl.territory and
exists (
select null from xdo_lobs xl2
where xl2.lob_type='MLS_TEMPLATE' and
xtv.application_short_name=xl2.application_short_name and
xtv.template_code=xl2.lob_code and
xtv.default_language=xl2.language and
xtv.default_territory=xl2.territory) and
not exists (
select null from xdo_lobs xl3
where
xl3.lob_type='TEMPLATE_SOURCE' and
xtv.application_short_name=xl3.application_short_name and
xtv.template_code=xl3.lob_code and
xtv.default_language=xl3.language and
xtv.default_territory=xl3.territory)
)
) default_template_file,
(select xl.file_name from xdo_lobs xl where xl.lob_type='TEMPLATE_SOURCE' and xtv.application_short_name=xl.application_short_name and xtv.template_code=xl.lob_code and xtv.mls_language=xl.language and xtv.mls_territory=xl.territory) mls_template_file
from
xdo_templates_vl xtv

如果您想将它们视为 clob，您需要一个类似 xxen_util.blob_to_clob 的函数.

If you want to see them as clob, you need a function like xxen_util.blob_to_clob.

select
xl.lob_type,
xl.application_short_name,
xl.lob_code,
xl.file_name,
xl.language,
xl.territory,
xxen_util.blob_to_clob(xl.file_data) file_clob
from
xdo_lobs xl
where
xl.file_name like '%.rtf' and
xl.lob_type in ('TEMPLATE','TEMPLATE_SOURCE')

这篇关于我在哪里可以找到我在 Oracle EBS R12 的 XML Publisher 中上传的 .rtf 位置?我只是想知道我发布的所有 rtf 的位置?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！