In this Document
Goal
Solution

---

Applies to:

Oracle Application Object Library - Version: 11.5.10
Information in this document applies to any platform.

Goal

How to analyze OPP failover and which data to upload to Global Support Services. 查看全文

Solution

-- To implement the solution, please execute the following steps:

- Login to Apps with Sysadmin responsibility
- Navigate to Profile -> Site
- Query for profile option 'RRA:enabled'
- Set Profile Option 'RRA:enabled' to 'yes'
- Bounce the concurrent managers
- Logout of apps client and re-login 查看全文

Symptoms

When trying to get to the supplier registration page getting the error for http
Exception:
java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001:
FND_CANT_INSERT_USER_ROLE (USERNAME=GUEST)
(ROLENAME=FND_RESP|POS|POS_SUPPLIER_GUEST_USER|STANDARD)
(ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has been detected in
FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT.
ORA-06512: at "APPS.APP_EXCEPTION", line 70
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 29
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 583
ORA-06512: at "APPS.POS_ANON_PKG", line 104
ORA-06512: at line 1

Cause

The root cause is that FND.H changes fnd_user_resp_groups from a table to a view which return
end_date as year 9999 instead of the value of null in the underlying data. The code in
confirm_has_resp expects the end_date of the pos guest user resp to user guest to be null, and if
not, trying to insert the assignment and fail (because the assignment already exists and active).

Development provide the cause in bug 3610633

Solution

To implement the solution, please execute the following steps:

1. Please download and review the readme and pre-requisites for Patch:4336588

2. Please apply Patch:4336588 in a Test environment.

3. Please Bounce the Apache Server and Middle Tier Server after applying patch.

4. Please confirm the following file versions:

POSANONB.pls version 115.6.1159.3

You can use the commands like the following:
strings -a $XX_TOP/filename |grep '$Header'

5. Please retest the issue.

6. If the issue is resolved, please migrate the solution as appropriate to other environments.

The test should be done by first sending a new invitation to register, then once the
invitation is received, click the link in the email to respond.

BUGS

Bug 4336588 ONE-OFF BUG 3610633 ACCESSING SUPPLIERREGISTER.JSP GETS ORA-20001

Relevance Review

Checked for relevance on 08-Jan-2007.

The functionality discussed in this article is used only up to and including Oracle Process Manufacturing (OPM) 'G' (Applications Release 11.5.6).
From OPM 'H' onwards Purchase Order Receiving for OPM Items is carried out in the Oracle Purchasing application, so Purchase Orders are no longer interfaced into the Process Manufacturing tables.

Overview

In 11i of Oracle Process Manufacturing (OPM), Purchase Orders are created in Oracle Purchasing and through triggers and concurrent processing those PO’s come across to OPM. The receipts are then entered on the OPM side using one of three options. Quick Receiving, Regular Receiving or Stock Receiving and again through triggers and concurrent processes the receipt information is transferred back to Oracle Purchasing. The Receiving Transaction Processor (RTP) is responsible for taking the receipt information and bringing it to Oracle Purchasing.

This document only covers once you have created a receipt on the OPM side and you are not able to see the information reflected on the Oracle Purchasing side.

After finding the error message in the po_interface_errors table and fixing the issue, the user should run the OPM Receiving Transaction Processor Request Set. This concurrent manager process will kick off four processes. These processes will reset the status codes and then re-process the receipts.

Patches to apply

Check Metalink for the lastest consolidate Oracle Process Manufacturing Logistics patches for purchasing to apply for receiving issues.

Steps to troubleshooting

 查看全文

Solution

1:- Can use this SQL statement to count concurrent_users in Oracle apps:
select count(distinct d.user_name) from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1)

2:- In the Oracle Applications Manager, go to the site map, and select the "Applications Usage"
option in the Activity region. There you will be able to report on many usage questions, such as:

Products Installed
Application Users Per Module Summary
Applications Usage Reports
Suppliers
Purchase Line Items Processed - Internet Supplier Portal
Purchase Line Items Processed - Purchasing Intelligence
Order Entry Lines Processed - Ordering Application
Purchase Line Items Processed - iProcurement
Expense Reports Processed - Internet Expense
Invoice Line Items Processed - Accounts Receivables

Note the Application Users per module summary is based on the number of users that have Active responsibilities for the Application module. I am not aware of there being any check on last usage date for the responsibility.

3:- Also if you are using responsibilities connected to a custom-application, which is standard Consulting practice in some countries, those users will be counted as users of the custom-application and not users of the actual Application-module for the screens they are accessing.

