EBS日常运维问题

Oracle计划请求信息

留下评论

SELECT fcp.concurrent_program_name 并发代码,
decode(fcre.description,
NULL,
fcpt.user_concurrent_program_name,
fcre.description || ‘ (‘ || fcpt.user_concurrent_program_name || ‘)’) 请求名称,
fu.user_name 用户名,
conc.request_id 请求ID,
conc.root_request_id 父请求ID,
decode(fcre.status_code,
‘D’,
‘Cancelled’,
‘U’,
‘Disabled’,
‘E’,
‘Error’,
‘M’,
‘No Manager’,
‘R’,
‘Normal’,
‘H’,
‘On Hold’,
‘W’,
‘Paused’,
‘B’,
‘Resuming’,
‘I’,
‘Scheduled’,
‘Q’,
‘Standby’,
‘S’,
‘Suspended’,
‘X’,
‘Terminated’,
‘T’,
‘Terminating’,
‘A’,
‘Waiting’,
‘G’,
‘Warning’) 请求状态,

fcre.argument_text 请求参数,
sche.job_class 计划类型,
sche.class_info 频率

FROM apps.fnd_concurrent_programs fcp,
apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_concurrent_requests fcre,
apps.fnd_user fu,
(SELECT owner_req_id,
date1 start_date,
date2 end_date,
decode(class_type, ‘S’, ‘Specific Days’, ‘P’, ‘Periodically’) job_class,
decode(class_type,
‘P’,
substr(class_info, 1, instr(class_info, ‘:’) – 1) ||
decode(substr(class_info, instr(class_info, ‘:’) + 1, 1),
‘D’,
‘Days’,
‘H’,
‘Hours’,
‘N’,
‘Minutes’,
‘M’,
‘Months’,
‘W’,
‘Weeks’),
‘S’,
class_info) class_info
FROM apps.fnd_conc_release_classes fcr

WHERE class_type IN (‘S’, ‘P’) –Periodically and Specific Concurrent
AND enabled_flag = ‘Y’
AND (date2 IS NULL OR date2 > SYSDATE)
AND owner_req_id IS NOT NULL) sche,

(SELECT MAX(request_id) request_id, root_request_id
FROM apps.fnd_concurrent_requests
WHERE root_request_id IN
(SELECT nvl(root_request_id, request_id) request_id
FROM apps.fnd_concurrent_requests
WHERE request_id IN
(SELECT owner_req_id
FROM apps.fnd_conc_release_classes fcr
WHERE class_type IN (‘S’, ‘P’) –Periodically and Specific Concurrent
AND enabled_flag = ‘Y’
AND (date2 IS NULL OR date2 > SYSDATE)
AND owner_req_id IS NOT NULL)
AND status_code <> ‘D’)
GROUP BY root_request_id) concWHERE fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcpt.language = ‘ZHS’
AND fcp.concurrent_program_id = fcre.concurrent_program_id
AND fcre.status_code NOT IN (‘D’, ‘X’, ‘U’) –Cancelled and Terminated and Disabled
AND fcre.request_id = conc.request_id
AND conc.request_id = sche.owner_req_id
AND fcre.requested_by = fu.user_id

GL模块

Oracle ebs控制科目输入（ADI+人工）方案

留下评论

背景：
客户需要限制某些科目只能从接口进入系统，不能手工及类手工方式录入。

思路：

寻求标准方案；客户化ADI。

标准方案：

先查看科目值集处对科目属性的控制，其中有一个控制项是“第三方控制账户”，控制账户内可选择“限制人工日记帐”（此时想看能否可以选择来源进行控制，于是通过sql方式【select * from fnd_lookups t where t.meaning like ‘%限制人工日记%’】找到控制账户的lookup_type”GL_CONTROL_ACCOUNT_SOURCES”，发现不能新增来源），于是从字面理解是否只会对日记账来源为“人工”的进行控制。

测试结果：前台界面确实控制住不能录入，并弹窗提示“您不能使用控制账户。请选择其他账户”，满足需求。

然后通过ADI导入，无论ADI的来源选择何种，均会提示“您不能使用控制账户。请选择其他账户”，满足需求。

最后通过接口表的方式，通过设置过“限制人工日记账”的科目导入生成账务，可以正常生成日记账，满足需求。

完美解决问题，不再讨论客户化的方式。

技术笔记（小潘的技术记录博客）