Enterprise Asset Management - EBS (MOSC)

MOSC Banner

Unable to bill Description Direct Items in Work Order Billing

edited May 1, 2016 5:00AM in Enterprise Asset Management - EBS (MOSC) 5 commentsAnswered

Hello,  we often purchase description direct items for work orders and we need to bill the cost of these items.   We just started using EAM Work Order Billing and up until now, we hadn't had a Description Direct to test.

What I noticed is this:

1.  The 4th union clause of the eam_bill_by_requirements_v view is there Description Direct items are queried (edirv.direct_item_type_id = 1)

2.  The query has a join that fails every time:   AND msi.inventory_item_id         = wep.bill_inventory_item_id

wep is the wip_eam_parameters table. 

Here's the entire query from the 4th union clause of eam_bill_by_requirements_v:

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