Sunday, January 19, 2014

How to Purge Quotes

Purge Quote Process:

Purging old data creates space in your database and can improve performance of

transactions and maintenance

Step 1.  Order management responsibility > Order,return>purge> Quote purge selection.





 







Step 2: Order Management responsibility > Order, return > Purge > Purge Set:

A purge set is a set which will contain Quote to be purged based upon user

specified criteria. Query the purge set name defined in Step 1.

Step 3 : Click Submit purge, Request Id is dispalyed make a note of the request ID and query in concurrnet  program.


Order purge Program will be submitted.



Quote count(Offer Expired and Lost):

SELECT
count(1), SUBSTR(tO_CHAR(TRUNC(OOH.LAST_UPDATE_DATE),'DD-MM-YYYY'), 7,10) year
FROM oe_order_headers_all ooh,  oe_transaction_types_tl ott, oe_order_sources os1, oe_order_sources os2
WHERE
ooh.order_type_id = ott.transaction_type_id
AND ooh.order_source_id = os1.order_source_id(+)
AND ooh.source_document_type_id = os2.order_source_id(+)
AND ott.LANGUAGE =( SELECT fl.language_code
FROM fnd_languages fl
WHERE fl.installed_flag = 'B')
and ooh.transaction_phase_code in ('N')
AND ooh.flow_status_code IN ('OFFER_EXPIRED','LOST')
GROUP BY SUBSTR(tO_CHAR(TRUNC(OOH.LAST_UPDATE_DATE),'DD-MM-YYYY'), 7,10)
order by year;


No comments:

Post a Comment