4:- Run the following queries:-
This will give the number of users on the system in the past 1 hour.
select count(distinct user_id) "users" from icx_sessions where last_connect > sysdate - 1/24 and user_id != '-1';

This will give the number of users on the system in the past 1 day.
select count(distinct user_id) "users" from icx_sessions where last_connect > sysdate - 1 and user_id != '-1';

This will show the activity in the last 15 minutes.
select limit_time, limit_connects, to_char(last_connect, 'DD-MON-RR HH:MI:SS') "Last Connection time",

user_id, disabled_flag from icx_sessions where last_connect > sysdate - 1/96;

5:- Check the Note:233871.1 which will list users logged into Self Service Web Application, users logged into forms, and users running concurrent programs.

Surely this will affect the performance but how it affects is based on the number of users logged in and accessing the forms.

Factoring in System Overhead
========================

In planning your organization€™ Sign€“On Audit implementation, you should consider the additional system overhead required to precisely User and Data Auditing monitor and audit your users as they access Oracle Applications. The more users you audit and the higher the level of auditing, the greater the likelihood of incurring additional system overhead.

Cause

There was another "OAM Applications Dashboard Collection" which was running during the same period .

Solution

 查看全文

Solution

 查看全文

Fact(s)
~~~~~~~~
Oracle Server - Enterprise Edition 8.1.X TO 9.X

Symptom(s)
~~~~~~~~~~~

How to coalesce a partitioned index.

Cause
~~~~~~

If you use the following command applied on the whole index:

ALTER INDEX <index name> COALESCE PARTITION;

You will get this error message:

ORA-08111: a partitioned index may not be coalesced as a whole

Fix:
~~~~

You must use the following command on each partition as below:


It gives you the means to compact the space used in each block of the
corresponding index partition.
 查看全文

tables desc 查看全文

Applies to:

Oracle Inventory Management - Version: 11.5.9
This problem can occur on any platform.
EXECUTABLE:INCTCW - Inventory transaction worker

Symptoms

Find transactions in the transaction open interface table (MTL_TRANSACTIONS_INTERFACE) with
the following error.
Also find the following error in the log file.
Resubmitting the transactions does not allow them to process.

ERROR: IN TABLE
oracle error

ERROR: IN LOG
Set and get global variables for date,time,user,encoding,profile values
Error in get_profile_values
ERROR CODE = -6502
ERROR MESSAGE = ORA-06502: PL/SQL: numeric or value error: character to number conversion error

STEPS
1. Goto Inventory > Transactions > Transaction Open Interface
2. The find window appears
3. Enter the query criteria.
4. Press Find.
5. The transactions appear showing the error.

BUSINESS IMPACT
Due to this issue, users cannot process transactions.

VERIFICATION
The following SQL verified the issue existed:

select from MTL_TRANSACTIONS_INTERFACE
/
Shows the error "Oracle error"

 查看全文

In this Document
Goal
Solution
1. Which program do I run?
a. Program for 11.5.9 and 11.5.10
b. Program BEFORE 11.5.9
2. What purges were run?
References

---

Applies to:

Oracle Inventory Management - Version: 11.5.9 to 11.5.10
Information in this document applies to any platform.
EXECUTABLE:INCTPG - Upgrade Encumbrance balances
ConcurrentProgram:INVGTPG - Global Transaction Purge
ConcurrentProgram:INVTMLPR - Transaction Purge

Goal

The following answers various questions about the transaction purge.

Solution

1. Which program do I run?

What is the correct purge program to be used to purge Inventory Transactions from the inventory transaction history table (MTL_MATERIAL_TRANSACTIONS)? For example, is there any difference between "INCTPG Purge transaction history" and "INVGTPG Global Transaction Purge"?

 查看全文

Applies to:

Oracle Inventory Management - Version: 11.5.9
This problem can occur on any platform.

Symptoms

On 11.5.9 in Production:
For pick wave move orders created through the pick release process, for lot and serial controlled items, the serial number appears to disappear when trying to transact the lot/serial move order line, and the below error occurs.

ERROR
APP-INV-05501: Transaction(s) Failed

STEPS
The issue can be reproduced at will with the following steps:
1) Create sales order, schedule and book the sales order
2) Run pick release with the following parameters:
Autocreate deliveries = Yes
Auto allocate = Yes
Auto Pick Confirm = No
Warehouse filled
Staging subinv filled
3) Go to Move orders => Transact Move Order
4) Update allocations select another item revision => click in lot/serials button
5) Update the lot, the serial, click ok => done
6) Click in update => select the line and transact => the error is received
7) Checking the serial entered, it has disappeared, it has been cleared

