How to enable the Cancel button on Application Login page

Oracle Applications provides the ability to include several optional attributes in the login page.

The attributes are as follows:

1. Username Hint
2. Password Hint
3. Cancel Button
4. Forgot Password Link
5. Register Here Link
6. Language Images

These attributes are controlled via a single profile option, “Local Login Mask” (FND_SSO_LOCAL_LOGIN_MASK).

In order to display one or more of these optional attributes on the Application Login page, add the numeric values of all desired attributes and then set the value of the profile option to that value “Local Login Mask”.

Following is numeric value for each attribute

1. Username Hint = 01
2. Password Hint = 02
3. Cancel Button = 04
4. Forgot Password Link = 08
5. Register Here Link = 16
6. Language Images = 32

If you want to display the Cancel Button on the Application login page, then the profile value should be set to 04 Cancel Button . In order to display just the language images, set the profile value to 32.

Save the record after restarting Application services your login page looks like this

How to Audit Changes in Profile Options

By using the following query we can get number of profile option changed along with new values in given number of days

Connect as apps user to instance

SELECT ‘***Profile Option Name ***’
|| a.user_profile_option_name
|| ‘*** Was Updated with value ‘
|| ‘”‘
|| b.profile_option_value
|| ‘”‘
|| ‘ In The Last ‘
|| &p_no_of_days
|| ‘ days’
|| ‘ by ‘
|| (SELECT user_name
FROM apps.fnd_user u
WHERE u.user_id = b.last_updated_by) mesg
FROM apps.fnd_profile_options_vl a,
apps.fnd_profile_option_values b,
apps.fnd_user c
WHERE a.profile_option_id = b.profile_option_id
AND b.last_updated_by = c.user_id
AND ( b.last_update_date > SYSDATE - &p_no_of_days
OR b.creation_date > SYSDATE - &p_no_of_days
)

How to Setup Manual Modifier for Special Charges

Oracle Advance Pricing Facilitate us to define manual adjustments for discounts, surcharges and freight charges. In order to override the selling price directly on the order or apply any surcharge, we must define a manual surcharge.

Following are the steps with screen shot that how to define manual surcharge modifier

Define Modifiers

Navigate to

Modifiers –> Modifier Setup

By using Oracle Pricing Manager Responsibility

Fill the information as per following

In Header Block on Main (T)

· Type :- Freight and Special charge List

· Name :- XX Manual Modifier (its on your own discretion)

· Number :- ABC123 (its on your own discretion)

· Active :- Check this Box

· Automatic :- Leave Unchecked (To inform system this is a manual modifier)

· Description :- Manual Modifier for Demonstration

In Detail Block on Modifiers Summary (T)

· Modifier Number :- System Will Automatically generate this number

· Level :- Order

· Modifier Type :- Freight/Special Charge

· Pricing Phase :- Header Level Adjustments

In Detail Block on Discounts/Charges (T)

· Charge Name: - Administration Fees

· Application Method :- Lumpsum

· Value :- 5000

Save all the information

Build Attribute Mapping

Navigate to

Reports

By using Oracle Pricing Manager Responsibility and submit the request named “Build Attribute Mapping Rules” with default parameters

 

Apply Surcharge on Order

Navigate to

Orders. Returns à Sale Orders

By using Order Management Super User Responsibility

Enter and Save an Order

 

After Clicking on Action (B) a list of value will popped up select “Charges” as shown in picture below

A new interface will appear select charge “Administration Fees” defined earlier all related information automatically retrieved upon selection of charge name and

Click on Apply Button and look at charges field on main Page of Order Entry Form our manual surcharge is applied