Lease and Finance Management - EBS (MOSC)

MOSC Banner

Which status of service contract records are eligilble for billing

edited Oct 7, 2012 10:08PM in Lease and Finance Management - EBS (MOSC) 2 commentsAnswered
Hi Experts,

I have one question related to service contract billing.

Which status(based on contract header status)
of service contracts are eligible for billing.

I believe it is ACTIVE.

We have custom program for billing.In that main cursor query extracting records with below condition.

hdr.sts_code not in ('ENTERED','CANCELLED')

After that,there are other cursors and  billing API etc. to process  records for billing


I want to replace this condition with

hdr.sts_code='ACTIVE'  to improve the performance by reducing the records count.

Is there any other eligilible  status, do we need to consider for billing.Please correct me if I am wrong.

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