Cause

In transact move order form of Oracle inventory, if the lot number of a pick wave move order is changed in the lot entry form giving the corresponding serials, then the given serials are lost on re-opening serial entry form for the first time after changing the lot.

This issue has been fixed in the file INVSLENT.pld version 115.103.11590.46

This is explained in the following bug:
Bug.5648713: APP-INV-05501 SERIAL NUMBERS DISAPPEAR FROM TRANSACT MOVE ORDERS

Solution

 查看全文

Creating a 10gr2 Data Guard Physical Standby database with Real-Time apply 查看全文

TIP: Click help for a detailed explanation of this page. Bookmark Go to End Subject: Cannot Republish Files Whose Output File Size Is Greater than 0.5MB Doc ID: Note:438348.1 Type: HOWTO Last Revision Date: 27-AUG-2007 Status: MODERATED In this Document Goal Solution References This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. Applies to: Oracle Application Object Library - Version: 11.5.10.2 Information in this document applies to any platform. Goal When trying to republish an existing concurrent request, you get the following message : The output file size is greater than 0.5MB and cannot be processed . If it's a soft limit, is there a way to change it's value ? Solution You cannot view a report larger than 0.5MB. This is a built-in limitation (done on purpose) to avoid trying to view a HUGE report. The issue is not related to republishing , it is related to viewing. This is a hard limit when viewing the report. Please try to Republish and Printing it instead of Republish and Viewing the reports larger than 0.5MB. References Bug 5696178 - 5690358: A REPUBLISH AND VIEW OF XML FAILS WITH INTERNAL SERVER ERROR

Applies to:

Oracle Application Object Library - Version: 11.5.8
Information in this document applies to any platform.

Goal

How can you restrict an user from modifying information on a form?

Solution

You should create a custom form function with read-only "rights" by duplicating the seeded one and specify the QUERY_ONLY=YES parameter for the form function. Here are the steps you should follow for accomplishing this goal:
1. Login as System Administrator and navigate Application -> Function
2. Search for your form function
3. Create a new form function TEST_FUNCTION and use exactly the same attributes as the original one has
4. For the Parameters field in Form tab complete the field with QUERY_ONLY=YES
5. Save the function and navigate Application -> Menu and assign the newly created function to a menu
5.1. If you want you can create a new responsibility and assign the menu to it (use Security -> Responsibility -> Define)
6. Assign the responsibility containing the custom function to a user and test the issue

Keywords

---

Applies to:

Oracle Alert - Version: 11.5.10
This problem can occur on any platform.

Symptoms

Periodic Alert Scheduler gets de-activated automatically after a couple of days.

Setting up frequency with check interval in Alerts does not work.

Changes

Have recently upgraded to Apps 11.5.10 or 11i.FND.H, 11i.AD.I , 11i.ALR.G, FLEXRUP.I (3167649)

Cause

Problem with "fdprrc.lpc" version 115.24 , cause being incorrect handling of arguments.

Solution

Download and apply Patch 4173121.
Patch delivers "fdprrc.lpc" file version 115.25

 查看全文

In this Document
Goal
Solution
References

---

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Alert - Version: 11.5.9 to 12.0.3
Information in this document applies to any platform.

Goal

How to resolve the error:
APP-ALR-04110: Oracle Alert found an invalid number of bind variables in the SQL Statement?

Already done:
Set CURSOR_SHARING = EXACT in init.ora
Applied Patch 5566786 ALERTS FAILING AFTER APPLICATION OF PATCH (ATGRUP4 -4676589)

Solution

From the Oracle Alert User's Guide, page 2-14:

 查看全文

In this Document
Symptoms
Cause
Solution
References

---

Applies to:

Oracle Alert - Version: 11.5.10
This problem can occur on any platform.

Symptoms

When running Oracle Alerts, bind variables are replaced by actual value instead of variable.

Example:
Alert Select statement:
SELECT po_header_id, vendor_id, agent_id, :ROWID
INTO &po_id, &vend_id, &agent_id, &ROWID
FROM po_headers_all
WHERE ROWID = :ROWID

 查看全文

PURPOSE
This document gives general advice on the use of TKPROF.

SCOPE & APPLICATION
For users needing advice on how to use TkProf.

