0

Oracle Forms Start Issues

posted on , by Adarsh

 SOLUTION for FRM-18108: Failed to load the following objects.ERRORFRM-18108: Failed to load the following objects.Source Module: APPSTAND Source Object: STANDARD_PC_AND_VASource Module: APPSTAND Source Object: STANDARD_TOOLBARSource Module: APPSTAND Source Object: STANDARD_CALENDARSOLUTION:- Copy the Form file(.fmb) APPSTAND.fmb from $AU_TOP(appl_top/au/forms/US)- And Paste into your Local forms folder(mentioned inFORMS_PATH)- Open the Form Builder, First open that APPSTAND.fmb Form , Now ...

0

Creating/Adding new user in Oracle Apps (EBS) from back end

posted on , by Adarsh

Adding new user in Oracle Apps (EBS) from back end Application users in Oracle Apps (EBS) can be created from the front end as well as back end. The back end method for user creation can be used when you don’t have sysadmin access to the application or also it can be used to speed up the process when there are many userids to be created. You will require apps access to connect to database  to run the package fnd_user_pkg. We can create user, disable/enable user, add/delete responsibility ...

0

FNDLOAD: command not found

posted on , by Adarsh

FNDLOAD: command not found Normally we use FNDLOADS to download and upload the ldts of program files for example concurrent program and request groups … While uploading or downloading FNDLOADS we may get following error FNDLOAD: command not found: Solution: Apply. Env file as shown below     After apply .env file ...

0

Materialized View in Sql Oracle

posted on , by Unknown

Materialized View in Sql Oracle Materialized view in SQL is also a logical structure which is stored physically on the disc. Like a view in Materialized views in SQL we are using simple select statement to create it.You should have create materialized views privileges to create a Materialized views. Definition of Materialized views (called as MV) has been stored in databases. Materialized views are useful in Data-warehousing concepts. When you create a Materialized view, Oracle Database ...

0

What is difference between View and Materialized View

posted on , by Unknown

What is difference between View and Materialized View What is View in database Views are a logical virtual table created by “select query” but the result is not stored anywhere in the disk and every time we need to fire the query when we need data, so always we get updated or latest data from original tables. Performance of the view depends on our select query. If we want to improve the performance of view we should avoid using join statement in our query or if we need multiple ...

0

Oracle Report Triggers

posted on , by Adarsh

Oracle Report Triggers There are eight report triggers. Of these, there are five global triggers called the Report Triggers. They are fired in the following order : * Before Parameter Form * After Parameter Form * Before Report * Between Pages * After Report Apart from the above Five Report Triggers, there are three other types of triggers : * Validation Triggers * Format Triggers * Action Triggers Before Form: Fires before the run-time Parameter Form is displayed. From this trigger, you can ...