Page History

...

• Manually updating the customization library
• Manually updating Oracle Applications’ Applications' system profile (Oracle applications Applications 11.5 or higher)

Anchor
Manuallyupdatingthecustomizationlibrary Manuallyupdatingthecustomizationlibrary

Manually updating the customization library

...

1. Find the CUSTOM.pll and CUSTOM.plx files, usually located in your Oracle Applications folder.
2. Back up the CUSTOM.pll and CUSTOM.plx files.
3. Verify that no Oracle Applications user is currently logged on to the database or any other database using the CUSTOM.pll and CUSTOM.plx files.

4. Run the %ORACLE_HOME%\bin\if60gen.exe tool (sometimes called ifbld60.exe).

   Info
   For Oracle Applications version R12, replace f60gen command with frmcmp_batch.

5. In the welcome wizard, select Open an existing form, followed by OK.
6. Choose custom.pll and click Open.
7. Under PL/SQL Libraries>Custom>Program Units right-click on Package body and select the PL/SQL Editor.
8. Find the EVENT procedure, locate the first BEGIN after the commented sample code, and insert the following code, starting with BEGIN.
   Verify that the script was not inserted into commented sample code. You can easily mistake sample code for real code.
   begin
if (event_name='WHEN-NEW-FORM-INSTANCE')
then declare cursor_name integer; rows_processed integer; del char(1) := substr(get_application_property(CURRENT_FORM),1,1);
begin
if (del != '/')
then del := '\';
end if;
cursor_name := dbms_sql.open_cursor;
dbms_sql.parse(cursor_name,
'begin VERITAS_APPS_LOG( ''F'' , :username ,
:application , :form , NULL) ; end ;' ,1); dbms_sql.bind_variable(cursor_name,':username' ,
FND_PROFILE.VALUE('USERNAME')); dbms_sql.bind_variable(cursor_name,':application' ,
substr(get_application_property(CURRENT_FORM), instr(get_application_property(CURRENT_FORM),del ,
-1)+1, length(substr( get_application_property(CURRENT_FORM),
instr(get_application_property(CURRENT_FORM), del,-1)+1))-4));
dbms_sql.bind_variable(cursor_name,':form' , Name_In('system.current_form'));
rows_processed := dbms_sql.execute(cursor_name);
dbms_sql.close_cursor(cursor_name);
exception
when others then begin dbms_sql.close_cursor(cursor_name);
exception
when others then null;
end; end; end if;
exception
when others then null;
end;
9. Click File>Save.
10. Run %ORACLE_HOME%\bin\ifcmp60.exe.
11. Fill in the following fields:
    1. File. CUSTOM.PLL (that we changed before)
    2. Userid. APPS
    3. Password. APPS password
    4. Database. database name
    5. Module Type. LIBRARY
    6. Module Access. FILE
12. Click OK.

Anchor
ManuallyupdatingOracleApplicationssystemprofileOracleapplications115orhigher ManuallyupdatingOracleApplicationssystemprofileOracleapplications115orhigher

Manually updating Oracle Applications’ system profile (Oracle Applications 11.5 or higher)

To have an Interpoint for Oracle Applications identify interactive forms in Oracle Applications 11.5 or higher, you must manually update the system profile of Oracle Applications with site-specific initialization code. As a result, Oracle Applications forwards the required information - the user, form, and application name for interactive work and the concurrent program and application name for batch work - to an Interpoint for Oracle Applications.

Before updating Oracle Applications’ system profile, you must verify that an Interpoint for Oracle Applications was installed successfully. Otherwise, updating the profile may halt Oracle Applications.

To avoid interfering with anyone’s work before changing the system profile, you can alternatively change the profile for only one user to first test the outcome.

To verify that an Interpoint for Oracle Applications was installed successfully

• Run the following script:
  Windows
       \products\oracle\SID\schema\verify_install_oracle_apps.bat
  UNIX
       ./products/oracle/SID/schema/verify install oracle apps.sh

To update Oracle Application’s system profile

1. Log in to Oracle Applications with a user that has system administrator privileges.
2. Open the System Administrator application.
3. Open the Navigator - System Administrator dialog box.
4. On the Functions tab, select Profile>System; then click Open.
5. In the Find System Profile Values form, select the Site check box and type the following value in the Profile text box: Init%SQL%Custom
6. Click Find.
7. In the System Profile Values form, type the following in the Site text box: begin veritas_custom_profile; end;
8. Close the System Profile Values form; then open any form.
   If the form opens cleanly, you can start working with the Interpoint for Oracle Applications.
   If an issue occurs, verify again that the Interpoint for Oracle Applications was installed successfully. If it was installed successfully, most likely the issue was caused by erroneous text in the system profile. If the issue persists, contact Precise Customer Support.

To update the system profile for one user only

1. Log in to Oracle Applications with a user that has system administrator privileges.
2. Open the System Administrator application.
3. Select Profile>System; then click Open.
4. In the Find System Profile Values form, select the Site and User check boxes.
5. To the right of the User check box, enter the name of the user whose profile you want to change.
6. Type the following value in the Profile text box: Init%SQL%Custom
7. Click Find.
8. In the System Profile Values form, type the following in the User text box: begin veritas_custom_profile; end;
9. Close the System Profile Values form and log in to Oracle Applications with the user selected in Step 8.
10. Open any form.
    If the form opens cleanly, you can update the Oracle Applications’ system profile. 
    If an issue occurs, verify again that the Interpoint for Oracle Applications was installed successfully. If it was installed successfully, most likely the issue was caused by erroneous text in the system profile. If the issue persists, contact Precise Customer Support.

Correcting problematic profiles