Invoice Interface Status code shows as "Not Eligible", though the Invoice Enabled item and Invoicable item properties are enabled. [Oracle APPS R12]

 Along with the item attributes (INVOICEABLE_ITEM_FLAG, INVOICE_ENABLED_FLAG), below conditions are also checked to determine whether an order line is eligible for Invoice Interface.

If any of the following conditions is true, the line is considered not eligible for Invoice Interface

1. Invoice Enabled item property is set to NO or Invoicable Item property is set to NO.
2. Line is part of an internal order.(source_document_type_id = 10)
3. Line is a service line and the servicable_product_flag for parent is set to NO.
4. Line is an Included Item.
5. Referenced returns with CONFIG/INCLUDED item type code.
6. If profile OM: Generate credit for rejected returns is No , with shipped qty and fulfilled qty 0 then its not eligible.

The possible values for the column OE_ORDER_LINES_ALL.INVOICE_INTERFACE_STATUS_CODE are

1. YES
2. NOT_ELIGIBLE
3. NULL

When the sales order line is created with workflow such as "Shipping Only", the workflow does not include invoice interface activity. Hence the line will never come to invoice interface activity and is not invoice eligible. In this case, the INVOICE_INTERFACE_STATUS_CODE will never be set and it will be NULL value only.

INVOICE_INTERFACE_STATUS_CODE is set to NOT_ELIGIBLE if any of the following conditions are met

1. The invoiceable item flag or invoice enabled flag for the item is set to 'No'. Order Management will first check for these item attributes in Ship From organization. If Ship From organization is null, then it checks in Item Validation organization and if still null then it checks in Item Master organization.
2. Internal order lines are not invoiceable. Internal orders are the orders between two organizations in a company
3. Included items are not  invoiceable. All mandatory items under a BOM are considered as included items. We can also check whether an item is included item or not from the item type field on order lines.
4. Service items with non-serviceable parent are not invoiceable. This means that the serviceable product flag for the parent item is set to 'N'.  If not set, it defaults to 'Y'.
5. Configuration items are not invoiceable

If the order line does not satisfy any of the 5 conditions mentioned above, then the line is invoice eligible and INVOICE_INTERFACE_STATUS_CODE is set to YES once the line is interfaced to Receivables.