Oracle World: Feb 27, 2012

Monday, February 27, 2012

Report Server engines configuration best practices, the 'maxEngine' parameter configuration

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Report Server engines configuration best practices, the 'maxEngine' parameter configuration

Solution:

As per Oracle's recommendation, in a server where the Reports Server(s) is / are running, there should be maximum 2 to 3 engines per CPU for optimum performance. This is a cummulative figure irrespective of the number of Reports Server(s) running in that server. Thus, it is recommended to optimally set the "maxEngine" parameter (corresponding to the engine id "rwEng") for each of the Reports Server(s) as follows :

Recommended number of maximum Total number of
'maxEngine' for engines (2 or 3) per CPU x CPU(s) in the server
each Reports Server = -------------------------------------------------------
Total number of Reports Server(s) running in the server

For example, in case of a server having 4 CPUs and 2 Reports Servers running in that server, it is recommended to set the 'maxEngine' parameter for each of the Reports Servers to "4" based on the following calculation :

2 x 4
'maxEngine' of each Reports Server = ----- = 4

Hence, at any point of time, the maximum number of engines that can be active simultaneously for both the Reports Servers running in that server is 4 x 2 = 8.

However, if the utilisation of any of the Reports Server(s) is less compared to the other Reports Server(s) running in that server, then the 'maxEngine' parameter setting for the Reports Server(s) needs to be tuned appropriately. In case of the above example, the 'maxEngine' parameter for the less utilised Reports Server can be decreased from 4 to 2 and that for the mostly utilised Reports Server can be increased from 4 to 6. The point that needs to be kept in mind is that, even with the modified 'maxEngine' parameter settings, the maximum number of engines that can be active simultaneously for both the Reports Servers running in that server is 2 + 6 = 8.

Get Oracle Certifications for all Exams
Free Online Exams.com

udump generates after control file autobackup

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: udump generates after control file autobackupLog files: Alert Log file Starting control autobackup Tue Nov 10 09:20:55 2009 Errors in file e:\oracle\product\10.2.0\admin\dnadb\udump\dnadb_ora_3384.trc: Tue Nov 10 09:20:55 2009 Errors in file e:\oracle\product\10.2.0\admin\dnadb\udump\dnadb_ora_3384.trc: Tue Nov 10 09:20:55 2009 Errors in file e:\oracle\product\10.2.0\admin\dnadb\udump\dnadb_ora_3384.trc: Control autobackup written to DISK device handle 'E:\BACKUP\RMAN\DNADB\BACKUPSETS\CONTROL_DNADB_C-3965614685-20091110-00.CTL' Tue Nov 10 09:21:08 2009 Solution: From the alert.log and trace file there is no error message. Also the control file auto backup completed successfully. hence you can ignore this message

Get Oracle Certifications for all Exams
Free Online Exams.com

Is it possible to deactivate the required field Need by Date in Sourcing Line?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Is it possible to deactivate the required field Need by Date in Sourcing Line?

Solution:

