orapeasant-CSDN博客

原创 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 936

原创 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 1646

原创 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 10062

原创 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 1395

原创 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 3559

转载 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 4661

原创 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 1323

原创 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 899

原创 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 843

原创 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 899

原创 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 1092

原创 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 733

转载 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 713

原创 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 926

原创 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 1886

转载 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 871

转载 XDB: XML DB Port Assignments

2008-11-20 07:29:00 1173

原创 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 611

原创 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 2773

原创 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 921 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 3278

原创 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 2987

原创 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 801

原创 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 625

原创 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 943

原创 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 552

原创 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 639

原创 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 562

原创 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 520

原创 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 875

原创 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 613

原创 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 8651

原创 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 748

原创 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 1890

原创 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 1007

原创 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 1170

原创 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 745

原创 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 771

原创 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 925

原创 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 5826

空空如也

空空如也