Problems Caused When Service Item Flexfield is not Defined Correctly (Doc ID 121510.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Contracts - Version 11.5.1 and later
Oracle Service Contracts - Version 11.5.1 and later
Oracle Order Management - Version 11.5.1 and later
Oracle Inventory Management - Version 11.5.1 and later
Information in this document applies to any platform.
*** Checked for relevance on 9-Apr-2014 ***

Symptoms

If the ORACLE_SERVICE_ITEM_FLEXFIELD is not defined correctly, will encounter one of these errors:

I. APP-FND-00684 When Adding a Service Line to a Contract (OKSAUDET):


1. Use the Service Contracts Manager.
2. Navigate to the Launchpad and select Tools->New.
3. Create a Service Agreement Contract. The Contract Category is Service Agreement.
4. Enter the contract header information.
5. Open the Lines tab.
6. Open the Parties tab and place the cursor on the Name column.
7. This error message will appear:

APP-FND-00684: Flexfield routine FDFRKS cannot find flexfield definition for application 401, and code SERV.
--------------------------------------------------------------
APP-FND-00864: FDFBKF: Cannot find flexfield data

APP-FND-00730: This flexfield has an invalid value set. It may use a special value set that uses an Edit event user exit, and the user exit has failed. If you are using a form on a graphical user interface (GUI) you may have an invalid value set of a different type, possibly a table-validated value set where the table or view does not exist or where there is an invalid WHERE clause.

Contact your system administrator or support representative to check and correct the value sets this flexfield uses.

II. Price List Has No Entries (OEXOEORD).

1. Use the Order Management responsibility
2. Navigate to Pricing->Price Lists->Price Lists Setup
3. Select a price list. No items are listed for the selected price list.

This error will occur if you create the ORACLE_SERVICE_ITEM_FLEXFIELD but failed to recompile the System Item Flexfield. Skip to step 3 if this problem occurs.

III. Item Name Missing on Existing Order Line Items (OEXOEORD).

1. Use the Order Management responsibility
2. Navigate to Orders,Returns->Order Organizer
3. Query an existing order.
4. Press the Line Items tab.
All of the information is displayed except the 'Ordered Item' column. Try to re-inserting the information, receive a duplicate record message.

This error will occur if the ORACLE_SERVICE_ITEM_FLEXFIELD was created but failed to recompile the System Item Flexfield. Skip to step 3 if this problem occurs.

IV. Item Name Missing on Contract Sublines (OKSAUDET).

1. Use the Service Contracts Manager responsibility.
2. Open an existing contract.
3. Choose the Lines tab, Pricing/Products sub tab.
All of the information is displayed on the Effectivity sub tab except the 'Name' column.

This error will occur if the ORACLE_SERVICE_ITEM_FLEXFIELD was created but failed to recompile the System Item Flexfield. Skip to step 3 if this problem occurs.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms