新浪博客

OracleEBS提交请求时使用FND_REQUEST.ADD_LAYOUT加载模版

2025-10-20 15:13阅读:
Oracle EBS提交请求时使用FND_REQUEST.ADD_LAYOUT加载模版
Oracle EBS提交请求时使用FND_REQUEST.ADD_LAYOUT加载模版
如何在通过PL/SQL过程提交并发请求时使用FND_REQUEST.ADD_LAYOUT?
随着Bi Publisher(原XML Publisher)处理作为并发程序的选项加入,FNDRSRUN表单上新增了一个用于模板的字段。当使用标准提交方式提交并发程序时,该字段默认会被填充。
当使用 PL/SQL 提交需要 Bi Publisher 版式模板的单个并发请求时,必须在提交并发程序前调用 API FND_SUBMIT.ADD_LAYOUT。
若使用 API FND_SUBMIT 提交请求集,则应使用 FND_SUBMIT.ADD_LAYOUT 替代 FND_REQUEST.ADD_LAYOUT。
解决办法
Modify your PL/SQL procedure to add a line similar to xml_layout:
1. First you must declare the variable
xml_layout boolean;
2. Then you must call the ADD_LAYOUT API prior to submitting your Concurrent Program.
xml_layout := FND_REQUEST.ADD_LAYOUT('FND','FNDSCURS','en','US','PDF');
req_id := FND_REQUEST.SUBMIT_REQUEST('FND','FNDSCURS','FNDSUBMIT - Active Users
XML');
Note: The easiest way to find out the parameters for the ADD_LAYOUT API is to run the concurrent program from standard
submission then check the OPP
Manager log for the parameters after a successful submission.
i.e. From $APPLCSF/$APPLLOG/FNDOPP10367.txt
[5/10/05 12:08:13 PM] [10367:RT239207] Starting XML Publisher post-processing action.
[5/10/05 12:08:13 PM] [10367:RT239207]
Template code: FNDSCURS
Template app: FND
Language: en
Territory: US
Output type: PDF
[5/10/05 12:08:14 PM] [10367:RT239207] XML Publisher post-processing action complete.
[5/10/05 12:08:14 PM] [10367:RT239207] Completed post-processing actions for request 239207.
The syntax of the ADD_LAYOUT is as follows:
-- Name
-- add_layout
-- Purpose
-- Called before submission to add layout options for request output.
-
-- Arguments
-- Template_APPL_Name - Template Application Short name.
-- Template_code - Template code
-- Template_Language - Template File language (iso value)
-- Template_Territory - Template File Territory (iso value)
-- Output Format - Output Format
-
function add_layout (template_appl_name in varchar2,
template_code in varchar2,
template_language in varchar2,
template_territory in varchar2,
output_format in varchar2) return boolean;
-- 刘轶鹤

我的更多文章

下载客户端阅读体验更佳

APP专享