APP-FND-00684: Flexfield routine FDFRKS cannot find flexfield 的解决办法

goal: How to Define the Oracle_SERVICE_ITEM_FLEXFIELD

fact: Oracle Service Contracts 11.5.3

fact: Oracle Order Management 11.5.3

fix:

Organizations define their Inventory System Items differently.  These steps are
required to assure that the Service Item Flexfield definition is the same as
the definition for the Inventory System Item Flexfield.

1. Define ORACLE_SERVICE_ITEM_FLEXFIELD.

a. Use the Application Developer responsibility.
b. Navigate to Flexfields / Key / Register
c. Double Click on Register To open the Key Flexfields Form.
d. Create this record:
-   Application = Oracle Inventory (In 11.5.10, select 'Inventory')
-   Code = SERV
-   Title = ORACLE_SERVICE_ITEM_FLEXFIELD
-   Description = Item Flex Field that displays segments in different sequence
-   Table Application = Oracle Inventory
-   Table Name = MTL_SYSTEM_ITEMS_B
-   Unique ID Column = INVENTORY_ITEM_ID
-   Structure Column = ORGANIZATION_ID
        -   KFV View Name = MTL_SYSTEM_ITEMS_B1_KFV (11.5.10 and later)
-   Uncheck Dynamic Inserts Feasible
-   Check Allow ID Value Sets
e. Save this entry by clicking the Save button on the toolbar.
f. Press the Columns button.  Make Sure that Segment1 through Segment20 are
Enabled.
g. Save the record and exit the form.

The next steps are performed to define ORACLE_SERVICE_ITEM_FLEXFIELD segment
values.  The Inventory System Item flexfield and ORACLE_SERVICE_ITEM_FLEXFIELD
must have the same attributes. 

2. Determine how Inventory System Items flexfield is defined.

a. Use the Sysadmin responsibility.
b. Navigate to Application / Flexfield / Key / Segments
c. Query the record:
-   Application = Oracle Inventory
-   Title = System Items
d. Press the Segments button.
e. Document how each segment is defined.  This includes how you define value
sets, etc.  This information is needed to update the
ORACLE_SERVICE_ITEM_FLEXFIELD in the next step.

3. Define ORACLE_SERVICE_ITEM_FLEXFIELD segments.

a. Use the Sysadmin responsibility.
b. Navigate to Application / Flexfield / Key / Segments
c. Query the record:
-   Application = Oracle Inventory
-   Flexfield Title = ORACLE_SERVICE_ITEM_FLEXFIELD
d. Unfreeze the flexfield.
e. Press the Segments button.
f. Enter segment definitions that match those defined for the Inventory
System Item flexfield.
g. Freeze and recompile the flexfield.

4. Recompile the Inventory System Item flexfield.

a. Use the Sysadmin responsibility.
b. Navigate to Application / Flexfield / Key / Segments
c. Query the record:
-   Application = Oracle Inventory
-   Title = System Items
d. Unfreeze the flexfield.
e. Freeze and recompile the flexfield.
        f. Repeat these steps for the Service Item Flexfield.


Note: The seeded flexfield definition is loaded by running this command:

FNDLOAD logon/password 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct $OKS_TOP/patch/115/import/US/okskfinv.ldt



推荐到鲜果：