How To Enter Internet Expense Reports For Other Persons

This feature is called “Authorized Delegate”.
To have the ability to enter expense reports, withdraw expense reports, etc. for other individuals,
do the following:

Authorization Preferences (Self-Service Delegate Assignment)
Users can now maintain their own list of authorized delegates in the Expenses Preferences page. An authorized delegate is someone who has the authority to enter expense reports on another user’s behalf. This feature existed in previous versions of Internet Expenses as a system administrator task only. The ability for system
administrators to define authorized delegates still exists.
This feature is included in Oracle Applications Release 11.5.9 Maintenance Pack and in 11i.OIE.G and higher minipacks.

Choose Responsibility:
Internet Expenses
Navigate to the Expenses Preferences
Choose the Authorization Preferences Link

Expenses Entry Delegations:
The people in this list can enter expense reports for you. They can also view all of your previously submitted expense reports.
Expenses Entry Delegations can be granted by you to another person

Expenses Entry Permissions
You can enter expense reports for the people in this list. You can also view all of their previously submitted expense
Expenses Entry Permissions must be granted to you by the other person
(You cannot grant your own Expense Entry Permissions).

OR

Prior to this functionality,
Authorized delegate permissions were granted as follows.

This functionality still exists.

Choose Responsibilty: System Administrator
Navigate: Security – User – Define
Query up the user who is going to be be an authorized delegate.
Go to the Securing Attribute region
Add a row

Securing Attribute: ICX_HR_PERSON_ID

Application: Self-Service Web Applications

Value: Choose the employee name from the list of values for the employee for
which this user needs to be able to enter expense reports form.

How To Add A Help Icon To Internet Expenses Screens To Access User

Activate the personalize self-service definition system profile option and change the personalize region

The ‘Help’ button will appear in the personalize region screen

To show the help button in all iExpense screens

1) Define a Function say OIE_HELP

TYPE = UNKNOWN.

Maintenance Mode Support = None

Context Dependence = Responsibility

Form, Application, Parameters = blank

HTML call = <refer to step2 to build the url>

Secured = blank

Encrypt Parameter = blank

Host Name = blank

Agent = blank

Icon = email_greyscale.gif

Object, Region Application, Region Code = blank

2) The Url of the Function MUST be of format “Http://www.yahoo.com”

Note: The Url MUST start with “Http://”, otherwise it is taken

as a relative url

To Define an absolute url, the url MUST start with Http://”

3) Attach the Function with any Menu Component
To add a global button attach it to the menu : OIE_EXPENSES_GLOBAL

4) Bounce Apache

How to Remove the Worklist from Appearing on the HomePage

Follow same steps to get Worklist on HomePAge

1. Click on Personalize Page link (if Personalize Page link is not appearing ,set profile option Personalize Self-service Defn = Yes at site level)

2. Click on Personalize “Notifications Worklist Function” > Stack Layout: Notifications Worklist Function> Click on Personalize link (pencil icon) > Set Rendered = False at Site level .

3. Click on Personalize “Worklist” > Table: Notification List > Click on Personalize link (pencil icon) > Set Rendered = False at Site level .

4. Log out and login and the Worklist now does not appear on Homepage.

How to remove / hide the ‘Edit Navigator’ button on the Homepage

The purpose of this button is only to provide the user a way to personalize (only show / hide) the list of responsibilities in the Navigator on his Homepage.

This button can be hidden using the following Personalization:

1. Enable Personalization by setting the System Profile option ‘Personalize Self Service Defn’ to ‘Yes’ at the required level
2. Navigate to the Homepage and click on the ‘Personalize Page’ link in the top right corner
3. Under ‘Personalization Structure’, click on the ‘Expand All’ link
4. Search for the item Name ‘Button: Edit Navigator’
5. Click on the ‘Personalize’ pencil icon against this item
6. In the resulting page, set the ‘Rendered’ property to ‘false’, at the required level
7. ‘Apply’ the changes and on the resulting page, ‘Return to Application’
8. The ‘Edit Navigator’ button is no longer visible

Please Note, this does not actually remove the button, but only hides it from the user and can be made visible by setting the ‘Rendered’ property to ‘true’, through Personalization if Personalization is enabled for the user.

Global Policy Link Does Not Open A New Browser Window

The Global Policy link is tied to a standard menu and not self-service menu. due to the standard menu definition, this link will never open a new browser window.
The coding for Global Policy link is using the AK format and not using new MDS (personalization)
format; which is why the link is not queryable using OA Personalizations in the OAFooter.xml.

To implement the solution, please execute the following steps:

1. Right click the Global Policy Link to open new in new window

Or

