- 博客(124)
- 收藏
- 关注
原创 Configure form 6i and form services to work under XDB http listener of 10gEX
In Oracle 10gEX, it supports HTTP and FTP internet protocal through XDB. So how about configuring XDB http listener to work with Oracle form/report 6i? I tried it successfully before solving followin
2009-01-12 16:41:00 958
原创 Form 6i cannot connect to 10gR2 or 10gXe due to character set issue
Form 6i or sqlplus reports ora805.dll and access violation error and crash immediately. This is because of the character set of 10g is in AL32UTF8, need to be changed to UTF8, do following in sqlplu
2009-01-12 16:34:00 1664
原创 Using Oracle XML DB Repository as a Filesystem
DBA: XML Using Oracle XML DB Repository as a Filesystemby Yuli Vasiliev Learn how to manage XML content stored in Oracle XML DB, whether you use SQL or not. Downloads for this article:·
2009-01-12 15:54:00 10097
原创 OM:Manual Transaction in work flow
In Order management, sometimes, we need to progress order, one example is Schedule - Eligible. How is this implemented in Workflow? Basically, in Oracle workflow builder, we can see order goes to "
2009-01-02 15:49:00 1411
原创 How to enable USB selective suspend and system wake in the UMDF driver for a USB device
How to enable USB selective suspend and system wake in the UMDF driver for a USB device http://blogs.msdn.com/peterwie/archive/2007/03/28/how-to-enable-usb-selective-suspend-and-system-wake-in-the-um
2008-12-31 08:58:00 3605
转载 OM:Defaulting Rules using PLSQL APIs
Defaulting Rules using PLSQL APIs http://blog.oraclecontractors.com/?p=310 Order Management provides the ability to default a number of attributes onto the Sales Order Header and Lines based u
2008-12-18 14:33:00 4699
原创 APPS:How to view the concurrent request output of other users
Basicaly, as Oracle documents, we can profile option "Concurrent:Report Access Level" to Responsiblity instead of default value User, then , user can view the request output of other users login as
2008-12-17 09:25:00 1335
原创 APPS:Bother, why password reuse is not allowed
In our dev/testing system, it requires to use different password each time changing password. This check is done in FND_WEB_SEC package, it checks fnd_user_preferences table using following sql:fnd_
2008-12-09 14:53:00 918
原创 DW: Some useful system views when checking Materialized View
1. dba_mview_refresh_times/user_mview_refresh_timesThis view lists the master table, mv and the last refresh time. When mv are fast refresh mv, the mv log will be purged only when all the mvs are re
2008-12-05 13:58:00 853
原创 FND:How to create a link in IE favorite to directly login into apps
Im lazy to type username and password whenever I open my testing 11i system. So I simply check the html source of the login page and get the submit detail of the login button, then following url can
2008-12-03 14:07:00 911
原创 QP:Error in formula process...
This error annoyed me for a whole week. We have only one formula set up in 2004, and there are a modifier for different OU, how come the error never occured these years. The formula has 2 steps 1 and
2008-11-28 17:31:00 1119
原创 APEX: Some good web sites about APEX
1. Patrick Wolf in Germanyhttp://www.inside-oracle-apex.com 2. Don Burlsons page about making tree pagehttp://www.oracle-training.cc/t_easy_html_db_trees.htm 3. Oracles page about tree
2008-11-24 18:06:00 751
转载 Oracle数据库联机日志文件丢失处理方法
Oracle数据库联机日志文件丢失处理方法 试验一:用命令清空日志组方法 1、 查看原来表中数据 SQL>; conn test/test Connected. SQL>; select * from test; TEL ---------- 1 2 3 2、插入新数据 SQL>; insert into test values(
2008-11-24 11:03:00 750
原创 XDB:How to change XDB in XE to enable remote listener.
To enable XDB to listen on remote listener, use following:exec DBMS_XDB.setListenerEndPoint(1,hostname,8080,1); To enable XDB to listen on local listener only, use following:exec DBMS_
2008-11-20 13:29:00 938
原创 XDB: Utility package to change the HTTP and FTP ports used by XML DB.
XDB: Utility package to change the HTTP and FTP ports used by XML DB. Doc ID: Note:209564.1Type: BULLETIN Last Revision Date: 22-JUL-2008Status: PUBLISHEDIn this Doc
2008-11-20 07:34:00 1898
转载 XDB: Utility package to change the HTTP and FTP ports used by XML DB
Subject: How to Add LOCAL_LISTENER or REMOTE_LISTENER Entry to OID Doc ID: Note:602322.1Type: HOWTO Last Revision Date: 03-NOV-2008Status: PUBLISHEDIn this Documen
2008-11-20 07:33:00 884
转载 XDB: XML DB Port Assignments
XML DB Port Assignments by Jeff Hunter, Sr. Database Administrator Portions of this article are written by Roby Sherman and Copyright 2002 http://www.idevelopment.info/data/Oracle/DBA_tips/xmldb
2008-11-20 07:29:00 1186
原创 SQL: How to get a series of dates in sql using connect by
Following sql can return a series of dates later than today. select trunc(sysdate) +rownum dt from dual connect by rownum
2008-11-14 09:15:00 621
原创 How "Copy File" works in 'View Output" screen in Oracle Apps
Usualy, when we submit a concurrent report and it finishes running, we click Output button to view the output and click Tools->Copy file to copy it to browser window and thus save to local disk.
2008-11-11 13:42:00 2812
原创 Several interesting packages in Oracle apps
select distinct name from all_source where name LIKE ORACLE% wfa_html BIS_RG_SCHEDULER_PVT
2008-11-07 14:32:00 958 1
原创 OM: Good informational package in OM: OE_MSG_PUB
Last week I started to working on an order import pragram. A sample program in our live system does similar thing but it has no price adjustment etc. To have more information when importing the order,
2008-11-04 09:47:00 3298
原创 OM: Order Import using OE_ORDER_PUB.PROCESS_ORDER
This article discusses som tips in importing sales order using oe_order_pub.process_order. The example is to import sales order with price adjustment.1. to update price_adjustments, the existing pri
2008-11-04 09:37:00 3003
原创 How to constraint user processing but allow API when processing constraints are enabled
Last week, our functional guy raised a requirement, our price in sales order should only be modified by a customized interface, user are not allowed to change price. The functional guy created a proce
2008-11-02 08:57:00 815
原创 Listening power made easy.
Recently I came across some good site for English listening training. 1. www.putclub.comThis is somewhat like a English learning portal, specialized in listening training though. The name cames fr
2008-10-28 11:41:00 641
原创 Is it a 32bit or 64 bit system?
Today I saw a thread talking about how to check a system is 32bit and 64bit. According to the thread, it seems there are two different concept about system bit. One is the OS the other is machine. Bas
2008-10-20 16:39:00 960
原创 how to convert OEL5 5 installation CDs into 1 DVD.
1.Simply extract all of the contents from cd1-cd5 to a given directory,next,export that directory by a nfs/http service to support a pvm installation.2.As dyno commented,burn these several CDs to a dv
2008-10-17 00:06:00 566
原创 Interesting URLs in Oracle Application 11i.
:/servlets/oracle.apps.icx.common.SystemInfoTest">http://:/servlets/oracle.apps.icx.common.SystemInfoTest:/servlets/IsItWorking">http://:/servlets/IsItWorking:/servlets/oracle.apps.icx.common.Connect
2008-10-16 18:43:00 653
原创 Steps to enable adding packages from DVD for Oracle Enterprise Linux 5
1. mount -o loop rhel-5-server-dvd.iso /media/rhel2. vi /etc/yum.repos.d/local.repo[Cluster]name=Oracle Enterprise Linux $releasever - $basearch - Clusterbaseurl=file:///mnt/cdrom/Clusterenabled=1
2008-10-16 18:41:00 576
原创 Index organized table and redo log it genereates
Today, OPS team raised an issue related to a program using IOT. The program generated too many archive logs thus it took more time to FTP archive logs to our DR server and apply them. 1~4 hours lag we
2008-10-14 13:30:00 529
原创 Note: In form builder, triggers 'execution hierarchy' caused funny issue in enter-query mode.
Today, Im almost tortured by the weird form behavior in enter-query mode in one of my custom forms. Yesterday, I dont remeber exactly when, the block could still turn to light-blue when I hit F11
2008-10-10 18:17:00 888
原创 Using lp to test report printing in Unix for Apps
Days ago, user requested me to change the layout to fit for her new pre-printed paper. She is in Ireland and thousands kilometers away from Singapore. Theres no way for me to get that pre-printed pap
2008-10-08 19:26:00 625
原创 Production Issue: adjusted_amount_per_pqty column of oe_price_adjustments table contains strange amount
Yesterday user reported they had wrong discount and unit price in one of the SO extraction program. After checking the oe_price_adjustments table, I found adjusted_amount_per_pqty, the column I used t
2008-10-08 15:00:00 8695
原创 CUPS Command Line Interfaces
CUPS Command Line Interfaces You can also simply use the command line to administer the printers. You can add a network printer enable the printer with: # lpad
2008-10-06 17:24:00 764
原创 PRINTING IN LINUX WITH CUPS
PRINTING IN LINUX WITH CUPSBy Robert SpotswoodGeneral Printing TipsUnderstand your printing needs. If you will print mostly text, a laser will give much better quality and cost per page. I
2008-10-06 16:55:00 1913
原创 Production Issue: Drop ship order line workflow issue
Recently I closed a case of troubleshooting work flow issue in a drop ship order line. The order went through an obsolete workflow and get invoiced and closed while some holds exist, which is absolut
2008-10-06 15:22:00 1022
原创 Troubleshooting EPSON dot matrix printing issue in Apps
Recently I encountered an issue to print character report to EPSON LQ2080 dot matrix printer. Wheneven the printer is off and on, in the first print, it prints funny characters at page 7. To figure o
2008-10-06 15:00:00 1187
原创 Setup Oracle Designer
Recently I got an assignment to design a approval and pricing system in Oracle. So I thought of Oracle Designer I used long time ago. I remember it is somewhat a good tool to design ERD etc for applic
2008-09-12 09:53:00 758
原创 Oracle Application Hints and Tips
I came accross following site about oracle application the other day. Quite useful site. http://www.sap-img.com/oracle-database/oracle-application-hints-and-tips.htm
2008-02-01 12:11:00 783
原创 How to remove ^M in a uploaded text file?
In apps, its common that user changes setting of FTP client so that uploaded DOS plain text file contains a ^M at the end of each line. Such ^M usually cause wrong data in table after sqlldr loads it
2008-01-25 17:25:00 931
原创 Modifying BOM using BOM_BO_PUB.PROCESS_BOM
EBS Version: 11.5.8Requirement: User need to disable bom component by uploading a csv file which containing the TOP level assemblies to be disable by adding disable_date to all the components/subassem
2008-01-25 17:15:00 5863
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人