My Learning

in oracle apps 11i receivables When entering receipt and saving oracle gave this error ORA-01653 : unable to extend table AR.AR_CASH_RECEIPT_HISTORY_ALL BY 1024 in tablespace ARD check for extend management is automatic or manual dba_data_files select autoextensible from dba_data_files where tablespace_name='ARD' it will show yes or no The table was created with size 400M and extend allocation was not automatic so i manually extended 100MB. ALTER DATABASE DATAFILE '/u01/proddata/prod/ard1.dbf' AUTOEXTEND ON MAXSIZE 500M; ALTER DATABASE DATAFILE '/u01/proddata/prod/ard1.dbf' AUTOEXTEND off; SELECT DBMS_METADATA.GET_DDL('TABLESPACE','ARD') FROM DUAL; As this is user managed extend management actually what should have done was either resize or add new datafile. here is how ALTER DATABASE DATAFILE '/u01/proddata/prod/ard1.dbf' RESIZE 500M; ALTER DATABASE ADD DATAFILE '/u01/proddata/prod/ard2.dbf'...

chkconfig --list lists all the services starting at booting with different levels to add a service to start at booting chkconfig --add [service_name] ex: chkconfig -add sshd to add different levels(0,1,2,3,4,5,6) chkconfig --level [levels] [service_name] [service_option>] level: the runlevel where this service has to start (if there are more than one level enter different level without any seperator) service options : on|off|reset|resetpriorities ex: chkconfig --level 2 sshd on chkconfig --level 235 sshd on so to add sshd to start up at booting in 235 levels chkconfig --add sshd chkconfig --level 235 sshd on

Tested on Red Hat Enterprise Linux AS release 4 kernel 2.6.9-5.EL Oracle Enterprise Linux AS release 4 (october update 6) kernel 2.6.9-67.0.0.0.1.EL Required Packages ompat-db-4.1.25-9 compat-gcc-32-3.2.3-47.3 compat-gcc-32-c++-3.2.3-47.3 compat-oracle-rhel4-1.0-5 (from oracle patch 4198954) compat-libcwait-2.0-2 (from oracle patch 4198954) compat-libgcc-296-2.96-132.7.2 compat-libstdc++-296-2.96-132.7.2 compat-libstdc++-33-3.2.3-47.3 xorg-x11-deprecated-libs-devel-6.8.1-23.EL xorg-x11-deprecated-libs-6.8.1-23.EL The following required component must be installed manually: openmotif21-2.1.30-x Domain Name Resolver Parameters add these parameters in the /etc/resolv.con file options attempts:5 options timeout:15 Verify that the /etc/hosts file is formatted as follows 127.0.0.1 localhost.localdomain ip_addrss node_name.domain_name let these loopback entry be there if you want to add a new for your server do it as follows etc: 192.168.1.7 oracle11i.mylearn.com ...

supplier type is coming from a value set that's defined in oracle purchasing look up codes so before you can use any particular supplier type it has to be defined in the values set. To add a new type follow the steps below Purchasing > Set Up > Purchasing > Look up codes search for VENDOR TYPE Add whatever new type you want to add

Tested on fedora 13 First check ssh service is running to check the status of ssh service sshd status or /etc/init.d/ssh status if it is stopped you can not use ssh to start this service issue the follwoing command service sshd start or /etc/init.d/sshd start if you are starting it for the first time you will see these messages on the screen else you will see the last one only, if it starts Generating SSH2 RSA host key: [ OK ] Generating SSH1 RSA host key: [ OK ] Generating SSH2 DSA host key: [ OK ] Starting sshd: [ OK ] now you can use ssh to connect to another host use ssh username@hostname

Requisitions approval history was not updated properly after concerned person has approved requisitions. If you go and check action history the action history was missing latest approval. When investigated found out that workflow finished with an error in “ UPDATE_ACTION_HISTORY_APPROVE ” To find out the errored items in a workflow follow the steps below Log on to Oracle Application Manager select Workflow Manager from navigate to list box(situated top right corner) and Click go go work items under workflow metrics and click on show button to see the graph click on error block on the graph this will take to you to a a page with different work item types click the relevant work items this will take you to a page with different work item activity stage click the relevant work activity stage this will take to a new page with all the activities select the activity you are concerned with click launch workflow monitor this will open a new page with check the item status it wil...

On windows 7 make sure computers are on the same group Go to network and sharing centre Click on Change advanced sharing settings (its on the left pane) Under File and Printer Sharing Turn on File and Printer Sharing Under password protected sharing (for security) Turn on Password protected sharing if you select the other option, people can access without giving a user name and password, otherwise you have to provide user name and password)