Monday, October 28, 2013

ERROR while extract data from File | Export menu option : ... unable to extend segment LOB.APPLSYS.SYS_LOBxxxx in tablespace APPS_TS_MEDIA

Symtomps:  When you try to Export (Menu option File| Export )appears this error:".. unable to extend segment LOB.APPLSYS.SYS_LOBxxxx in tablespace APPS_TS_MEDIA ..."



Conclusion: The tablespace APPS_TS_MEDIA is full. Just add a new datafile to the tablespace and fix it.
How: 
1.Go to sqlplus logging as SYSDBA:
$sqlplus sys as sysdba/YYYY

note:where YYYY is password sysdba

2. To know what tablespace correspond with which datafile you can use this use sql query:
 select file_name,tablespace_name from dba_data_files where file_name like'%media%'
result:
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
/u02/oracle/iosaproddata/a_media01.dbf
APPS_TS_MEDIA

More information about datafiles and tablespace see link below:
http://appsvista.blogspot.com.es/2011/01/tablespace-files.html

3.SQL> ALTER TABLESPACE APPS_TS_MEDIA ADD DATAFILE '/u02/oracle/iosaproddata/a_mediaX.dbf' SIZE 1024M AUTOEXTEND OFF;

note: where X is a new number for datafile. In my case: if you list(ls -la /u02/oracle/iosaproddata/ ) data folder  and get this output:

$ls -la /u02/oracle/iosaproddata/
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_int01.dbf
-rw-r-----   1 oratest oinstall 1610620928 Dec 13 11:58 a_media01.dbf
-rw-r-----   1 oratest oinstall   62922752 Dec 13 11:58 a_nolog01.dbf
-rw-r-----   1 oratest oinstall  524296192 Dec 13 11:58 a_queue01.dbf
-rw-r-----   1 oratest oinstall  524296192 Dec 13 11:58 a_queue02.dbf
drwxr-xr-x   2 oratest oinstall       4096 Feb 19  2011 archive
-rw-r-----   1 oratest oinstall 1572872192 Dec 13 11:58 a_ref01.dbf
-rw-r-----   1 oratest oinstall 1572872192 Dec 13 11:58 a_ref02.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_summ01.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_summ02.dbf
-rw-r-----   1 oratest oinstall  134225920 Dec 13 11:58 a_tools01.dbf
-rw-r-----   1 oratest oinstall 2147491840 Dec 13 11:58 a_txn_data01.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data02.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data03.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind01.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind02.dbf


the last .dbf file is a_media01.dbfsoX  should be 2, so sqlplus sentece would be:ALTER TABLESPACE APPS_TS_ARCHIVE ADD DATAFILE '/u02/oracle/iosaproddata/a_media02.dbf' SIZE 1024M AUTOEXTEND OFF;

Friday, October 25, 2013

Setup an user as a buyer


When an user try to operate with purchasing and it doesn`t really work, usually  it is happen because that user  has not been configured as buyer. For setup an user as a buyet follow these instructions.

Responsability: GLOBAL PURCHASING.
Function:(Setup|Personnel|Buyers).
Add the user as buyer as you see in the picture below:

Wednesday, February 13, 2013

Add a new Customer Class


It's usual to add new customer class in Receivable module . Usually you use Customer class for join in the same group countries with similar characteristics.

you can choose a customer class in a specific customer in this picture:

For adding new customer classs :
Responsibility: Receivables Manager. (Setups| System| Quick Codes | Receivables).




More information in oracle support: How to add a new Customer Class [ID 1407903.1]

Thursday, January 17, 2013

ERROR: ... unable to extend index APPLSYS.FND_LOGINS by 16 in tablespace APPS_TS_ARCHIVE


Symtomps:  When you run a Request appears this error:".. unable to extend index APPLSYS.FND_LOGINS by 16 in tablespace APPS_TS_ARCHIVE ..."




Conclusion: The tablespace APPS_TS_ARCHIVE is full. Just add a new datafile to the tablespace and fix it.
How: 
1.Go to sqlplus logging as SYSDBA:
$sqlplus sys as sysdba/YYYY

note:where YYYY is password sysdba

2.ALTER TABLESPACE APPS_TS_ARCHIVE ADD DATAFILE '/u02/oracle/iosaproddata/a_archive0X.dbf' SIZE 1024M AUTOEXTEND OFF;

note: where X is a new number for datafile. In my case: if you list(ls -la /u02/oracle/iosaproddata/ ) data folder  and get this output:

$ls -la /u02/oracle/iosaproddata/
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_archive01.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_archive02.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_archive03.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_archive04.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_int01.dbf
-rw-r-----   1 oratest oinstall 1610620928 Dec 13 11:58 a_media01.dbf
-rw-r-----   1 oratest oinstall   62922752 Dec 13 11:58 a_nolog01.dbf
-rw-r-----   1 oratest oinstall  524296192 Dec 13 11:58 a_queue01.dbf
-rw-r-----   1 oratest oinstall  524296192 Dec 13 11:58 a_queue02.dbf
drwxr-xr-x   2 oratest oinstall       4096 Feb 19  2011 archive
-rw-r-----   1 oratest oinstall 1572872192 Dec 13 11:58 a_ref01.dbf
-rw-r-----   1 oratest oinstall 1572872192 Dec 13 11:58 a_ref02.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_summ01.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_summ02.dbf
-rw-r-----   1 oratest oinstall  134225920 Dec 13 11:58 a_tools01.dbf
-rw-r-----   1 oratest oinstall 2147491840 Dec 13 11:58 a_txn_data01.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data02.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data03.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind01.dbf
-rw-r-----   1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind02.dbf


the last .dbf file is a_archive04.dbf, soX  should be 5, so sqlplus sentece would be:ALTER TABLESPACE APPS_TS_ARCHIVE ADD DATAFILE '/u02/oracle/iosaproddata/a_archive05.dbf' SIZE 1024M AUTOEXTEND OFF;