Tkprof is an executable that 'parses' Oracle trace files to produce more
readable output. Remember that all the information in TkProf is available
from the base trace file.

If you have a system that is performing badly, a good way to identify
problem SQL statements is to trace a typical user session and then use TkProf
to format the output using the sort functions on the tkprof command
line.  查看全文

Error: ORA 19573
Text: cannot obtain %s enqueue for datafile %s
---------------------------------------------------------------------------
Cause: The file access enqueue could not be obtained for a file specified in
a backup or copy operation. If the enqueue type shown is 'shared', then
the file is the input file for a backup or copy. If the type is
'exclusive, then the file is the output file for a datafile copy or
restore which is attempting to overwrite the currently active version
of that file - in this case, the file must be offline or the database
must be closed.
Action: Wait until the conflicting operation is complete, then retry the copy
or backup.

Problem Description
-------------------
You are trying to perform incomplete recovery with a recovery catalog.
You receive the following errors:

RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19573: cannot obtain exclusive enqueue for datafile 1
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE



Solution Description 查看全文

Good 查看全文

Description:
Blocks in the buffer cache are placed on linked lists
(cache buffer chains) which hang off a hash table.
The hash chain that a block is placed on is based on the DBA
and CLASS of the block. Each hash chain is protected by a
single child latch. Processes need to get the relevant latch
to allow them the scan a hash chain for a buffer so that the
linked list does not change underneath them.
 查看全文

PURPOSE
-------

In some situations it may happen your session is 'hanging' and is awaiting for
a 'Library cache lock'. This document describes how to find the session that
in fact has the lock you are waiting for. 查看全文

Applies to:

Oracle Application Object Library - Version: 11.5.10
This problem can occur on any platform.

 查看全文

Applies to:

Oracle Workflow Cartridge - Version: 11.5.10
This problem can occur on any platform.

Symptoms

Custom subscription is defined for event 'oracle.apps.jtf.cac.task.updateTask' in asynchronous mode.
When the event is raised the event messgage is queued in 'WF_DEFERRED'
'Worfklow Agent Listener' is up and running but still the event records in
'WF_DEFERRED" are not getting PROCESSED, it stays in READY 查看全文

Error Correction and Synchronization Program Fails With ORA-20100
	Doc ID:	Note:313176.1	Type:	PROBLEM
	Last Revision Date:	11-MAY-2007	Status:	PUBLISHED

---

Applies to:

Oracle Install Base - Version: 11.5.9
This problem can occur on any platform.
Error Correction and Synchronization concurrent program

Symptoms

The Error Correction and Synchronization concurrent program fails with the following error message in the log file:
**Starts**04-APR-2005 16:20:51
ORACLE error 20100 in FDPSTP

Cause: FDPSTP failed due to ORA-20100: File o0055032.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at "APPS.FND_FILE", line 378
ORA-06512

Cause

The Directory in which the oracle owner is attempting to create the log file
has permissions set so that the oracle owner cannot write to the directory.

Solution

Ensure that the directories specified in the utl_file_dir parameter in the V$PARAMETER table are writeable by the oracle owner.
The profile option CSI: Log File Path must be the first entry in the utl_file_dir parameter.
Make sure that $APPLPTMP and $APPLTMP are set to this same value.
Verify that the profile 'CSI: Log File Path' has a valid directory path (NO trailing slash) and that it is defined in the 'utl_file_dir' parameter. (Select value From v$parameter Where name ='utl_file_dir')
The directory write permissions must be set to allow access to the database owner and the applmgr.
You must restart the application if this profile has changed.
Refer to Note 204016.1 for instructions on updating the utl_file_dir in the init.ora file.

Date 09/01/07: Note reviewed for currency

ORACLE FINANCIAL ANALYZER 6.x FREQUENTLY ASKED QUESTIONS
--------------------------------------------------------


CONTENTS
--------
1. What version of OFA is compatible with what version of OES and GL?

2. Can I extract data from an RDBMS into OFA?

3a. How can I enter Express commands into OFA?
3b. How do I enable the Express Monitor in OFA?

4. Which do I install first on Windows; Client or Server?

5a. What is the Oracle General Ledger Link?
5b. What is the ADI?
5c. What is Single Sign-On?
5d. What is AS Portlets?

6. Can I use more than one OFA client version on a machine?

7. Can an OFA system run in an environment with multiple Windows platforms?

