Thursday, November 18, 2010

Why is assigned responsibility not appearing in the navigator page during login?

User data in the FND_USER, FND_RESPONSIBILITY, WF_LOCAL_USER_ROLES, and WF_USER_ROLE_ASSIGNMENTS tables is not valid. To synchronize data follow the steps below:

1. Navigate to the define user form (FNDSCAUS).
2. Query up the user (that is having the issue) and insure the responsibility is NOT end dated.
3. END DATE the USER (not the responsibility) and save the record.
4. UNEND DATE the USER and save the record.
5. Run the request 'Sync responsibility role data into the WF table'.
6. Run the request "Synchronize WF LOCAL tables".
7. Run the request "Workflow Directory Services User/Role Validation" (with parameters 10000, yes, yes, yes).
8. Have the user log off and back on and verify that the responsibility appears.

Please refer 565130.1 metalink note.

Thursday, February 11, 2010

Conflict Resolution Manager

Function of Conflict Resolution Manager:-

Concurrent managers read request to start concurrent programs running. The
Conflict Resolution Manager checks concurrent program definitions for
incompatibility rules.

If a program is identified as Run Alone, then the Conflict Resolution Manager
prevents the concurrent managers from starting other programs in the same
conflict domain.

When a program lists other programs as being incompatible with it, the Conflict
Resolution Manager prevents the program from starting until any incompatible
programs in the same domain have completed running.


If the Conflict Resolution Manager fails, the Internal Manager will restart the
Conflict Resolution Manager, or will process incompatibilities if the profile
option Concurrent: Use ICM is set to Yes.

Tuesday, February 9, 2010

Discoverer 4i

Advantages:
• Simple SQL custom calculations
• More flexible reporting (subtotals, etc.)
• Operates directly against relational data source
• Transactional view available
• Record-based selection
• More intuitive for users that know SQL
• Getting the data you want
• Analyzing your data
• Sharing your data with others
• Reduce the amount of data by using Conditions
• Create a new workbook, if necessary.
• Open the workbook that contains the data you want




Disadvantages –
• Need For Users to Know Underlying DB structures and/or SQL
• Weak security, either public or private, unless installed as part of Oracle Apps

Thursday, December 17, 2009

Output Post Processor was down

Actual process of concurrent manager Output Post Processor is 0 and target process is 1.

To implement the solution, please execute the following steps:

1. Telnet to application tier server via OS user applmgr, and source the env file
$APPL_TOP/APPS_hostname.env.

2. Shutdown concurrent server via command adcmctl.sh under
$COMMON_TOP/admin/scripts/

3. To ensure concurrent manager down; check there is no FNDLIBR process running.
ps -ef | grep applmgr | grep FNDLIBR

4. Run adadmin to relink FNDSVC executable.


1. Invoke adadmin from command prompt
2. Choose option 2 (2. Maintain Applications Files menu)
3. Choose option 1 (1. Relink Applications programs )
4. Then type "FND" When prompted; ( Enter list of products to link ('all' for all products) [all] : FND )
5. Ensure adrelink is exiting with status 0


5. Start Concurrent Managers using adcmctl.sh

6. Retest the issue.

7. Migrate the solution as appropriate to other environments.

please look into ID 858813.1

AutoPatch error:ERROR [code=-119] compiling out of date JSP files An error occurred while compiling JSP files.

Make sure $COMMON_TOP/_pages/_oa__html does exist.

You can continue applying the patch as normal.
It is not necessary to compile all the jsp pages in adpatch. They can be compiled when accessed via the browser. When starting adpatch there is an option you can use -option=nocompilejsp
This way the compilation will not take place.
Any old jsp pages in the cache directories will be automatically recreated when called via the browser.


Please look into ID 296129.1