I have done a research of this issue and have found following explanation on this issue:
quote
Adding the comments for clarification on why this change was made
.
Currently, need by dates are not required in the create flow, but Promise
date is always required in the bidding flow if the outcome is Standard
Purchase Order.
We want to relieve the restriction that promise date is required in the
bidding flow, as it turns out that PO does not require it all the time. PO
requires need by date or promise date only for certain types of items.
.
Solution:
In the create flow, if the line has an inventory item that is a "planned"
item, EITHER the need by from OR the need by to date is required. If it is
a one item in sourcing or if the inventory item is NOT a planned item, we
should keep these 2 fields optional.
.
In the bidding flow, we should always try to default the promise date to the
'need by to' date, if that is null then default the 'need by from' date. If
both are null, promise date remains null. The ONLY case the promise date
will be required is when the need by dates are scored.
.
For the create po process, we should be passing in both the need by dates on
the line as well as the promise date on the bid, so we are okay. PO's
autocreate API will work if either one of these fields are entered, if the
item is a planned item as per the PO logic.
.
An item is a "planned item" if in MTL_SYSTEM_ITEMS table,
INVENTORY_PLANNING_CODE in (1, 2) or MRP_PLANNING_CODE in (3, 4, 7, 8, 9)
.
Also, for bidding by spreadsheet
The * next to the Promise date column will be removed and the current tip to
indicate when promise date is required will still be there(* next to line
number if required/ # if optional). The logic to show the '*' next to the
line number if promise date is required will change based on the above new
conditions.
unquote

So Development has made here a change which cannot be changed by personalization.
This only can be done via code change.
There is already existing an Enhancement Request:
ER 5066191 : NEED-BY DATE REQUIRED ERROR SHOULD BE MORE DESCRIPTIVE
quote
1. PROBLEM DESCRIPTION:
When creating an RFQ and adding items like CM13139 that have
attributes such as "inventory planned" (or whatever it's called)
you get an error message stating that "need-by date is required
for line X." This is confusing for the end user, especially
because the field is not visibly marked as required.
2. EXPECTED BEHAVIOR:
The system should either dynamically mark the field as required
based on the item chosen or at least provide a more descriptive
error message (eg, "need-by is required for line X because the
selected item is inventory planned.").
unquote
See that this will be implemented in R15.

Get Oracle Certifications for all Exams
Free Online Exams.com

FAILED: file perzzlookup00760.ldt on worker 1

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: ATTENTION: All workers either have failed or are waiting:FAILED: file perzzlookup00760.ldt on worker 1
On Applications 12.0.6 :
Facing errors while applying patch E-Business Suite 12.0.4 Release update pack (Rup 4)patch (6435000).

-- Error
************ Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Thu Dec 10 2009 08:24:46
APPL_TOP is set to /d03/appltest/ADTST/apps/apps_st/appl
Done.
ATTENTION: All workers either have failed or are waiting:
FAILED: file perzzlookup00760.ldt on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Log files:
LOG FILE
-----------------------
Filename =US_perzzlookup00760_ldt.log
See the following error:
Current system time is Wed Dec 9 14:23:30 2009

Uploading from the data file /d03/appltest/ADTST/apps/apps_st/appl/per/12.0.0/patch/115/import/US/perzzlookup00760.ldt
Missing closing quotes from quote started at line 4
Altering database NLS_LANGUAGE environment to AMERICAN
Missing closing quotes from quote started at line 4
Missing closing quotes from quote started at line 4
Dumping from LCT/LDT files (/d03/appltest/ADTST/apps/apps_st/appl/fnd/12.0.0/patch/115/import/aflvmlu.lct(120.0.12000000.1), /d03/appltest/ADTST/apps/apps_st/appl/per/12.0.0/patch/115/import/US/perzzlookup00760.ldt) to staging tables
Dumping LCT file /d03/appltest/ADTST/apps/apps_st/appl/fnd/12.0.0/patch/115/import/aflvmlu.lct(120.0.12000000.1) into FND_SEED_STAGE_CONFIG
Dumping LDT file /d03/appltest/ADTST/apps/apps_st/appl/per/12.0.0/patch/115/import/US/perzzlookup00760.ldt into FND_SEED_STAGE_ENTITY
Missing closing quotes from quote started at line 4
Uploading from staging tables

Concurrent request completed

Solution:

The cause for this data has been determined as syntax errors in the file perzzlookup00760.ldt version 120.0.12000000.4.

You have file perzzlookup00760.ldt and version 120.0.12000000.4 which is higher than the version that comes with patch 6435000 (ORACLE E-BUSINESS SUITE 12.0.4 RELEASE UPDATE PACK (RUP4)).

However checking file perzzlookup00760.ldt version 120.0.12000000.4 I've found the following line:

LANGUAGE = "US

please note the missing closing quotes (").
The line should be

LANGUAGE = "US"

Correct syntax error in /d03/appltest/ADTST/apps/apps_st/appl/per/12.0.0/patch/115/import/US/perzzlookup00760.ldt file and then skip the failed worker using adctrl.
Content of perzzlookup00760.ldt 120.0.12000000.4 has been stubbed as per comment in the file:

# Obsoleted for bug 7277065

Therefore there is no need to run this file.

To implement the solution, please execute the following steps:

1. Correct syntax error in /d03/appltest/ADTST/apps/apps_st/appl/per/12.0.0/patch/115/import/US/perzzlookup00760.ldt file.

replace the following line
LANGUAGE = "US
with
LANGUAGE = "US"

2. Use adctrl executable from a different Unix session and use hidden option "8" to skip the worker that has failed.

3. Continue with patch application

4. Migrate the solution as appropriate to other environments.

Get Oracle Certifications for all Exams
Free Online Exams.com

Datapump Export Fails With ORA-39125 And ORA-22813 Operand Value Exceeds System Limits

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Datapump Export Fails With ORA-39125 And ORA-22813 Operand Value Exceeds System Limits

A full export fails with the following errors:

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA]
ORA-22813: operand value exceeds system limits
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6234
----- PL/SQL Call Stack -----
object line object
handle number name
3cc96edb8 14916 package body SYS.KUPW$WORKER
3cc96edb8 6293 package body SYS.KUPW$WORKER
3cc96edb8 2339 package body SYS.KUPW$WORKER
3cc96edb8 6854 package body SYS.KUPW$WORKER
3cc96edb8 1259 package body SYS.KUPW$WORKER
4e9a30880 2 anonymous block
Job "BKPADM"."SYS_EXPORT_FULL_04" stopped due to fatal error at 15:13:13

Symptoms:

expdp bkp/passwd dumpfile=dp_adp:expdp_adp-`date +%d%m%Y'`.dmp logfile=dp_adp:expdp_adp-`date +%d%m%Y'`.log full=y

Log files:

Solution:

This problem is caused by unpublished Bug 6991626 "EXPORT DATAPUMP FAILS WITH ORA-39126 AND ORA-22813":
Datapump export fails to write large volume data and gives error message "ORA-22813: operand value exceeds system limits".

There is no patch available on top of 10.2.0.3. To solve the issue:

1. Install the latest patchset 10.2.0.4 and then the patch.6991626 available on top of 10.2.0.4 for your platform.
Install the latest patchset 10.2.0.4 and then the patch.6991626 available on top of 10.2.0.4 for your platform.

References:

Note:781638.1 - Datapump Export Fails With ORA-39125 And ORA-22813 Operand Value Exceeds System Limits

Get Oracle Certifications for all Exams
Free Online Exams.com

(ORA-04063:view "Apps.AP_RECURRING_PAYMENTS_V" has errors) when inquiry Recurring invoice

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: (ORA-04063:view "Apps.AP_RECURRING_PAYMENTS_V" has errors) when inquiry Recurring invoice

Symptoms:
Invoices:entry:Recurring Invoices then Ctrl f11 to Inquiry existing recurring Invoices ,an error message displayed (ORA-04063:view "Apps.AP_RECURRING_PAYMENTS_V" has errors)
Log files:

Solution:

The table AP_RECURRING_PAYMENTS_ALL, from which the column pay_awt_group_id is retrieved for the view AP_RECURRING_PAYMENTS_V, does not include a column called pay_awt_group_id.

The cause is justified by the fact that on querying the table AP_RECURRING_PAYMENTS_ALL on
customer's instance, it shows that the pay_awt_group_id does not exist.

1) Please download and review the readme for Patch.7575211.
2) Please apply Patch.7575211 in a test environment.
3) Please confirm the following file versions:
apcinreg.ldt 120.8.12000000.3
You can use the commands like the following:
strings -a $AP_TOP/patch/115/import/US/apcinreg.ldt | grep '$Header'
4) Please retest the issue.
5) If the issue is resolved, please migrate the solution as appropriate to other environments.