8a. Can more than one OFA system be installed per Server Machine?
8b. Can more than one OFA System be installed per Express Service?
8c. Can more than one Super DBA be installed per OFA system?
8d. Can a shared database have more than one DBA personal database?

9. Can OFA link to more than one Oracle General Ledger
System?

10. How do I cancel a refresh for a user?

11a.How do I tell which version of OFA I am running?
11b.How do I tell which patch level of OFA I am running?

12. Where can I find information on the new features of a version on Metalink?

13. How can I run the task processor without locking up my DBA workstation?

14. Can I use Express Administrator to maintain my OFA database?

15. What are the Operational Modes in the Tools and Application Options screen?

16. How can I change the name of the Shared databases?

17. How do I add a custom code database to OFA 6.x?

18. How do I Export/Import my database?

19. How do I use a datareader to populate dimension values and hierarchies?

20. How do I add a custom menu option to the Tools menu?

21. Which Web Agent Patches do I need to apply?

22. Can I use one Web listener to access both my super and sub?

23. How do I swap between Jinitiator and the browser's native JVM?

24. What are the differences between Data Entry Form's and Worksheets?

25. How can I monitor who is using OFA?

26. How can I improve the performance of my OFA system?



QUESTIONS & ANSWERS

1. What version of OFA is compatible with what version of OES and GL?

Answer
------
The certification martix is regularly maintained and is available on-line
through Metalink by following these instructions:
- Click the "Certify and Availability" button on the left.
- Click the "Certifications" button that now appears across the top
- Select "View Certifications by Product"
- Select "Business Inteligence Analytic Solutions" and click "Submit"
- Select "Oracle Financial Analyzer (OFA) and click "Submit"
- Select your platform and click "submit"
You now have a list of combinations of operating system versions,
OFA versions, and Express Server versions, detailing their certification status.
Depending upon the platform you have chosen, you may see sections labelled
"Server Certifications" and/or "Client Certifications".

For details of certified browsers for use with OFA, click the "Yes" link under
the "Other" column in the "Client" section.

For details of Express Web Agent and Oracle GL, select the "Yes" link in the
"Other" Column in the "Server" section.

================================================================================
2. Can I extract data from an RDBMS into OFA?

Answer
------
The only out-of-the-box functionality that OFA is provided with that allows
data to be extracted from an RDBMS, is the GL-Link, which allows data to be
extracted from the Oracle General Ledger.

Another product is available from Oracle, named OFSA (Oracle Financial Services
Applications) which includes a set of programs which allow data to be extracted
from the Budgeting and Planning Module into OFA.

Any other systems will require custom Express programs to be written in order
to extract the data. See the Express Language Programming Guide for details of
how to extract data directly from an RDBMS using Embedded SQL.

Custom programs cannot be supported by Oracle Support, so you may prefer to
extract the data into a text file and then use OFA's facility to create a
dataloader to read that file.

================================================================================
3a. How can I enter Express commands into OFA?

Answer
------
Express commands may be entered for direct execution on the Express Server
via the "Express Monitor" facility of the OFA client, which is available from
the "Help" menu. There is no facility to enter commands directly via the web
interface for OFA.


3b. How do I enable the Express Monitor in OFA?

Answer
------
You must add the following line to the [Tools] section of your OFA.INI file:

ExpMonitor=yes

References
----------
Note 1037639.6 Entering Express Comands From OFA 6.X


================================================================================
4. Which do I install first on Windows; Client or Server?

Answer
------
The Client will need to have a server to reference, so it makes sense to install
the server first. However, if you have already installed the client, these
settings can be easily changed during the client startup to point to a different
location.

References
----------
Oracle Financial Analyzer Installation guide


================================================================================
5a. What is the Oracle General Ledger Link?

Answer
------
The Oracle General Ledger Link enables you to extract data from an Oracle
General Ledger system and import it into OFA for analysis.

You can also use the write-back functionality of the OFA GL-Link to transfer
budget data back to the GL via the GL Budget interface table.


5b. What is the ADI?

Answer
------
The Applications Desk-top Integrator (ADI) is a device which allows users to
get detail data from the Oracle GL. It is supplied as part of Oracle
Applications, and may be used in conjuntion with OFA to drill to GL detail
information in reports displayed in the Client/Server Interface. The FDI's must
have been loaded into OFA using the GL-link.


5c. What is Single Sign-On?

Answer
------
Single Sign-On (SSO) allows users of Oracle Applications to access OFAWeb
directly from their Applications system without needing a separate Operating
System user ID, and without the need for the user to provide authentication
credentials to OFA after logging in to Applications. SSO is available from OFA
version 6.3.1