2. Code your Global Policy page to call open.window, for example:

destination=http://www.oracle.com/html/index.html?privacy.html

To:

destination=”javascript:void window.open(‘http://www.oracle.com/html/index.html?privacy.html’);”

Thanks – Shiv

Oracle 11i/ R12 – Contact Us Link – in Internet Expenses

“A Contact Us global button is available so your users can submit questions or comments as necessary. To enable this feature, complete the following steps (from user guide):

1. Log into Oracle Applications using Application Developer responsibility.
2. Navigate to Application > Function.
3. Query the function OIE_CONTACT_US.
4. Select the Web HTML tab.
5. Enter the desired email address right after mailto: (no spaces) in the HTML Call field. The following example demonstrates the format of the email address:

mailto:yourname@yourcompany.com”

After completing the steps, log into Internet Expenses and navigate to Expense Entry. Click on the Contact Us link and this launches Outlook Express

Tips For Personalizing The E-Business Suite 11i Login Page (AppsLocalLogin)

You would like to personalize the AppsLocalLogin.jsp login page to add specific text, change the logo, etc. This document describes the supported and non supported methods to achieve one’s ends.

1. Attributes of the login page

It is possible to control the display of some attributes of the login page, for instance user name or password hints, language switchers, forgot password link, corporate policy message, etc. For this, you need to set the profile option ‘Local Login Mask’ (FND_SSO_LOCAL_LOGIN_MASK) with a number being the sum of the mask values described in the table below:

Description	Mask value
Hint for Username (USERNAME_HINT)	01
Hint for Password (PASSWORD_HINT)	02
Cancel button (CANCEL_BUTTON)	04
Forgot Password link (FORGOT_PASSWORD_URL)	08
Registration link (REGISTER_URL)	16
Language Images (LANGUAGE_IMAGES)	32
Corporate Policy Message (SARBANES_OXLEY_TEXT)	64

* For instance the value 32 (default) displays only the language icons and value 127 will show all the attributes on the page. Please see the attached screen shots as an example. * The change takes effect immediately after re-login to E-Business Suite.

2. Message texts

It is possible to modify or add text on the login page by changing the value of some messages. The following table shows the related messages and their default value:

Description	Default value
FND_SSO_WELCOME	Login
FND_SSO_EBIZ_SUITE	E-Business Suite
FND_SSO_COPYRIGHT_TEXT	Copyright (c) 2007, Oracle. All rights reserved.
FND_SSO_SARBANES_OXLEY_TEXT	Corporate Policy Message

To change the value of a message:

1. Go to “Application Developer” responsibility
2. Select “Messages” from the menu
3. Query  the message name and then enter your message text in the “Current Message Text” field
4. Save changes and exit
5. Clear cache and bounce Apache to see the change

* Note that some messages can be used elsewhere that in the login page and can be updated by a patch , * If you want to change also the default branding ‘E-Business Suite’ on other pages, to match the text on the login page (defined by FND_SSO_EBIZ_SUITE message),
then follow the steps below:

a. Login with System Administrator responsibility
b. Navigate: Application —> Function
c. Query the function ‘FWK_HOMEPAGE_BRAND’
d. Replace the value of the ‘User Function Name’ with the desired text
c. Logout and login to see the change (you shouldn’t need to clear caches and bounce apache)
* The ‘FND_SSO_SARBANES_OXLEY_TEXT’ message is only displayed when the mask

3. Corporate branding logo

The Oracle logo is displayed on various E-Business Suite pages and can be changed by setting the
‘Corporate Branding Image for Oracle Applications’  (FND_CORPORATE_BRANDING_IMAGE) profile option to the full path name of an image file (.gif) that contains your corporate image.

However it is not possible to use this method for AppsLocalLogin.jsp since it is hard coded with the Oracle logo image file ‘FNDSSCORP.gif’.
The non supported solution consists in:

1. Go to the $OA_HTML directory
2. Backup the AppsLocalLogin.jsp file
3. Copy your own corporate branding image under $OA_MEDIA directory
4. Edit the AppsLocalLogin.jsp file :

from :

ImageBean imgBean1 = new ImageBean(“/OA_MEDIA/FNDSSCORP.gif”, FND_ORACLE_LOGO);

to :

ImageBean imgBean1 = new ImageBean(“/OA_MEDIA/<your image file name>”, FND_ORACLE_LOGO);

5. Clear caches and bounce Apache to see the change

* If you prefer the same corporate branding logo be displayed on all pages, including the login page, then you can backup the FNDSSCORP.gif file and modify it with your prefered graphic software.

4. Other modifications

AppsLocalLogin.jsp being a Java Server Page you can change the HTML or Java code (for instance with JDeveloper), create you own messages in the Messages Dictionnary thru AOL responsibility, etc., if you want to add other customizations. This is considered a customization and thus not supported by Oracle. If you apply patches replacing AppsLocalLogin.jsp the file will be overwritten.

The Invoice does not go on Hold with “Quantity billed exceeds quantity received” when Matched to a Purchase Order

Reason could be : No Goods Tolerance has been setup in the supplier site.

When a PO is created for 3 or 4 way match there are no holds placed on the invoice when the items have not been received.

– Steps To Reproduce:
1) Create PO 3 or 4 way match
2) Quick match PO to invoice
3) Validate the PO
4) No holds are placed on the Invoice
5) Expected hold is ‘QTY REC’, “Quantity billed exceeds quantity received”

