How To Delete A Concurrent Program, Executable (Short Name),Data Definition and Template From Back End In Oracle Apps EBS R12

How To Delete A Concurrent Program, Executable (Short Name),Data Definition and Template From Back End In Oracle Apps EBS R12

-- Script to delete the concurrent program and executable from Oracle Apps:

Syntax :
----------
Begin
fnd_program.delete_program('program short name','schema');
fnd_program.delete_executable('program short name','schema');
commit;
End;

Example :
------------

Begin
fnd_program.delete_program('XX_SALARY_DETAIL_REPORT', 'XXBRAC' );
fnd_program.delete_executable('XX_SALARY_DETAIL_REPORT', 'XXBRAC' );
commit;
End;

----------------------------------------------------------------------------------

Begin
fnd_program.delete_program('EMPDTLSREP', 'apps' );
fnd_program.delete_executable('EMPDTLSEXE', 'apps' );
commit;
End;

Note: The same concurrent program can be disable through from end if a user decides not to use it.

------------------------------------------------>
-- Script for deleting the datadefinition
------------------------------------------------>

BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('INV','XX_SALARY_DETAIL_REPORT');
END;

------------------------------------------------------
-- script for deleting the template
------------------------------------------------------>

BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('INV','XX_SALARY_DETAIL_REPORT');
END;

How to know the Table name of OAF pages in ORACLE Apps EBS

---- How to know the Table name of OAF pages in ORACLE Apps EBS  ----

How to know the Table name of OAF (Oracle Application Framework)

Step 1. Set the profile option "FND: Diagnostics" at UserLevel to "Yes".

Step 2. Go to the respective OAF form page.

Step 3. Click on "About this Page" link will appear on Left bottom corner of the OAF Page.

Step 4. Either View Object or Flexfield Name will contain the table name.

URL for the JPG to Icon Converter

JPG to Icon Converter  

URL:

 http://www.online-convert.com/result/f4d3500430520a4aa11454f61cfb494d -------------------------------------------------------------------------------------------------------

EXP-00056: ORACLE error 12170 encountered
ORA-12170: TNS:Connect timeout occurred

C:\oracle\product\10.2.0\db_1\bin>TNSPING.EXE IRIS

C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1

.200)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =iris)))

OK (20 msec)

C:\oracle\product\10.2.0\db_1\bin>SQLPLUS

Enter user-name: ZSHIS/ZSHIS@IRIS

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> EXIT

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64

bit Production

With the Partitioning, OLAP and Data Mining options

C:\oracle\product\10.2.0\db_1\bin>SQLPLUS

Enter user-name: ZSHIS1108/ZSHIS@IRIS

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> EXIT

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64

bit Production

With the Partitioning, OLAP and Data Mining options

C:\oracle\product\10.2.0\db_1\bin>EXP

Export: Release 10.2.0.3.0 - Production on Tue Aug 28 11:35:42 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: zshis1108/zshis@iris

Enter array fetch buffer size: 4096 >

How to open Periods in Oracle Apps EBS

How to open Periods in Oracle Apps

To Create  sales order,  for a given month(period), that  month  should be opened in  five Modules.

·         GL-> Setup-> Open /Close.

·         AP-> Accounting ->Control Payable Periods.

·         PO->Setup->Financials-> Accounting->Open/Close Periods.

·         INV->Accounting Close Cycle ->Inventory Accounting Period->(Selct Org )

·         AR->Control ->Accounting ->Open/Close  Periods.

How to Update Customer Location Address in the Oracle Apps EBS R12 Using Script

----****** How to Update Customer Location Address in the Oracle Apps EBS R12 Using Script *********** ----------

DECLARE

   p_location_rec            hz_location_v2pub.location_rec_type;

   p_object_version_number   NUMBER;

   x_return_status           VARCHAR2 (4000);

   x_msg_count               NUMBER;

   x_msg_data                VARCHAR2 (4000);

BEGIN

   DBMS_OUTPUT.put_line ('Start of Script');

   mo_global.init ('AR');

   fnd_global.apps_initialize (user_id           => 11,

                               resp_id           => 551122,

                               resp_appl_id      => 457

                              );

   mo_global.set_policy_context ('S', 123);

   p_object_version_number := 1;

   p_location_rec.location_id := 28195;

   p_location_rec.address1 := 'LOC_Address1';

   p_location_rec.address2 := 'LOC_Address2';

   p_location_rec.address3 := 'LOC_Address3';

   p_location_rec.address4 := 'LOC_Address4';

   p_location_rec.city := 'LOC_CITY';

   p_location_rec.state := 'LOC_STATE';

   p_location_rec.postal_code := 'POSTAL_CODE';

   p_location_rec.country := 'IN';

   DBMS_OUTPUT.put_line ('Calling the API hz_location_v2pub.update_location');

   hz_location_v2pub.update_location

                          (p_init_msg_list              => fnd_api.g_true,

                           p_location_rec               => p_location_rec,

                           p_object_version_number      => p_object_version_number,

                           x_return_status              => x_return_status,

                           x_msg_count                  => x_msg_count,

                           x_msg_data                   => x_msg_data

                          );

   IF x_return_status = fnd_api.g_ret_sts_success

   THEN

      COMMIT;

      DBMS_OUTPUT.put_line ('Successfully Location address updated ');

   ELSE

      ROLLBACK;

      FOR i IN 1 .. x_msg_count

      LOOP

         x_msg_data := oe_msg_pub.get (p_msg_index => i, p_encoded => 'F');

         DBMS_OUTPUT.put_line (i || ') ' || x_msg_data);

      END LOOP;

      DBMS_OUTPUT.put_line ('Location address update failed:' || x_msg_data);

   END IF;

   DBMS_OUTPUT.put_line ('End of Script');

END;