Wednesday, April 18, 2012

Program - Publish FSG Report custom template will not show after R12 upgrade from 11i

Solution:The data definition in 11i is FSG Program and where as in R12.1.3 it is FSGXML Program.Please change all your custom template definition to New R12 data definition FSGXML Programs.

Friday, April 13, 2012

Record has been updated. Requery block to see change

"Record has been updated. Requery block to see change" error while trying to process MTI records from front end.

Reason:There could be possiblity of trailing and leading spaces in the field values...
Eg.Transaction_SOurce_name field has value of ' TEST' after removing the Trailing spaces in the field 'TEST'.The records are processing without any issues.

Thursday, April 12, 2012

SQL to find special character records in a table

select city from hz_locations where regexp_like(city,chr(15712189));

R12 changes in JA Tables

--Obsolete in R12
ja.ja_in_so_lines JSL
ja.ja_in_tax_categories JTC

--Replaced the above tables with the below tables
ja.JAI_OM_OE_SO_LINES JSL
ja.JAI_CMN_TAX_CTGS_ALL JTC