ITPub博客

• Personalize Self-Service Defn– Yes to allow ‘Personalize’ button to appear at the top of the page • FND: Personalization Region Link Enabled – Yes to display all the regional links above each region – Minimal to display key regional links • Disable Self-Service Personal – Yes will disable all personalizations at any level • FND: Diagnostics – Turns on ‘About this Page’ • FND: Personalization Document Root Path (new in 11.5.10) – Required to migrate pers

In this post, I tried to explain the example implementation of a Zoom Functionality in R12[@more@]Instance: R12.1.1Requirement: 1. Add an option named “Responsibility Details” to Tools Menu of the “APPLICATION USERS” Form.2. By clicking the option said in requirement 1, the user must be able view the complete details of the selected responsibility via “DEFINE: RESPONSIBILITIES” forms 3. Independent Functionalities of “USERS” and “RESPONSIBILITIES” FORM should not

Within Oracle R12 it’s possible to Personalize Self-Service pages. To enable this option you need to set the the following profile options at user level.Personalize Self-Service DefnFND: Personalization Region Link EnabledAfter setting the above profile options you can see now different region links which you can click on and do personalization for. You can undo all personalization from the same region link on the self-serivce page. But with personalization it’s possibleto unhide a

1. 图片尺寸大小，不可以大于40K。2.用report builder的话，里面编码要选UTF8.3. 对于要显示的图片，不可以做为公式列，因为类型无法选择Character LOB.4. 对于这个图片栏位的属性，File format须选定Text. 而不能是Image.5.需要自定义一个函数，把BLOB类型转成CLOB.DBMS_LOB.createtemporary(lob_loc => l_result, CACHE => FALSE,dur => 0);Wf_Mail_Util.EncodeBLOB ( P_blob, l_result);[@more@]

INV_Quantity_Tree_PUBHow does one check onhand quantity levels with PL/SQL?This script will provide snapshot for stock(material) for Item in an Organization / Subinventory. The script output will provide details with the following results:TitleExplanationQuantity on handOnhand Quantity for the ItemQuantity res ohReservable Quantity On handQuantity resQuantity reservedQuantity sugQuantity SuggestedQuantity ATTAvailable To TransactQuantity ATRAvailable To ReserveNote : Do not enter input parameter

9i的bug，10g后才ok，plsql dev编译package报600错误。ORA-0600 error with arguments: [17113].ORA-0600 error with arguments: [17113].You may be getting this ORA-600 when recompiling a PL/SQL package.The Package shows in OEM as valid even though compiling gives ORA-600 error.You can reproduce the error when a PL/SQL package is in an editor in the PL/SQL developer tooland you select Compile. But if the package is selected to compile from the window"navigator" - it compiles successfully.The a

操作系统：AIX 6.1 数据库环境：RAC 10.2.0.52011/10 /08 16:33左右，节点1出现的ORA-00600错误，产生dump文件为5M多的 zgscdb1_ora_26739166.trc ，2011/10/09 15:43左右，节点二出现ORA-00600错误，dump文件为 159K的zgscdb2_ora_35651868.trc节点1：这个错误是由于取消当前操作所引发。Sat Oct 08 16:33:46 GMT+08:00 2011Errors in file /oracle10g/app/oracle/admin/zgscdb/udump/zgscdb1_ora_26739166.trc:ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], []ORA-00604: error occurred at recur

Issue: after the R12 upgrade i'm trying to do a help--diagnostics--examine or help--diagnostics--custom code--personalize from any form and it gives the error "function not available to this responsibility".[@more@]Solution:- Log in as System Administrator- Choose Profile/System- Find profile "Utilities:Diagnostics" and change it's value to "Yes".