随笔分类 - Oracle EBS
摘要:
阅读全文
摘要:错误:此责任无可用函数。 更改责任或与您的系统管理员联系。 2014-07-02 12:20:47 分类: Oracle Symptom 访问Help->Diagnostics->Examine 报"Function not available to this responsibility.Change responsibilities or contact your System Admini...
阅读全文
摘要:Web Service Error wsse:InvalidSecurity Policy Requires Integrity (Doc ID 1370736.1) Modified: 13-May-2013 Type: PROBLEM In this Document Symptom...
阅读全文
摘要:Configuring Oracle E-Business Suite Integrated SOA Gateway Release 12.1.2 and Release 12.1.3 in a Multinode Environment (Doc ID 1081100.1) Modified: 25-Jul-2014 Type: ...
阅读全文
摘要:Using Load-Balancers with Oracle E-Business Suite Release 12 (Doc ID 380489.1) Modified: 12-Jun-2013 Type: WHITE PAPER Using Load-Balancers with Ora...
阅读全文
摘要:--REQUEST的TRACE文件 SELECT 'Trace Name: ' || DEST.VALUE || '/' || LOWER (DBNM.VALUE) || '_ora_' || ORACLE_PROCESS_ID || '.trc', 'File Name: ' || EXECNAME.EXE...
阅读全文
摘要:--根据描述性弹性域的标题查找描述性弹性域表和列select fnd_dfv.title, fnd_dfv.descriptive_flexfield_name, fnd_dfv.application_table_name, fnd_dfu.application_column_name, fnd_dfu.form_left_prompt, ...
阅读全文
摘要:--查找运行请求时间,参数等(可以是某用户的,某个报表) select c.user_name, papf.full_name, b.user_concurrent_program_name, a.request_date, a.argument_text, (a.actual_completion_date - a.actual_sta...
阅读全文
摘要:--ORACLE PATCH 版本的查询 PL/SQL SELECT DD.PATCH_NAME, PP.CREATION_DATE, PP.DRIVER_FILE_NAME, LANG.LANGUAGE FROM AD_PATCH_DRIVERS PP, AD_APPLIED_PATCHES DD, AD_PATCH_DRI...
阅读全文
摘要:SELECT PRO.PROFILE_OPTION_NAME, PRO.USER_PROFILE_OPTION_NAME, LEV.LEVEL_TYPE TYPE, --lev.level_code, LEV.LEVEL_NAME, PRV.PROFILE_OPTION_VALUE FROM APPS.FND...
阅读全文
摘要:--R12查询EBS在线用户SQL SELECT U.USER_NAME, APP.APPLICATION_SHORT_NAME, FAT.APPLICATION_NAME, FR.RESPONSIBILITY_KEY, FRT.RESPONSIBILITY_NAME, FFF.FUNCTION_NAME, FFT.USER_...
阅读全文
摘要:♡.Oracle EBS(ERP)Oracle 是公司名字,这个我估计大家都知道。EBS是E-Business Suite的缩写,简单的说,就是Oracle做的一个企业级的信息化软件或者系统,里面包含了财务,人力,分销,资产等很多企业用的到的模块。现在主流的就是SAP和Oracle EBS.在EBS 顾问这个行业,粗略的有以下分工。♡.Oracle EBS Function Consultant ...
阅读全文
摘要:如何查看非自己提交的请求的结果定位要找的请求SQL举例:SELECT req.request_id, fcp.user_concurrent_program_name, usr.user_name, req.request_date, trunc(SYSDATE) - trunc(request_date) days, req.logfi...
阅读全文
摘要:In this Document Goal Solution References Applies to: Oracle Application Object Library - Version 11.0.1 to 12.1.3 [Release 11 to 12.1]Information in this document applies to any platf...
阅读全文
摘要:In this Document Goal Fix Downloading Files Uploading Files References Applies to: BI Publisher (formerly XML Publisher) - Version 5.6.3 to 5.6.3 [Release 5]Information...
阅读全文
摘要:In this Document Goal Solution Some Tips About FNDLOAD Some sample examples Diagnostics & Utilities Community: Applies to: Oracle User Management - Version 12.1.3 to 12.1.3 [Release 12.1]Oracle App...
阅读全文
摘要:一.从属值集的定义 1.弹性域中的从属值集的定义 在这里我们以资产模块的资产类别键弹性域为例,假如类别分为大类、小类。 小类的列表内容将依据大类变化。即大类为小类的父集。 我们首先建立2个值集,第一个值集命名为:UC_FAC_MAIN,注意选择验证类型为独立,创建结果如图1-1所示, 图1-1 第二个值集命名为:UC_FAC_MINO,在这里注意和第一个值集创建的区别了(注意:红色方框所标注的内...
阅读全文
摘要:Profile Option Name Site Application Responsibility Server Server Org User Remark Export MIME type text/tab-separated-values tsv Export MIME type application/vnd.ms-excel ...
阅读全文
摘要:Oracle Key Flexfields Qualifiers 1. Application Developer è Flexfield è Key è Register Title: Accounting Flexfield Click button [Find] Click button [Qualifiers] Natural Account Segment...
阅读全文