References:

Reference Note 872772.1 R12 AP_RECURRING_PAYMENTS_V Invalid After Applying Patch 8627216:R12.AP.A

Get Oracle Certifications for all Exams
Free Online Exams.com

When I open update item,all lines open as one line

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: When I open update item,all lines open as one line

Symptoms:

When trying to enter a bid in oracle sourcing and update the line it always shows the same line regardless on which update icon is pressed.

Solution:

Review Note 222339.1 Procurement Family Patch Release History
and apply the current RUP patch Aug 2009 Update - Patch 8781255 on a test instance and check if the problem is solved.

If the patch does not work, do the following:

Disable Self-Service Personal (FND_DISABLE_OA_CUSTOMIZATIONS ) = YES
POR: Enable Requisition Line Customization (POR_ENABLE_REQ_LINE_CUST ) = NO
POR: Enable Req Distribution Customization (POR_ENABLE_REQ_DIST_CUST ) = NO
POR: Enable Req Header Customization (POR_ENABLE_REQ_HEADER_CUST) = NO
be sure that you see this warning
"Personalization is currently disabled. Your application might not work as expected."
otherwise the personalization is still turned on.

and retry the bidding.

References:

Note 222339.1 Procurement Family Patch Release History

Get Oracle Certifications for all Exams
Free Online Exams.com