5d. What is AS Portlets?

Answer
------
AS Portlets is a portal provider which allows OFA reports to be viewed in
Oracle Portal. AS Portlets is available as a patch to OFA version 6.3.2, and
are included with OFA 6.4.0


================================================================================
6. Can I Use more than one OFA client version on a machine?

Answer
------
In general, NO.
Each OFA version requires specific versions of certain DLL's and OCX's to be
registered in the Windows Registry. These files are generally incompatible
between versions. The only exception to this rule is the 6.3.2 and 6.4.0
versions of OFA which share common versions of these files. The use of "Thinner
Client" installations does not avoid this.

You can however, access multiple OFA workstations from one client machine,
provided they are from the same version of OFA.

================================================================================
7. Can an OFA system run in an environment with multiple Windows platforms?

Answer
------
Yes, so long as each component is installed on a platform which is certified
for its version. There is no requirement for OFA to be installed purely on
Windows NT, for example.

See Q.1 for more information on the certification matrix.

================================================================================
8a. Can more than one OFA system be installed per Server Machine?

Answer
------
Yes. You may have more than one OFA server component installed on a single
machine.


8b. Can more than one OFA System be installed per Express Service?

Answer
------
Yes, provided each system is exactly the same version and patch level of OFA.
If you require your server to run different versions of OFA you will need to set
up different services so that they can be configured to use the correct version
of web agent and OFA code databases.


8c. Can more than one Super DBA be installed per OFA system?

Answer
------
No, this is not supported by OFA. Only one Super DBA is supported per OFA
system. The Super DBA is the top level in the tiered architecture of OFA. This
user defines lower level workstations, creates structures and enters data which
may be selectively distributed to these workstations. An OFA system may have
multiple Sub-DBA workstations. 查看全文

Applies to:

Oracle Applications Technology Stack - Version: 11.5.10.2
This problem can occur on any platform. 查看全文

In this Document
Goal
Solution
References

---

Applies to:

Pasta - Version: 11.5.9
Information in this document applies to any platform.

Goal

How To Print XML Publisher PDF Reports Via The Concurrent Manager?

Solution

01. In order to print XML Publisher reports in PDF format directly from the concurrent manager to a printer you will need to:

a. Have a Postscript ready printer.

b. Install Pasta

c. Install third party software to convert the PDF file to another graphical format that the printer understands, such as Postscript by way of GNU utility ps2pdf--often found packaged with software like Ghostscript.

02. Verify that Pasta in general is setup as per Note 356501.1 "How to Setup Pasta Quickly and Effectively"

NOTE: Reference the following documents for more details information on setting up Pasta or XML Publisher:

239196.1 PASTA 3.0 Release Information, particular the "Pasta User's Guide 3.0"
240864.1 IX Library: Configuration
189708.1 Oracle Reports 6i Setup Guide for Oracle Applications 11i

337999.1 About Oracle XML Publisher Release 5.6
316447.1 About Oracle XML Publisher Release 5.5, particularly step 8

03. Configure Pasta for PDF printing of XML Publisher reports.

a. Verify that the printer type "--Pasta Universal Printer Type" is associated with your printer and that the seeded "PDF Publisher" print style and PASTA_PDF printer driver are associated with this printer type.

b. Ensure that the third party tool "acroread" or "pdftops" or "pdf2ps" has already been installed in your instance.

$ which acroread
$ which pdftops
$ which pdf2ps

NOTE 2: There has been known issues with earlier version of Ghostscript. Development recommends obtaining the latest available version of Ghostscript (pdf2ps) or moving to another open source solution such as Xpdf (pdftops). More information about Xpdf can be found at http://www.foolabs.com/xpdf However, the Adobe acroread tool provides an equivalent hardcopy printout as achieved via the browser’s Acrobat Reader viewer.

c. Verify that the file $FND_TOP/resource/pasta_pdf.cfg is present and that it contains only one "uncommented" entry corresponding to the installed third party tool, as follows:

preprocess=acroread -toPostScript -pairs {infile} {outfile}
or
preprocess=pdftops {infile} {outfile}
or
preprocess=pdf2ps {infile} {outfile}

d. Print your XML generated PDF report with the "PDF Publisher" print style.

NOTE 3: EBS is not seeded with a working "PDF Publisher Landscape" example. Custom reports typically will required custom drivers that will accommodate the layout and text of the report. See Note 421358.1 "Custom Landscape Reports In PDF Format Print In Portrait Orientation"

