Monday, April 27, 2009

Do not run adpatch with only one worker

When running adpatch, when asked for number of workers, do not enter 1. Sometimes an error needed for adpatch is included on the same patch. So if error occured, the job will be deferred if there are more than one worker. After that another worker will continue to work and the error fixed. When adpatch retry the failed job, it will be fixed.
If only one worker assigned, when error occurred, adpatch will stop, no job is deferred, so the error must be fixed outside adpatch.

Living in the desert

I have never thought of living in the desert. It's a little bit scary. But after viewing Desert Ridge Realtor website, it's interesting to see houses on desert.
The website gives you facilities to search and select houses located in the desert. Even 2D and 3D maps also provided.
If you like to have a house in the desert, you should visit this website.

Wednesday, April 15, 2009

Unable to cancel invoice due to tax distribution variance

CAUSE DETERMINATION
===================
The cause of the issue is invalid / incorrect data in ap_invoice_lines_all
and ap_invoice_distributions_all .

CAUSE JUSTIFICATION
===================
The following bug was logged for this specific customer to receive a datafix
from Oracle Development:
Bug.8357578: UNABLE TO CANCEL INVOICE DUE TO TAX DISTRIBUTION VARIANCE
Oracle Development stated that the issue is due to invalid / incorrect data.

The AP List identified the issue data.

PROPOSED SOLUTION(S)
====================
Apply a datafix to correct invalid / incorrect data in ap_invoice_lines_all
and
ap_invoice_distributions_all.

PROPOSED SOLUTION JUSTIFICATION(S)
==================================
The following bug was logged for this specific customer to receive a datafix
from Oracle
Development:
Bug.8357578: UNABLE TO CANCEL INVOICE DUE TO TAX DISTRIBUTION VARIANCE
Oracle Development stated that the issue is due to invalid / incorrect data.
Oracle Development provided a datafix.
The datafix will do the following:
1. correct the data in ap_invoice_lines_all and
ap_invoice_distributions_all.

SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps::
Execute the below SQL and commit the changes:

create table aid_bkp as
select *
from ap_invoice_distributions_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';

create table ail_bkp as
select *
from ap_invoice_lines_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';

delete
from ap_invoice_distributions_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';

delete
from ap_invoice_lines_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';

commit;

Wednesday, April 8, 2009

Agent status unavailable on enterprise manager

Enterprise Manager, Database Control 10g shows the status 'Agent
unavailable' even though the agent and database are up an
running.
To fix that error:
Recreate the DB Control Configuration Files only (leave Repository intact)
In 10.2, the EMCA commands can be used to reconfigure the existing installs
without removing them first. Run the command:
<ORACLE_HOME>/bin/emca -config dbcontrol db