As soon as users open the remittance form in Arabic the connection with server is lost, with the following ERROR: FRM: 92101 error.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: As soon as users open the remittance form in Arabic the connection with server is lost, with the following ERROR: FRM: 92101 error.

Symptoms:

Checked Webiv for:
frm-92101 remittance

Bug.8242486/8293537 (36) UNABLE TO OPEN REMITTANCE BANK SCREEN IN ARABIC INTERFACE 3 Bug.5680865/5967377 (36) SYSTEM CRASH WHEN OPENNING THE REMMITANCE FORM IN HEBRW ONLY

From Bug 8242486:
Product: Oracle Receivables (505)
=================================
PROBLEM STATEMENT
-----------------
Unable to open Remittance Bank Screen In arabic Interface
.
arabic language (unable to read) and the error FRM-92101
.
the problems is when open remittance Screen in english interface it is open
and I can overriden bank ....
.
but when i try to open screen in arabic Interface this appear message "Error
In connections " and exit from applications

Oracle Forms Team Bug 8293537 - closed the bug as a duplicate of Bug 5997083

Hence closing this bug as a duplicate of Bug 8293537 . Pl follow the action
plan provided by Forms Team in update *** KKAWAHAR 03/03/09 02:15 pm ***in
Bug 8293537 in Support Environment, and then check the reported issue.
-------------------------
This bug looks like a direct hit for the current problem. According with this bug and with the ACT research which showed there is no desincronisation between US and AR form versions, the issue seems to be a forms problem.

Solution:

Discussing with Oracle Dev it looks like they have stopped providing patches on top of Forms 10.1.2.2 version. Can you please analyze the possibility of upgrading to Forms 10.1.2.3 as per Note 437878.1?

Get Oracle Certifications for all Exams
Free Online Exams.com

Find notes can not be created/attached when using the add amount/replace amount options in the standard budget items function.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: On 12.0.6 in Production:
Find notes can not be created/attached when using the add amount/replace amount options in the standard budget items function.</b>

EXPECTED BEHAVIOR
-----------------------------------
Expect notes to be attached when using the add amount/replace amount options.

Symptoms:
The issue can be reproduced at will with the following steps:
1. PSB responsibility--Worksheet--Modify.
2. Query for an existing worksheet.
3. Select any line to modify.
4. Click on 'Standard Budget Items' button.
5. Note icon becomes active in the main toolbar.

Solution:

The note created in PSB_WS_ACCT1.Create_Note procedure is not assigned to any account line.

This is caused due to the following bug:
Bug 9107577 - NOTES NOT MODIFIED WHEN USING THE ADD AMOUNT/REPLACE AMOUNT OPTIONS IN STANDARD
Apply Patch 9107577.

