drop and re-create of dbconsole.

 drop and re-create of dbconsole. Here are the steps:

-----------------------------
To drop and recreate follow this note:

How To Drop, Create And Recreate DB Control In A 10g/11g Database (Doc ID 278100.1)

1) stop dbconsole

emctl stop dbcosnole

2) the drop

Step 1: Drop AQ related objects in the SYSMAN schema

Logon to SQLPLUS as the user SYS

SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'SYSMAN.MGMT_NOTIFY_QTABLE',force=>TRUE);


Note: For 11.2 datrabase, logon to SQLPLUS as the user SYS (not SYSMAN) and run:

exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'SYSMAN.MGMT_NOTIFY_QTABLE',force =>TRUE);

Step 2: Drop the DB Control Repository Objects

Logon to SQLPLUS as the user SYS or SYSTEM, and drop the sysman account and management objects:

SQL> EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
SQL> EXEC sysman.setEMUserContext('',5);
SQL> REVOKE dba FROM sysman;
SQL> DECLARE
CURSOR c1 IS
SELECT owner, synonym_name name
FROM dba_synonyms
WHERE table_owner = 'SYSMAN';
BEGIN
FOR r1 IN c1 LOOP
IF r1.owner = 'PUBLIC' THEN
EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
ELSE
EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
END IF;
END LOOP;
END;
/
SQL> DROP USER mgmt_view CASCADE;
SQL> DROP ROLE mgmt_user;
SQL> DROP USER sysman CASCADE;


3) Manually remove the files:

Section A, Option 2. Delete DB Control Configuration Files Manually (and for windows update the registry)

4) the create

Section B, Option 2. Create the DB Control Repository Objects and Configuration Files


Please note carefully that the drop and create put the database in Quiesce Mode. This note provides information about what that means.

From 11.2.0.1.0 release, the database is NOT put into quiesce mode anymore for repository drop and recreate operation. This means that emca drop and recreate commands can be executed for 11.2.0.1 database without impacting other sessions in the database.

PRC: Create Accounting There are no eligible transactions to account

Issue : PRC: Create Accounting

Error in output file:
"There are no eligible transactions to account.  Please update the parameters or submit the request at a later time when there are transactions requiring accounting."
Log file:
"Technical warning : There are no events to process."
Accounting Program did not find any events.

Solution: There Are No Eligible Transactions To Account, Please Update The Parameters And Resubmit

Ref:[ID 1382155.1]

Unable to Login to WebLogic Console. Getting "Error 404

Unable to Login to WebLogic Console. Getting "Error 404

Error 404--Not Found
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.4.5 404 Not Found

The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.
If the server does not wish to make this information available to the client, the status code 403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server knows, through some internally configurable mechanism, that an old resource is permanently unavailable and has no forwarding address

Cause
The incorrect URL is being used.
Solution
To access WebLogic console, use the following url:
http://hostname:9999/console%22.%A0%A0Login

Ref :622756.1

How to cancel an invoice interfaced to AR

How to cancel an invoice interfaced to AR ?
There are 2 ways of doing it :

1. In Invoice Review form, cancel the invoice which will create a credit memo automatically which has to be interfaced back
to AR. This will reverse the original invoice accounting in AR and there will be zero amount balance in AR.

2.The other method is to enter a new event with a negative amount, generate draft invoice that includes that event, release
and interface to AR.

Credit Memos from Oracle Projects issue in Autoinvoicing

Credit Memos from Oracle Projects

A common AutoInvoice error that can occur when credit memos are sourced from Oracle Projects:

"You cannot supply any account assignment for your credit memo transaction when the system option 'Use Invoice Accounting for Credit Memos' is Yes"

Fix: Set the profile option AR: Use Invoice Accounting For Credit Memos to No.