Skip to main content
Kofax

MarkView Oracle Integration - Choosing a customer value for SF_TOP can result in an error opening forms.

Summary

4268

Applies To

  • ERP System: Oracle
  • MarkView Version: 6.1.3 and earlier

Behavior

  • The MarkView Installer does prompt users for the SF_TOP when installing the MarkView Oracle Forms Server Components. However, the Installer does NOT prompt for the SF_TOP when doing the MarkView Application Server and Database Components install.
    This does not cause any issue if the default SF_TOP is used. However, if a custom SF_TOP is used, the data seeded into FND_APPLICATION will still have the default value of SF_TOP, resulting in the forms in this directory not being found.

Known Causes

  • This is a known issue (reference SPR00063518) with an effective workaround.

Resolution

  • The following is an effective workaround:
    While logged in as the APPS database user, manually update the BASEPATH in the FND_APPLICATION table to match the environment variable set by the forms installer. Such an update would be similar to the following.
    declare
        dummy_rowid Varchar2(1000);
        n_application_id Number;
    begin
        select distinct(application_id)
        into n_application_id
        from fnd_application_tl
        where application_name = 'SQL*Flow';
        fnd_application_pkg.update_row( 
            X_APPLICATION_ID => n_application_id
            ,X_APPLICATION_SHORT_NAME => upper('xxsf')
            ,X_BASEPATH => 'XXSF_TOP'
            ,X_APPLICATION_NAME => 'SQL*Flow'
            ,X_DESCRIPTION => 'SQL*Flow'
            ,X_LAST_UPDATE_DATE => sysdate
            ,X_LAST_UPDATED_BY => 0
            ,X_LAST_UPDATE_LOGIN => 0);
    end;

Keywords: sf-top, sf top