The patch delivers an upgraded and modified version of PSB_WS_ACCT1.Create_Note procedure on which the code issue is fixed.

References:

The psb user documentation reference is chapter 31 section 7 , point 4-5. Also please refer to the metalink note 737580.1.

Get Oracle Certifications for all Exams
Free Online Exams.com

Negotiation Review Link of the Email Notification Opens the Login Page With Incorrect Language

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Negotiation Review Link of the Email Notification Opens the Login Page With Incorrect Language Symptoms: The login page opens in the language defined in the standard language of the browser and not the preferred language setting of the user defined in preferences. 1) Create a RFQ with an approver. 2) Approver gets email "Approval Required on an RFQ". 3) Approver opens the email . 4) Click on "Negotiation Review" in the email notification. Solution: Cause There is no parameter mentioned in the Negotiation Link to determine the language code for the login page. Resolution A new parameter 'language_code' is added to the Negotiation Link to determine the language code for the login page. Fixed files by release/location and file names of data fix scripts Fixed Files ----------- $PON_TOP/patch/115/sql/ PONWFUTS.pls-120.4.12000000.5 $PON_TOP/patch/115/sql/ PONWFUTB.pls-120.13.12000000.6 $PON_TOP/patch/115/sql/ PONAUCTS.pls-120.11.12000000.1 $PON_TOP/patch/115/sql/ PONAUCTB.pls-120.63.12000000.6 $PON_TOP/patch/115/sql/ PONAPPRS.pls-120.1.12000000.1 $PON_TOP/patch/115/sql/ PONAPPRB.pls-120.9.12000000.5 This is explained in the following bug: Bug 6268467 LINKS IN NOTIFICATIONS BRING UP EBS LOGIN SCREEN IN ENGLISH Solution 1. Download and review the readme and pre-requisites for Patch 6435000 ORACLE E-BUSINESS SUITE 12.0.4 RELEASE UPDATE PACK (RUP4). 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. Confirm the following file versions: $PON_TOP/ patch/115/sql/ PONWFUTS.pls-120.4.12000000.5 $PON_TOP/ patch/115/sql/ PONWFUTB.pls-120.13.12000000.6 $PON_TOP/ patch/115/sql/ PONAUCTS.pls-120.11.12000000.1 $PON_TOP/ patch/115/sql/ PONAUCTB.pls-120.63.12000000.6 $PON_TOP/ patch/115/sql/ PONAPPRS.pls-120.1.12000000.1 $PON_TOP/ patch/115/sql/ PONAPPRB.pls-120.9.12000000.5 The following select will retrieve the versions from the database: select text from dba_source where line = 2 and name in ( 'PON_WF_UTL_PKG', 'PON_AUCTION_PKG', 'PON_AUCTION_APPROVAL_PKG' ); 5. Retest the issue. 6. Migrate the solution as appropriate to other environments. References: Negotiation Review Link of the Email Notification Opens the Login Page With Incorrect Language [ID 839313.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

How to add a browser language setting.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to add a browser language setting

Solution:

1.Open Internet Explorer
2.Click on the Tools menu
3.Click Internet Options
4.On the General tab select Languages
5.Click Add
6.Select the required language. In case you have already more than one language please move the US as first language.
7.Click OK

Get Oracle Certifications for all Exams
Free Online Exams.com

How to remove the "Management Services and Repository" target and add it again.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to remove the "Management Services and Repository" target and add it again.

Solution:

For the Management Services and Repository

1. Logon Grid Control as a super administrator
2. Go to Setup -> Agents; Click on the Management Agent name "acmpsrv61l.auh.police:3872".
3. From the Agent homepage, choose : Add 'OMS and Repository' from the drop down menu. Then, click on 'Go'.
4. In the next page, enter the details for the repository database :

Repository machine name: acmpsrv61l.auh.police
Repository port: 1521
Repository SID : dbgrid
Repository Connect String : (keep this value empty)
Repository User Name : sysman
Repository Password : password for sysman user.

Then click on 'OK'.

5. Verify in the Agent page, that this has been added under the 'Monitored Targets' list.

Get Oracle Certifications for all Exams
Free Online Exams.com

How To Delete and Re-add the target “OMS and Repository” Target in Grid Control?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How To Delete and Re-add the target “OMS and Repository” Target in Grid Control?

Symptoms:

This document describes the steps to be followed for deleting and re-adding the 'OMS And Repository' target type in the Grid Control.
Some of the scenarios where this may be needed are described below:

- The OMS and Agent (on the OMS machine) have not been upgraded at the same time. This can result in the problem described in Note 387881.1 - Oracle Enterprise Manager Grid Control Support Notes for Windows 10g Release 2 (10.2.0.2), Topic: "Independent Upgrade of Oracle Management Service and Central Agent Results in Metric Collection Errors".
To resolve the metric collection errors, the 'OMS and Repository' target needs to be deleted and re-added.

- The 'OMS and Repository target has been discovered from the wrong Agent machine. This target should alwaysbe monitored by the Agent on the OMS machine, irrespective of whether the Repository Database is running on the same machine as the OMS or on a remote machine.

- The 'OMS and Repository' target has been partially discovered i.e there is an entry for the oracle_emrep target in the repository database but the monitoring Agent does not have an entry in its targets.xml file.

Solution:

1) To delete the 'OMS and Repository' target:

Login to Grid Control using sysman user --> Targets --> All Targets --> in the search drop down menu choose "OMS and Repository" then click go --> select the "Management Services and Repository" target appeared the click on remove.
If this target is removed, it is not possbile to view the performance details of the repository anymore. It is not possible to monitor if all of the OMS components are running fine either. Hence, the target should be immediately added back after the removal.

2) Make sure that the OMS and repository target was removed completely:

Login to the repository database as the sysman user and execute:
select target_name, target_type
from mgmt_targets
where target_type='oracle_emrep';

This should not return any rows.

The usual method of checking status of deleted target from Setup --> "Management Services and Repository" --> "Overview" - 'Deleted targets' page is not possible as the 'OMS and Repository' target itself is being deleted.
3) To add the OMS and repository target, follow the steps in Note 289567.1: 'Management Service and Repository' Page in Grid Control Shows 'No Data Available' / Status Down / Internal Error

Note:
In 10.2.0.5 and 11.1 GC, it is not necessary to remove and re-add the 'OMS and Repository' target, if it was originally discovered from the wrong Agent machine. To correct the association, execute:

emctl config emrep -sysman_pwd <sysman password=""> -agent <agent name:port="">
For example:

emctl config emrep -agent omsmachine.domain:3872 -sysman_pwd oracle1

References:

How To Delete and Re-add the target “OMS and Repository” Target in Grid Control? [ID 554835.1]

Note 604311.1: How To Find which Grid Control agent is monitoring the target "OMS and Repository" in case of multiple OMS.

Get Oracle Certifications for all Exams
Free Online Exams.com

The application assigns a Payment Reference Number but not Paper Document Number

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: The application assigns a Payment Reference Number but not Paper Document Number

In Oracle applications 12.0.6
oracle payables

The application assigns a Payment Reference Number but not Paper Document Number

Symptoms:

The Problem started when i have tried to make Bank Transfer Payment The application assigns a Payment Reference Number but not Paper Document Number

PATCH_LEVEL
R12.PAY.A.6
R12.AP.A.6
R12.PA.A.6
R12.CE.A.6
R12.IBY.A.6
R12.IPA.A.6
R12.FPA.A.6

Solution:

1. Download and review the readme and pre-requisites for Patch.9074848:R12.AP.A.
password is valid for 7 days: NI2uiXtU
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. Confirm the following file versions:
ibydapib.pls 120.141.12000000.59
You can use the commands like the following:
strings -a $XX_TOP/filename |grep '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.

