Monday, April 27, 2009
Do not run adpatch with only one worker
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
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
===================
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
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