<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Joeyoung Oracle Application Blog]]></title><description><![CDATA[You will never win if you never begin]]></description><link>https://blog.youkuaiyun.com/qiaobin911</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qiaobin911]]></copyright><item><title><![CDATA[恢复Win 11右键经典菜单]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/139505332</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/139505332</guid><author>qiaobin911</author><pubDate>Thu, 06 Jun 2024 17:11:29 +0800</pubDate><description><![CDATA[【代码】恢复Win 11右键经典菜单。]]></description><category></category></item><item><title><![CDATA[R12.1.3 ATP Data Collection requests failed]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/78477979</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/78477979</guid><author>qiaobin911</author><pubDate>Wed, 08 Nov 2017 14:13:08 +0800</pubDate><description><![CDATA[Our Oracle EBS instance was moved to Oracle Exadata. After that, nearly all the
ATP Data Collection requests failed. 

RDBMS : 12.1.0.2.0
Oracle Application]]></description><category></category></item><item><title><![CDATA[R12.2 User Management Roles]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/78227533</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/78227533</guid><author>qiaobin911</author><pubDate>Fri, 13 Oct 2017 16:27:41 +0800</pubDate><description><![CDATA[1. Security Administrator

在R12.2里，给用户添加了User Management这个职责，发现不能用。 切换到User Management后，查询不到任何用户。需要使用SYSADMIN给该用户添加一个role: Security Administrator.

Security Administrators manage all user accounts in ...]]></description><category></category></item><item><title><![CDATA[INV DEBUG: How to get Debug Information for Inventory Material Transactions]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/78130493</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/78130493</guid><author>qiaobin911</author><pubDate>Fri, 29 Sep 2017 09:32:20 +0800</pubDate><description><![CDATA[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: Yes
INV]]></description><category></category></item><item><title><![CDATA[How to Turn On “About This Page” in Oracle R12 OAF Pages]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/77850360</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/77850360</guid><author>qiaobin911</author><pubDate>Tue, 05 Sep 2017 13:22:36 +0800</pubDate><description><![CDATA[Set Following Profile Options as Required at User or Site (System Administrator -&amp;gt; profile)

1. Personalize Self-Service Defn = YES --(NO)
2. FND: Personalization Region Link Enabled = YES --(Minim...]]></description><category></category></item><item><title><![CDATA[APP-ONT-251851: Entered Hold Criteria Combination Is Not Valid Across Operating Units.]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/77840011</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/77840011</guid><author>qiaobin911</author><pubDate>Mon, 04 Sep 2017 17:52:33 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[Schedule Order Lines with Auto Reservation]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/77750136</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/77750136</guid><author>qiaobin911</author><pubDate>Thu, 31 Aug 2017 17:50:27 +0800</pubDate><description><![CDATA[在R12里Schedule订单行时，需要自动Reserve Item或者不自动Reserve Item。
具体设置如下：（好多文档上提到了第1步和第2步，没有提第3步）

1. 设置Item的Inventory属性Reservable,  Inventory -> Items -> Master Item    

2. 设置OM System Parameters -> Values -> Reservation Time Fence
Time(in days). If the schedule date]]></description><category></category></item><item><title><![CDATA[for-each@section oracle.apps.xdo.template.fo.area.PageNumber.formatString(PageNumber.java:104)]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/8621737</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/8621737</guid><author>qiaobin911</author><pubDate>Thu, 28 Feb 2013 13:55:15 +0800</pubDate><description><![CDATA[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.NullPointerException
at oracl]]></description><category></category></item><item><title><![CDATA[关于INVENTORY里的INTERFACE MANAGER]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/8190246</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/8190246</guid><author>qiaobin911</author><pubDate>Fri, 16 Nov 2012 11:52:26 +0800</pubDate><description><![CDATA[EBS里的Concurrent Manager实际上也是一个request的程序，而且如果 Request Define的类型是immediately的类型的话，一定要运行在manager中，这个是因为immediately类型的程序需要调用特定的库来执行的。其中interface manager里的程序就是其中的典型，因为他们都需要调用一个INVLIBR的库.

在interface man]]></description><category></category></item><item><title><![CDATA[Can't see Move Orders Created by other users]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/8186627</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/8186627</guid><author>qiaobin911</author><pubDate>Thu, 15 Nov 2012 13:56:57 +0800</pubDate><description><![CDATA[Can’t see Move Orders Created by other users
EBS 11i, Inventory, Move Order,Created By
ref Metalink : 280131.1
A. Define the INV_INVTOMAI_CREATOR function if is does not already exist:
Navigate: S]]></description><category></category></item><item><title><![CDATA[alter session nls_language nls_date_language]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/8186607</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/8186607</guid><author>qiaobin911</author><pubDate>Thu, 15 Nov 2012 13:53:25 +0800</pubDate><description><![CDATA[alter session, nls_language, nls_date_language,
AMERICAN, SIMPLIFIED CHINESE
-- set language
alter session set nls_language ='AMERICAN';
alter session set nls_language = 'SIMPLIFIED CHINESE';

-- se]]></description><category></category></item><item><title><![CDATA[Oracle数据库锁表]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/8186540</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/8186540</guid><author>qiaobin911</author><pubDate>Thu, 15 Nov 2012 13:39:38 +0800</pubDate><description><![CDATA[查看Oracle数据库被锁住的表，并删除锁表的进程


--1.查看被锁住的表
SELECT dob.object_name table_name,
       lo.locked_mode,
       lo.session_id   sid,
       vss.serial#,
       vss.action      action,
       vss.osuser      ...]]></description><category></category></item><item><title><![CDATA[Oracle Workflow异常 ORA-04068: ORA-04061: ORA-04065: ORA-06508 解决办法 （二）]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/6406949</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/6406949</guid><author>qiaobin911</author><pubDate>Mon, 09 May 2011 16:49:00 +0800</pubDate><description><![CDATA[When attempting to approve Purchase Orders via Email an error occurs during the activity 'Notify
Approver Subprocess/Approve PO Notification'. It shows the following Errored Activities:
ERROR
Activ]]></description><category></category></item><item><title><![CDATA[Oracle异常 ORA-04068: ORA-04061: ORA-04065: ORA-06508 解决办法 （一）]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/6406908</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/6406908</guid><author>qiaobin911</author><pubDate>Mon, 09 May 2011 16:37:00 +0800</pubDate><description><![CDATA[下面是Oracle中非常常见的异常，应该如何解决呢？
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "pkg_b.func_c" has been invalidated
ORA-04065: not executed, altered or dropped package "pkg_b.func_c"
ORA-06508: PL/SQL: could not]]></description><category></category></item><item><title><![CDATA[ORACLE EBS 组织架构介绍]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/6307605</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/6307605</guid><author>qiaobin911</author><pubDate>Thu, 07 Apr 2011 17:51:00 +0800</pubDate><description><![CDATA[<br />ORACLE EBS 组织架构介绍<br /> <br />http://blog.youkuaiyun.com/yy5512/archive/2009/12/10/4979512.aspx]]></description><category></category></item><item><title><![CDATA[EBS 11i 设置Oraganization Access]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/6307508</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/6307508</guid><author>qiaobin911</author><pubDate>Thu, 07 Apr 2011 17:13:00 +0800</pubDate><description><![CDATA[在"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]]></description><category></category></item><item><title><![CDATA[XML Publisher预览时报错：Error No: 53 Description: File not found]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/6301069</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/6301069</guid><author>qiaobin911</author><pubDate>Mon, 04 Apr 2011 10:36:00 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[REP-0788: Warning: The value of restricted LOV parameter P_OU_ID is not among the selectable values.]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/6301061</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/6301061</guid><author>qiaobin911</author><pubDate>Mon, 04 Apr 2011 10:29:00 +0800</pubDate><description><![CDATA[在ebs中执行报表，User Parameter报错：REP-0788: Warning: The value of restricted LOV parameter P_OU_ID is not among the selectable values.]]></description><category></category></item><item><title><![CDATA[PL/SQL中‘’（空串）与Null的区别]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/4453152</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/4453152</guid><author>qiaobin911</author><pubDate>Sun, 16 Aug 2009 18:01:00 +0800</pubDate><description><![CDATA[大家对Java中空字符串与null的区别早已是耳熟能详。那么在PL/SQL中，这二者又有何区别呢？
简单地来说，我们可以认为空字符串‘’等价于Null：即‘’is null。 
二者的比较实际上涉及的是PL/SQL中Boolean值的问题。
PL/SQL中Boolean类型的值有3种：TRUE, FALSE, NULL。
NULL用来表示一个错误的，不合适的或者不确定的值。
Boolea]]></description><category></category></item><item><title><![CDATA[PL/SQL 小写金额转化成大写（汉字）]]></title><link>https://blog.youkuaiyun.com/qiaobin911/article/details/4138124</link><guid>https://blog.youkuaiyun.com/qiaobin911/article/details/4138124</guid><author>qiaobin911</author><pubDate>Wed, 29 Apr 2009 23:11:00 +0800</pubDate><description><![CDATA[ CREATE OR REPLACE FUNCTION convert(p_money IN NUMBER)RETURN VARCHAR2 IS   TYPE myArray IS TABLE OF VARCHAR2(255);   n_str      myArray := myArray(壹, 贰, 叁,  肆,  伍,  陆,  柒, 捌, 玖]]></description><category></category></item></channel></rss>