3shTech

  ************************* * Compiling .JAVA file  * ************************* >javac *.java --> The above command compiles all java files present in a folder. NOTE: 1) .java files present in each and every folder need to be compiled.       2) .java file when compiled provides corresponding .class file ***************** *Destination URI* ***************** OA.jsp?page=/Xxcust/oracle/apps/ar/ListOfVal/Dependent/webui/dependentPG&OrderNumber={@OrderNumber}&retainAM=Y OA.jsp?page=/Xxcust/oracle/apps/ar/DetailAndDML/detail/webui/carDetailPG&carMakeparam={@Carmake}&carModelparam={@Carmodel}&carverparam={@CarVer}&retainAM=Y ************************** * FOR PAGES (OR) REGIONS * ************************** import command to be run in putty: java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/xxhw/oracle/apps/fnd/helloworld/webui/HelloWorldPG.xml -username apps -password password -rootdir $JAVA_TOP -dbconnection “(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=r12.

  *********** * GRANTS * ********** Team – do not use Grant statements in the SQL scripts while migrating through STAT , instead use  EXEC AD_ZD.GRANT_PRIVS. Manual steps run in DEV Environment: 1. As XXCUST, manually Create/Alter custom table in EBSDEV or EBSPROJ (XXCUST schema for all custom tables). 2. In EBSDEV/EBSPROJ: If creating the table, run:  AD_ZD_TABLE.UPGRADE (‘SCHEMA’,’TABLE’); If altering the table, run: AD_ZD_TABLE.PATCH (‘SCHEMA’,’TABLE’); 3. Insert at least one row of data in the custom table. * This is mandatory for XDF to extract the table definition and for successful Stat archive set creation. 4. As table owner, grant privileges on new/altered table and editioned view to APPS, primarily so AD_ZD.GRANT_PRIVS can be run for privileges. GRANT ALL ON SCHEMA.TABLE TO APPS WITH GRANT OPTION; GRANT ALL ON SCHEMA.EDITIONED_VIEW# TO APPS WITH GRANT OPTION; 5. If additional privileges are required on the new/altered table, the following needs to be run as APPS: ex

  ========== Indexes ========== SELECT b.uniqueness, a.index_name, a.table_name, a.column_name ,b.tablespace_name,b.status   FROM all_ind_columns a, all_indexes b  WHERE a.index_name=b.index_name     AND a.table_name = upper('XXCUST_LABEL_ATTR_RULES_DTL')  ORDER BY a.table_name, a.index_name, a.column_position; ============ Inventory ============ --onhand (SELECT NVL         (SUM (moq.transaction_quantity),          0          ) on_hand_qty,   moq.inventory_item_id   FROM mtl_onhand_quantities_detail moq  WHERE moq.organization_id = p_inv_org_id  GROUP BY moq.inventory_item_id) onhand --reserve qty (SELECT organization_id, inventory_item_id,         NVL (SUM (transaction_quantity),0) res_qty    FROM mtl_onhand_quantities   WHERE organization_id = p_inv_org_id     AND subinventory_code IN (SELECT secondary_inventory_name                                 FROM mtl_secondary_inventories                                WHERE organization_id = p_inv_org_id                            

create or replace FUNCTION XXCUST_ENCODE_TO_XML ( p_value IN VARCHAR2 ) RETURN VARCHAR2 AS /*    +====================================================================+ --    Name:              XXCUST_ENCODE_TO_XML --    Created by:        Unknown --    Creation Date:     Unknown --    Script:            XXCUST_ENCODE_TO_XML.sql --    Description:       This procedure strips out special characters out of a character string -- --    Change History: --    ___________________________________________________________________________ --    Date          Name              Ticket#   PVCS Ver    Comments --    ___________________________________________________________________________ --    +====================================================================*/ res varchar2(32000); BEGIN res:=p_value;     IF (INSTR(res,'&' ) != 0) THEN       res:=REPLACE(NVL(res,NULL),'&','&');   END IF;   IF (INSTR(res,'''' ) != 0) THEN       res:= REPLACE

BELOW logic to be written in Page Controller on the press of " Download " button in OAF page. It will download the .csv template of excel to the local system. Headings in csv can be changed in plsql procedure written separately and called in OAF page. Target: here goes, STEP 1: (Controller)  /*===============================================================================+  +===============================================================================+    |  HISTORY                                                                      |    | Release         Date                  Author                 Remarks          |    | =======       ===========          =============         =================    |    | 1.1           04-Sep-20XX      *********  Added Logic for ******  |    +===============================================================================*/ package rhmozf.oracle.apps.ozf.oa.ACDordupld.webui; import java.io.BufferedInputStream; import java.io.BufferedReader