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:

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]

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;

Add popup message while request running

For debugging purposes you can use command SRW.MESSAGE inside pl/sql code when you are creating a report using report builder v.6 application.

i.e: Uses this command in BEFOREREPORT program unit for showing which value has P_PARAMETRO

SRW.MESSAGE(1,'PARAMETRO ' || :P_PARAMETRO);

full code:


function BeforeReport return boolean is
begin
   SRW.MESSAGE(1,'PARAMETRO' || :P_PARAMETRO);

   return (TRUE);

end;

Note: In parallel when form builder is used for creating a form you can add this line for add comment:
 dbms_output.put_line('PARAMETRO' || :P_PARAMETRO);

shortcut to concurrent request.

Execute a request in e-Business Suite is a process which need navigate in many forms. If you need generate reports mamy times you need other. This Blog entry try give a solution creating a shortcut in the menu:

1. Create a new form which call to concurrent manager with a parameters.

(Responsability:Application Developer|Application|Function)

This is the core:

Form:

Run Report

Parameters:

CONCURRENT_PROGRAM_NAME ="XXXX" PROGRAM_APPL_SHORT_NAME="YYYY"

where XXXX= Request Name (Short) and YYYY=Request Applications Program.

Finally, you only have to add IO-INFORME VENTAS... as new form in desired responsability menu.

source: http://oracle-ebs-hispano.blogspot.com.es/search/label/Concurrent%20request

implement IF-THEN-ELSE logic in a SELECT ORACLE statement

Oracle SQL from Oracle 8i support methods of create  IF-THEN-ELSE using CASE SQL .
See example below:

SELECT  CTA.CUSTOMER_TRX_ID ID_FACTURA,CTA.TRX_NUMBER NUMERO_FACTURA,RCTTA.name,

CASE WHEN RCTTA.name='SPA' OR RCTTA.name='RSPA' 

      THEN TO_CHAR(TO_DATE(CTA.TRX_DATE, 'DD/MM/RRRR'), 'DD/MM/RRRR') 

 WHEN RCTTA.name='EXP' OR RCTTA.name='REXP' 

       THEN TO_CHAR(TO_DATE(CTA.TRX_DATE, 'DD/MM/RRRR'), 'MM/DD/RRRR')

ELSE 

        TO_CHAR(TO_DATE(CTA.TRX_DATE, 'DD/MM/RRRR'), 'MM/DD/RRRR')

END AS FECHA_FACTURA

FROM RA_CUSTOMER_TRX_ALL CTA ....

Export to csv doesn't work. APPLSYS.FND_LOBS_CTX

Recently occurred that File|Export option from main menu in oracle apps doesn´t export properly. Problem is due to log file overflow  . For fixing only execute this script:

begin ctx_ddl.sync_index('APPLSYS.FND_LOBS_CTX');

end;