问题1. 您无权访问加载流程
WebADI加载数据时报错:您无权访问加载流程。请与系统管理员联系,以便为您授予对所使用责任的访问权限
Solution:切换职责“桌面集成”后再试下加载
问题2. PER PER_289866_ADI_CONT_COL_FAIL(ID 1958060.1)
WebADI加载数据时验证报错:PER PER_289866_ADI_CONT_COL_FAIL : 出错并且未创建集成器内容列。请检查输入值并重试。
Solution: Execute API(Fnd_Dictionary_Pkg.UploadView) to load view into FND_VIEWS and API (Fnd_Dictionary_Pkg.UploadViewColumn) to load columns into FND_VIEW_COLUMNS.
Sample script:
declare
view_name varchar2(100) := 'CUX_WEBADI_DEMO_V'; -- Provide view name here
appl_short_name varchar2(50) := 'CUST'; --- Provide application short name here
view_text clob := NULL ; --- Provide the view text here or pass null
view_descr varchar2(240) := 'Description'; --- pls provide the view description here
cursor col_curs is
select (rownum*5) seq, COLUMN_NAME from all_tab_columns where TABLE_NAME = view_name;
begin
Fnd_Dictionary_Pkg.UploadView(appl_short_name,view_name,view_text,view_descr,'ORACLE12.2.8');
for i in col_curs loop
Fnd_Dictionary_Pkg.UploadViewColumn(appl_short_name,view_name,i.column_name,i.seq,'ORACLE12.2.8');
end loop;
commit;
exception when others then
dbms_output.put_line(dbms_utility.format_error_backtrace);
end;
问题3. 没有定义参数权限
打开WebADI创建参数页面时提示 无权限的错误,但是其它三个页面都是可以进入的。
Solution: 需要添加 ‘Application Developer\应用开发员\應用模組開發人員’ 职责权限