My Learning

This issue happens when you end date a responsibility and give a new responsibility to a user. Once user tries to log in “XXX is not a valid responsibility for the current user. Please contact your System Administrator”. This is because of cache at server, oracle does this to speed up the process. Clearing this cache will make the user to log in with new responsibility. Clearing the cache Steps go to > Functional Administrator responsibility Click on Core services tab (the tab at the top right) Click on Caching Framework Tab (blue tab under main tab) Click on Global configuration Click on Clear All Cache A warning message related to performance will come , say yes Screen shots After selecting functional administrator responsibility 2 3 4 5 6

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...