Billing and Revenue Management (MOSC)

MOSC Banner

How to determine auditing is required or not? And what’s the functionality?

edited Apr 9, 2010 1:10AM in Billing and Revenue Management (MOSC) 1 commentAnswered
 DBA found that the below query takes longest time, How to determine whether auditing is required or not for /purchased_product and /purchased_discount objects.
How to determine which BRM opcode/ functionality causing this query?

select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, au_parent_obj_DB, au_parent_obj_ID0, au_parent_obj_TYPE, au_parent_obj_REV, cycle_discount, cycle_disc_amt, cycle_end_details, cycle_end_t, cycle_fee_amt, cycle_fee_flags, cycle_start_details, cycle_start_t, deal_obj_DB, deal_obj_ID0, deal_obj_TYPE, deal_obj_REV, descr, effective_t, flags, instantiated_t, mmc_type, node_location, object_cache_type, overridden_obj_DB, overridden_obj_ID0, overridden_obj_TYPE, overridden_obj_REV, package_id, plan_obj_DB, plan_obj_ID0, plan_obj_TYPE, plan_obj_REV, product_obj_DB, product_obj_ID0, product_obj_TYPE, product_obj_REV, purchase_discount, purchase_disc_amt, purchase_end_details, purchase_end_t, purchase_fee_amt, purchase_start_details, purchase_start_t, quantity, service_obj_DB, service_obj_ID0, service_obj_TYPE, service_obj_REV, sponsor_obj_DB,service_obj_ID0, service_obj_TYPE, service_obj_REV, sponsor_obj_DB, sponsor_obj_ID0, sponsor_obj_TYPE, sponsor_obj_REV, status, status_flags, usage_discount, usage_end_details, usage_end_t, usage_start_details, usage_start_t from au_purchased_product_t where au_purchased_product_t.au_parent_obj_ID0 = :1 and au_purchased_product_t.effective_t <= :2 order by au_purchased_product_t.effective_t desc ;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center