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

Oracle APPS Useful Technical Websites

--Good document for oracle forms.
http://www.scribd.com/doc/51362321/99/Data-Block-Level-Transaction-Triggers

http://bbs.erp100.com/document/yanerwei/OAF_TRAINING/training_movie/Lesson5/Lesson5.html
http://amitsrivastavaoaf.blogspot.com
http://www.tier1inc.com/blog.php
http://sheikyerbouti.developpez.com/tutoforms10g/tutoforms10g.htm
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_stats.htm

10g and 11g new features
http://www.asktheoracle.net/oracle-10g-plsql-new-features.html

Excel:
http://www.homeandlearn.co.uk/ME/MicrosoftExcel.html

MOAC:
http://support.rysigo.com/entries/20514742-r12-oracle-applications-multiple-organizations-access-control-for-custom-code-oracle-note-id-420787-#overview

Good Website for Oracle Apps Technical
http://startapps.blogspot.com/2011/03/how-to-find-backend-sql-query-from-self.html

How Do I Start Learning Oracle ADF and JDeveloper 11g

http://www.oracle.cc/2010/02/how-do-i-start-learning-oracle-adf-and-jdeveloper-11g/

AP and AR Functional Flow

http://www.aboutoracleapps.com/2007/07/ap-concepts-2.html

Email From PL/SQL In Oracle9i

http://www.oracle-base.com/articles/9i/EmailFromPLSQL9i.php

Exception handling for Bulk Insert and Bulk update using FORALL

DECLARE
TYPE NumList IS TABLE OF NUMBER;
-- The zeros in this list will cause divide-by-zero errors.
num_tab NumList := NumList(10,0,11,12,30,0,20,199,2,0,9,1);
errors NUMBER;
dml_errors EXCEPTION;
PRAGMA exception_init(dml_errors, -24381);
BEGIN
-- SAVE EXCEPTIONS means don't stop if some DELETEs fail.
FORALL i IN num_tab.FIRST..num_tab.LAST SAVE EXCEPTIONS
DELETE FROM emp2 WHERE salary > 500000/num_tab(i);
-- If any errors occurred during the FORALL SAVE EXCEPTIONS,
-- a single exception is raised when the statement completes.
EXCEPTION
WHEN dml_errors THEN -- Now we figure out what failed and why.
errors := SQL%BULK_EXCEPTIONS.COUNT;
dbms_output.put_line('Number of DELETE statements that failed: ' || errors);
FOR i IN 1..errors LOOP
dbms_output.put_line('Error #' || i || ' occurred during '||
'iteration #' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
dbms_output.put_line('Error message is ' ||
SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
END LOOP;
END;

FNDLOAD for Profile

DOWNLOAD
=========
FNDLOAD apps/appspwd O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct filename.ldt PROFILE PROFILE_NAME="profile name" APPLICATION_SHORT_NAME="XXDIS"

UPLOAD
=======
FNDLOAD apps/appspwd O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct filename.ldt