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;

Order-level sales credit total () must equal 100%

This error could appear when you are doing a material return from a sales order.  
Material return workflow need to create a special sales order(return type). Most cases it has been created  as a copy of original and not all fields are copy from source to target. One of these missed fields are Sales Credits , so for fixing this problem you have to inform in target sales order all data regarless Sales Credit.  For do use using  Actions| Sales Credits. In the picture below you can see more details:

Set mandatory fields depending a condition in forms using personalization

Initially you have to know which fields are involved. So one field controls the condition and other field become required depending value of first field.

For this example in Payments (AP responsability)we need Payment Rate(Rate_dsp ) field be required when Account Currency(Currency_code) not equal to EUR.

1. Create condition:
navigate to (Help|Diagnostics|Custom Code|Personalize) and see picture below:



2.make a field be Required if condition rule(above image) is evaluated to true.Navigate to the second Tab called "Actions" and enter a new action as you see in image below:

 

Set mandatoy fields in forms using personalization

From required form, navigate to (Help|Diagnostics|Custom Code|Personalize)

- Navigate to the second Tab called "Actions" and enter a new action :


- Seq to a number at your wish


- Type = 'Property"


- description - add a description here


- language - as needed for customer's business needs


- Object Type - "Item"


- Target Object - "FORM_NAME.field_name_here"

- Property Name = 'Required"


- Value = "TRUE"

see picture below for more datails: