Billing and Revenue Management (MOSC)

MOSC Banner

Orders Taking too much time for completion

edited Aug 26, 2015 10:02AM in Billing and Revenue Management (MOSC) 6 commentsAnswered

Hi,

On monday due to DB Locks multiple orders failed in production.

This order includes inactivating products and activating new products.

Whenever we are retying these orders from SOA, BRM is taking more time for responding.

Similar type of orders which placed after this issue are flowing without any problem.

Whenever we are retrying these orders it is creating locks in DB. And following is the query it is creating lock in:

update service_t set poid_rev = poid_rev + 1, mod_t = :mod_t, effective_t=:effective_t where poid_id0 = :poid_id0

Following is the pstack for this:

D Tue Aug 18 12:31:20 2015  pc2an1d2  cm:9543  cm_child.c(109):1012 1:plb6bn01:UnknownPro1301:1439890279:44

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center