Note 421358.1 "Custom Landscape Reports In PDF Format Print In Portrait Orientation"

References

Note 367394.1 - About Oracle XML Publisher Core Rollup Patch 5.6.2
Note 420019.1 - Pasta Overview
Note 356501.1 - How to Setup Pasta Quickly and Effectively
Note 333504.1 - How To Print Concurrent Requests in PDF Format
Note 239196.1 - PASTA 3.0 Release Information
Note 240864.1 - Activating and Configuring IX Library
Note 189708.1 - Oracle Reports 6i Setup Guide for Oracle Applications 11i

Applies to:

Oracle Workflow Cartridge - Version: 11.5.10.2
Information in this document applies to any platform.

Goal

How to Start Workflow Service Component Containers?

Solution

1.Login to OAM
2.Navigate to Workflow Manager
3.Click on Service Components
4.Under column container click on Workflow Agent Listener Service
5.From drop down list at the top of the page , choose start all then click on Go button
6.Once three service containers are activated , all service components with startup mode
automatic shall be up and running

Applies to:

Oracle Application Object Library - Version: 11.5.10
This problem can occur on any platform.

Symptoms

After enabling Table Monitoring in Oracle Applications 11i according to:
Oracle Common Application Components Implementation Guide (B12394-02), running gather schema
statistics with (AUTO) option, causes it to hang with table (CS.DR$CS_KB_SETS_TL_N3$K) or orther DR$ tables.

Cause

The basic problem here is that the FND_STATS package makes a call to dbms_space.unused_space() for
the IOT in question. This raises an ORA-03211 which is caught by an exception handler and
processing then continues but we RETAIN the rowcache enqueue that we had acquired when trying to
invoke dbms_space.unused_space().
Later, the package then tries to execute the "alter table .. monitoring" command and this blocks
as it requires an exclusive rowcache entry.

The following justifies how the issue is related to this specific customer:
Gather Schema Statistics hangs causing ORA errors at the customer.

This is explained in the following bugs:
Bug 5564085: GATHERING SCHEMA STATS HANGS
Bug 5685189: GATHER AUTO MODE WAITING ON DR$IBE_CT_IMEDIA_SEARCH

Solution

1. Download and review the readme and pre-requisites for Patch 5685189.

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.

Note: The above patch was released for 10g R2 database. If you can't find it for your database version then open an SR asking for a backport patch.

References

Bug 5685189 - GATHER AUTO MODE WAITING ON DR$IBE_CT_IMEDIA_SEARCH
Bug 5886183 - APPS:GATHER SCHEMA STATISTICS AUTO NOT EXCLUDE TABLES IN FND_EXCLUDE_TABLE_STATS

Applies to:

Oracle Application Object Library - Version: 11.5.9
Information in this document applies to any platform.

Goal

You run Audit Trail on several tables, and know about the functionality, but somehow, it doesn't
seem possible to audit the FND_USER table.
The table does not appear on the Audit table picklist when you try to create an Audit Group.

How to enable the table FND_USER in the audit group ?

 查看全文

goal: How to manually change the APPLSYS, APPS and APPLSYSPUB passwords for
Applications

fact: Oracle Application Object Library

 查看全文

Applies to:

Oracle Application Object Library - Version: 11.5.10.2
This problem can occur on any platform.

Symptoms

An end-dated user should be re-activated again. Re-activated user can login but cannot see his/her responsibilities.

The issue can be reproduced at will with the following steps:
1. Login to 'Sysadmin' responsibility
2. Navigate to: 'Security' => 'User'
3. Query for the end-dated user
4. Set "Effective Date to" for the user = null
Set "Effective Date to" for the users responsibilities = null
gave him a new password

The issue has the following business impact:
Due to this issue, the system administrator cannot re-activate user.
Re-Activated users can login to the system, but cannot see their responsibilities.

Cause

FND_USER_RESP_GROUPS_API.sync_roles_one_resp_secgrp is not setting the status to ACTIVE
when calling WF_LOCAL_SYNCH.Propagate_Role() for the old role name format.


FND_USER_RESP_GROUPS_API.sync_roles_one_resp_secgrp() does not pass
WFSYNC_OVERWRITE when calling WF_LOCAL_SYNCH.Propagate_Role()

This happens for all versions of file AFSCURGB.pls <= 115.54.

If a user/role relationship refers to a user or a role that does not exist in WF_LOCAL_ROLES,
it should remove the relationship.

