- 博客(21)
- 资源 (6)
- 收藏
- 关注
RSS订阅原创 R12.1.3 ATP Data Collection requests failed
Our Oracle EBS instance was moved to Oracle Exadata. After that, nearly all theATP Data Collection requests failed. RDBMS : 12.1.0.2.0Oracle Application
2017-11-08 14:13:08
500
1
原创 R12.2 User Management Roles
1. Security Administrator在R12.2里，给用户添加了User Management这个职责，发现不能用。 切换到User Management后，查询不到任何用户。需要使用SYSADMIN给该用户添加一个role: Security Administrator.Security Administrators manage all user accounts in ...
2017-10-13 16:27:41
467
转载 INV DEBUG: How to get Debug Information for Inventory Material Transactions
Summary: The inventory debug profiles are found searching on INV%ebug% including "INV: Debug Trace", "INV:Debug Level", and "INV: Debug file". Here is an example of the common inventory debug profile settings that you might make:INV: Debug Trace: YesINV
2017-09-29 09:32:20
616
转载 How to Turn On “About This Page” in Oracle R12 OAF Pages
Set Following Profile Options as Required at User or Site (System Administrator -> profile)1. Personalize Self-Service Defn = YES --(NO)2. FND: Personalization Region Link Enabled = YES --(Minim...
2017-09-05 13:22:36
480
原创 APP-ONT-251851: Entered Hold Criteria Combination Is Not Valid Across Operating Units.
APP-ONT-251851: Entered Hold Criteria Combination Is Not Valid Across Operating Units. When a Single OU Is Defined (Doc ID 2080013.1)Applies to:Oracle Order Management - Version 12.1.3 and
2017-09-04 17:52:33
508
原创 Schedule Order Lines with Auto Reservation
在R12里Schedule订单行时，需要自动Reserve Item或者不自动Reserve Item。具体设置如下：（好多文档上提到了第1步和第2步，没有提第3步）1. 设置Item的Inventory属性Reservable, Inventory -> Items -> Master Item 2. 设置OM System Parameters -> Values -> Reservation Time FenceTime(in days). If the schedule date
2017-08-31 17:50:27
457
原创 for-each@section oracle.apps.xdo.template.fo.area.PageNumber.formatString(PageNumber.java:104)
XML Publisher template Error: for-each@section:G_PO_HEADER while count(G_PO_HEADER) = 0:Exception:oracle.apps.xdo.batch.BurstingProcessorEngine][EXCEPTION] java.lang.NullPointerExceptionat oracl
2013-02-28 13:55:15
367
转载 关于INVENTORY里的INTERFACE MANAGER
EBS里的Concurrent Manager实际上也是一个request的程序，而且如果 Request Define的类型是immediately的类型的话，一定要运行在manager中，这个是因为immediately类型的程序需要调用特定的库来执行的。其中interface manager里的程序就是其中的典型，因为他们都需要调用一个INVLIBR的库.在interface man
2012-11-16 11:52:26
552
转载 Can't see Move Orders Created by other users
Can’t see Move Orders Created by other usersEBS 11i, Inventory, Move Order,Created Byref Metalink : 280131.1A. Define the INV_INVTOMAI_CREATOR function if is does not already exist:Navigate: S
2012-11-15 13:56:57
366
原创 alter session nls_language nls_date_language
alter session, nls_language, nls_date_language,AMERICAN, SIMPLIFIED CHINESE-- set languagealter session set nls_language ='AMERICAN';alter session set nls_language = 'SIMPLIFIED CHINESE';-- se
2012-11-15 13:53:25
618
原创 Oracle数据库锁表
查看Oracle数据库被锁住的表，并删除锁表的进程--1.查看被锁住的表SELECT dob.object_name table_name, lo.locked_mode, lo.session_id sid, vss.serial#, vss.action action, vss.osuser ...
2012-11-15 13:39:38
315
转载 Oracle Workflow异常 ORA-04068: ORA-04061: ORA-04065: ORA-06508 解决办法 （二）
When attempting to approve Purchase Orders via Email an error occurs during the activity 'NotifyApprover Subprocess/Approve PO Notification'. It shows the following Errored Activities:ERRORActiv
2011-05-09 16:49:00
2259
转载 Oracle异常 ORA-04068: ORA-04061: ORA-04065: ORA-06508 解决办法 （一）
下面是Oracle中非常常见的异常，应该如何解决呢？ORA-04068: existing state of packages has been discardedORA-04061: existing state of package "pkg_b.func_c" has been invalidatedORA-04065: not executed, altered or dropped package "pkg_b.func_c"ORA-06508: PL/SQL: could not
2011-05-09 16:37:00
3316
转载 ORACLE EBS 组织架构介绍
<br />ORACLE EBS 组织架构介绍<br /> <br />http://blog.youkuaiyun.com/yy5512/archive/2009/12/10/4979512.aspx
2011-04-07 17:51:00
577
原创 EBS 11i 设置Oraganization Access
在"Inventory, Vision Distribution (SNG)"职责下，设置了Oraganization Access后，在Change Organization中，可选择的Organization远远大于Oraganization Access中添加的Organization。这是为什么呢？Attention: Until you assign an organization to a responsibility inthis window, all responsibilities ha
2011-04-07 17:13:00
475
原创 XML Publisher预览时报错：Error No: 53 Description: File not found
XML Publisher预览时报错：Error No: 53 Description: File not found解决办法：(选择电脑上的java home)Go to XML Publisher menu in Word.Tools - > options -> preview tab.Java home should be selected there, if
2011-04-04 10:36:00
1454
原创 REP-0788: Warning: The value of restricted LOV parameter P_OU_ID is not among the selectable values.
在ebs中执行报表，User Parameter报错：REP-0788: Warning: The value of restricted LOV parameter P_OU_ID is not among the selectable values.
2011-04-04 10:29:00
1495
原创 PL/SQL中‘’（空串）与Null的区别
大家对Java中空字符串与null的区别早已是耳熟能详。那么在PL/SQL中，这二者又有何区别呢？简单地来说，我们可以认为空字符串‘’等价于Null：即‘’is null。 二者的比较实际上涉及的是PL/SQL中Boolean值的问题。PL/SQL中Boolean类型的值有3种：TRUE, FALSE, NULL。NULL用来表示一个错误的，不合适的或者不确定的值。Boolea
2009-08-16 18:01:00
1991
原创 PL/SQL 小写金额转化成大写（汉字）
CREATE OR REPLACE FUNCTION convert(p_money IN NUMBER)RETURN VARCHAR2 IS TYPE myArray IS TABLE OF VARCHAR2(255); n_str myArray := myArray(壹, 贰, 叁, 肆, 伍, 陆, 柒, 捌, 玖
2009-04-29 23:11:00
937
原创 用SimpleDateFormat类设置时间格式
String[] formatArr = {"", "yyyy", "yyyy-MM", //必须为大写MM "yyyy年MM月", "yyyy-MM-dd", "yyyy年MM月dd日", "yyyy-MM-dd HH:mm:ss", //HH为24小时格式 "yyyy-MM-dd hh:mm:ss", //hh为12小时格式 "yy
2008-10-01 15:30:00
541
JaWE1.4安装程序
2008-07-12
JaWE-1.4学习指南
2007-11-16
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人