Invoices are being paid when items have not been received.

Follow the steps below.

1) Setup a Goods Tolerance: 
    a) Accounts Payable – Setup > Invoices > Tolerances

2) To default the Goods Tolerance to suppliers:
    a) Accounts Payable – Setup > Options > Payables – Supplier tab
    b) Select the Goods Tolerance from step 1 
    c) This will now default to new suppliers created

3) For existing suppliers:
    a) Accounts Payable – Supplier > Query
    b) Go to the Supplier Site
    c) Go to the Controls tab
    b) Select the Goods Tolerance setup in step 1

To determine which supplier sites do not have a Goods Tolerance run the following select:
select vendor_name, vendor_site_code, s.creation_date date_site_created, s.created_by site_created_by, tolerance_id, vendor_type_lookup_code
from po_vendor_sites_all s, po_vendors v
where v.vendor_id = s.vendor_id
and tolerance_id is null
and nvl(inactive_date,sysdate + 1) > sysdate
and nvl(end_date_active,sysdate + 1) > sysdate
and pay_site_flag = ‘Y’
and purchasing_site_flag = ‘Y’
order by 1;

Dale Carnegie – Golden Rules for Success

Become a Friendlier Person
1. Don’t criticize, condemn or complain.
2. Give honest, sincere appreciation.
3. Arouse in the other person an eager want.
4. Become genuinely interested in other people.
5. Smile.
6. Remember that a person’s name is to that person the sweetest and most
important sound in any language.
7. Be a good listener. Encourage others to talk about themselves.
8. Talk in terms of the other person’s interests.
9. Make the other person feel important – and do it sincerely.

Win People to Your Way of Thinking
10. The only way to get the best of an argument is to avoid it.
11. Show respect for the other person’s opinion. Never say, “You’re wrong.”
12. If you are wrong, admit it quickly and emphatically.
13. Begin in a friendly way.
14. Get the other person saying “yes, yes” immediately.
15. Let the other person do a great deal of the talking.
16. Let the other person feel that the idea is his or hers.
17. Try honestly to see things from the other person’s point of view.
18. Be sympathetic with the other person’s ideas and desires.
19. Appeal to the nobler motives.
20. Dramatize your ideas.
21. Throw down a challenge.

Be a Leader
22. Begin with praise and honest appreciation.
23. Call attention to people’s mistakes indirectly.
24. Talk about your own mistakes before criticizing the other person.
25. Ask questions instead of giving direct orders.
26. Let the other person save face.
27. Praise the slightest improvement and praise every improvement. Be “hearty in your
approbation and lavish in your praise.”
28. Give the other person a fine reputation to live up to.
29. Use encouragement. Make the fault seem easy to correct.
30. Make the other person happy about doing the thing you suggest.

Opening in My team – Sr. Oracle Developer/ Analyst in Eclipsys, Pune, India

do send yours or your referral to shivmohan.purohit@eclipsys.com ,

Technical Skill Sets

Essential

Oracle Applications Experience in several of the following modules:

Human Resources,  Project Accounting, Order Management, Service Contracts,  Inventory, Oracle Imaging , IPM

( 2-3 years experience in 3 of the above 6 is required )

Candidate should be expert in PL/SQL, Oracle Reports, shell scripting and XML Publisher

Good experience / hands on knowledge of Oracle Workflow, BPEL or JDeveloper.

Experience with Oracle Receivables a plus

Experience on Oracle CRM or Siebel CRM will be added advantage.

Excellent oral and written English communication skills required

Ability to manage, track and progress their own project tasks related work.

Work history demonstrates: Good analytical ability, Should work independently on assigned tasks, Good team player

Primary Responsibilities :

This is a hands-on technical/ functional, senior-leveled position, with Oracle applications (11i or greater) experience required.  , Sarbanes Oxley understanding and healthcare industry experience is a plus, but not mandatory. Qualified candidates should have a minimum of 3-5 years Oracle hands on development experience.