If a user/role relationship is duplicated with users and roles that do exist then it should select one
of the records based on priority of 'FND_USR', registered originating system, non-registered
originating system and log the decision using WF_LOG and correct the assignments so that
these records would not appear in the result sets for the corrective measures down the line.

This issue is described in unpublished Bug:4719658:
MISSING RESPONSIBILITIES PATCH VERSION 2

Solution

Make sure that you have AFSCURGB.pls = 115.55 or greater.
This could be archived by applying Patch 4719658

To implement the solution, please execute the following steps:

1. Please download Patch 4719658
ONE OFF PATCH FOR MISSING RESPONSIBILITIES
and review the readme and pre-requisites
2. Please apply any required pre-requisite patches and Patch 4719658 in a Test environment.
This patch will install the following file:
FND: patch/115/sql AFSCURGB.pls 115.55
3. After the patch is installed, run the Workflow Directory Services User/Role Validation
concurrent program
4. Please retest the issue.
5. If the issue is resolved, please migrate the solution as appropriate to other environments.

TIP: Click help for a detailed explanation of this page. Bookmark Go to End Subject: Diagnostics, Tracing and Debug Guide for Oracle Discoverer 4i (4.1) Doc ID: Note:273928.1 Type: TROUBLESHOOTING Last Revision Date: 29-JUN-2006 Status: PUBLISHED Diagnostics for Discoverer 4i Part I – About Discoverer Diagnostics for 4i 4 1 Introduction.. 5 Purpose. 5 Audience. 5 Terminology. 5 How To Use This Document 5 Further Information. 5 Part II – Discoverer Specific Diagnostics.. 7 2 Component Diagnostics.. 7 Discoverer Administration Edition. 7 Validate Folders. 7 EUL Business Area. 7 Query Execution UI’s. 7 Overview. 7 QPP Statistics Business Area. 7 Workbook Dump Utility. 7 SQL Execution Plan. 8 Discoverer Plus. 8 Using The Java Console. 8 How To Debug Jinitiator 9 Discoverer Viewer 9 Lower Level Diagnostics. 9 3 Discoverer Internals.. 9 EUL. 9 Overview. 99 Example DiagLevel Setting. 10 Server 11 Overview. 11 Starting the Server with Logging Enabled. 11 Example Output 11 Model 12 Overview. 12 logkeys settings. 12 Activating logging via the logkeys setting in Discoverer Plus. 13 Activating logging via the logkeys setting in Discoverer Viewer 4i 13 On Screen Logging Information for Viewer 15 4 Performance and Scalability Diagnostics.. 15 5 Installation Diagnostics.. 16 Overview.. 16 ORACLE iAS with Discoverer 4i on NT. 16 Logging Installation Actions. 16 Viewing Installation Log Files. 16 Obtaining a List of Products Installed. 16 ORACLE iAS with Discoverer 4i on Solaris. 16 Logging Installation Actions. 16 Viewing Installation Log Files. 16 Obtaining a List of Products Installed. 16 6 Discoverer Diagnostics Tool for 4i 17 Overview. 17 What is the Diagnostics Tool?. 17 What checks does the Diagnostics Tool perform?. 17 Diagnostics Tool Installation. 17 Manual Diagnostics Tool Installation. 18 How to run the Diagnostics Tool 18 An example of the output from the Diagnostics Tool 18 What are the limitations of the Diagnostics Tool?. 18 Part III – Non-Discoverer Diagnostics.. 18 7 Debugging Summary problems.. 19 Investigating PL/SQL summary components. 19 Re-compiling Packages and Procedures. 19 Finding the Summary Common Package. 19 Finding the Summary Refresh Set Package. 19 Finding the Summary Base Object Package. 19 Finding the Summary combination refresh procedures. 19 Confirming Query Rewrite is Occurring. 20 Check Query Options. 20 Check Summary State. 20 Checking the Materialised View. 20 Using Explain Rewrite. 20 8 Discoverer Specific Database Diagnostics.. 21 Overview.. 21 Oracle 600 Errors. 21 SQL TRACE.. 21 9 Discoverer Specific Oracle Applications Diagnostics 23 Overview.. 23 Scope of the Discoverer Specific Oracle Applications Diagnostics. 23 Availability of the Discoverer Specific Oracle Applications. 23 Enabling the Discoverer Specific Applications Diagnostics. 23 Discoverer Specific Oracle Applications Diagnostic Output 23