Get Oracle Certifications for all Exams
Free Online Exams.com

EXP-00008: ORACLE error 1031 encountered,ORA-01031: insufficient privileges,ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: EXP-00008: ORACLE error 1031 encountered,ORA-01031: insufficient privileges,ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472

Symptoms:
Full database export using export utility give the following warning messages:

EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_B_DOCUMENT_SUBJECT. Index creation will be skipped
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_B_DOCUMENT_SUBJECT. Index creation will be skipped
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_B_DOCUMENT_CON. Index creation will be skipped
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1

Solution:

Cause Determination === Insufficient grants.
Solution === Add grant to the objects.

follow the steps in Note:795492.1, EXP-83 EXP-8 ORA-1031 ORA-6512 On Export After Creating New Database, to check if it's solve your problem.

It's possible you get the problem described in Bug:5530761. For more information please read Note:5530761.8, Bug 5530761 - ORA-1031 from EXP of domain index. Please also read Note:405501.1, Export Ends With Warnings Exp-8 Ora-1031 Exp-78 Exp-78 after CPU install.

The bug is solved in Oracle 10.2.0.4, patch for Oracle 10.2.0.3 on Oracle Solaris on SPARC (64-bit) exist on following link:
http://updates.oracle.com/download/5530761.html

References:
Note:795492.1, EXP-83 EXP-8 ORA-1031 ORA-6512 On Export After Creating New Database

Get Oracle Certifications for all Exams
Free Online Exams.com

Export Ends With Warnings Exp-8 Ora-1031 Exp-78 Exp-78 after CPU install

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Export Ends With Warnings Exp-8 Ora-1031 Exp-78 Exp-78 after CPU install

Symptoms:
Export of schemas which contain domain indexes it is failing after the instalation of CPU from
Jul. or Oct. 2006.

The export it is terminating with warnings but the content indexes are not exported due the following error on SYS.DBMS_EXPORT_EXTENSION:

ORA-01031: insufficient privileges
While exporting bitmap, functional and extensible indexes
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index ACTIONDES_TIDX. Index creation will be skipped

Recently started receiving the errors messages above when doing an export using a non sys or
system user after upgrading from 10.2.0.1 to 10.2.0.3.

Solution:

Cause
BUG:5530761 CPUJUL2006: EXPORT UNABLE TO EXPORT DOMAIN INDEXES
After the installation of CPUJUL2006 on top of 10.2.0.2 the export it is unable to access all the tables even if the user has EXP_FULL_DATABASE role. The export tool is giving warnings on the tables which have context indexes attached.

The BUG is fixed by development on version 11.1 and 10.2.0.4.
Solution
To resolve the problem and export all the objects you have the following options:

To implement the solution, please execute the following steps:

1- Bug 5530761 is fixed in 11.1 and 10.2.0.4 .

2- The workaround is to grant 'select any table' privilege to the exporting user.

3-Apply Patch 5530761 if available

References:

Export Ends With Warnings Exp-8 Ora-1031 Exp-78 Exp-78 after CPU install [ID 405501.1]

BUG:5530761 - CPUJUL2006: EXPORT UNABLE TO EXPORT DOMAIN INDEXES
PATCH:5530761 - CPUJUL2006 EXPORT UNABLE TO EXPORT DOMAIN INDEXES

Get Oracle Certifications for all Exams
Free Online Exams.com

Warning :Total width from all rows in the Row Order 301 exceeds the Column Set Margin 39

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Warning :Total width from all rows in the Row Order 301 exceeds the Column Set Margin 39

Solution:

Cause Determination === Row order incorrectly defined.

Modifying the Row Order widths and/or Column Set column positions would remove the warnings in the log file and the report would not error out.

Modify the Row Order widths and/or Column Set column positions so there is no overlap.

Navigation:-General ledger Reports Define Row Order

References:

Note 397668.1 FSG Reports Completed With Warnings

Get Oracle Certifications for all Exams
Free Online Exams.com