Secondary Responsibilities :Jsp/Java J-Developer and Self-Service Frameworks Developer

Required Experience ( 3 to 5 Year )

Specific experience required: 2-4 years of Oracle Applications, Project, Inventory or HR suite..  E-Business Suite implementation experience as a project team member or lead.  Applications support experience in work history that covers at least one of the above applications

Very Common Oracle Apps DBA Questions

I collection few regular asked question for Oracle Apps DBA to hire Apps DBA for my team, now publishing for reader’s use. These question are even relevant for Oracle Technical experts / developer also.  I would like to request share your questions if you have any.

Q. What is difference between fresh database and vision database install types ?
Fresh Database – Database is installed with Apps but with no data
Vision Database – Database installed with Apps with dummy data

Q. Whatis US directory in $AD_TOP or under various product TOP’s .
US directory is default language directory in Oracle Applications. If you have multiple language Installed in your Applications then you will see other language directories beside US, that directory will contain reports, fmx and other code in that respective directory like FR for France, AR for arabic, simplifies chinese or spanish.

Q. Whats main concurrent Manager types.
ICM – Internal Concurrent Manager which manage concurrent Managers
Standard Managers – Which Manage processing of requests.
CRM – Conflict Resolution Managers , resolve conflicts in case of incompatibility.

Q. Where is Concurrent Manager log file location ?
By default standard location is $APPLCSF/$APPLLOG , in some cases it can go to $FND_TOP/log as well.

. List some ad utilities and their functions?
adadmin, adctrl, adpatch, adlicmgr, admrgpch, adsplice and adworker

Q. List out the modules related to oracle Apps DBA ?

FND – Application Object Library, AU – Application Utilities, AD – Application DBA

Q. How many concurrent mangers can be used ? what is the limit ?
There is no such documented limit on number of concurrent managers, as long as you have enough operating system resource (memory).

Q. How would you check if the tablespace is in backup mode ?
- Check in v$backup
SQL> SELECT d.tablespace_name, b.status FROM dba_data_files d, v$backup b
WHERE d.file_id = b.FILE# and b.STATUS = ‘ACTIVE’ ;

Q. What is “Custom TOP” in apps ?
- Custom top is similar to other tops under APPL_TOP but containing custom (client) specific functionality. Apps DBA need to define custom TOP and register all custom code under CUSTOM TOP

Q. if you find that under $FND_TOP/secure directory, there are many .dbc files, how would you know which is the correct one ?
– System picks up dbc file based on profile option value “Applications Database ID“

Q Where is applications start/stop scripts stored ?

Ans: $COMMON_TOP/admin/scripts/$CONTEXT_NAME

How to confirm if Report Server is Up & Running ?

Ans: Report Server is started by executable rwmts60 on concurrent manager Node & this file is under $ORACLE_HOME/bin .execute command on your server like
ps -ef | grep rwmts60
You should get output like
applmgr ……. rwmts60 name=REP60_VISION
where VISION is your Instance name.
Else you can submit a request like “Active Users” with display set to PDF, check output & log file to see if report server can display PDF files

How you will start Discoverer in Oracle Apps 11i ?

Ans: In order to start dicoverer you can use script addisctl.sh under $OAD_TOP/admin/scripts/$CONTEXT_NAME
or startall.sh under $ORACLE_HOME/discwb4/util (under Middle/Application Tier)

How to check number of forms users at any time ?

Ans: Forms Connections initiate f60webmx connections so you can use
ps -ef | grep f60webmx | wc –l

What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD ?

Ans: 0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where
0 is request id (request ID 0 is assigned to request ID’s which are not submitted via Submit Concurrent Request Form.
‘Y’ indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.

Q. What are .ldt & .lct files which you see in apps patch or with FNDLOAD ?

Ans: .ldt & .lct stands for Loader datafile & Loader configuration files, used frequently in migrating customization, profile options, configuration data, etc.. across Instances.

Q. What is dev60cgi & f60cgi ?

Ans: cgi stands for Common Gateway Interface and these are Script Alias in Oracle Apps used to access forms server . Usually Form Server access directly via http://hostname:port/dev60cgi/f60cgi

Q. How to compile an Oracle Reports file ?

Ans: Utility adrepgen is used to compile Reports. Synatx is given below

adrepgen userid=apps\ source = $PRODUCT_TOP\srw\filename.rdf dest=$PRODUCT_TOP\srw\filename.rdf stype=rdffile dtype=rdffile logfile=x.log overwrite=yes batch=yes dunit=character

My first Video Post – Some inspiration.