Add Shipping Reference Segments to Line Transactions

You must add two new descriptive flexfield segments to the Line Transactions interface table for AutoInvoice.

The flexfield segments store the reference to the asset transfer transaction and the transaction line. Therefore, the segments identify each asset transfer transaction imported through the AutoInvoice process.

Follow these steps:

1. From the Setup and Maintenance work area, navigate to the Manage Descriptive Flexfields task.
2. In the Manage Descriptive Flexfields page, search for the Line Transactions flexfield name.
3. Select the record and click Edit.
4. In the Context Sensitive Segments region, select the context as Fixed Assets.
5. Click Create.
6. In the Create Segment page, enter the name as Shipping Reference.
7. Leave the Code and API Name fields as defaulted.
8. In the Column Assignment region, select the data type as Character.
9. Select the table column as INTERFACE_LINE_ATTRIBUTE1.
10. In the Validation region, select the value set as FND_FLEX_UPGRADE_FORMAT_ONLY_VARCHAR2_L30.
11. In the Display Properties region, leave the Prompt field with the default value.
12. In the Display Type field, select Text Box.
13. Click Enabled.
14. Click Save and Close.
15. In the Context Sensitive Segments region, select the context as Fixed Assets.
16. Click Create.
17. In the Create Segment page, enter the name as Shipping Line Reference.
18. Leave the Code and API Name fields with the default values.
19. In the Column Assignment region, for the Data Type field, select Character.
20. In the Table Column field, select INTERFACE_LINE_ATTRIBUTE2.
21. In the Validation region, for the Value Set field, select
22. FND_FLEX_UPGRADE_FORMAT_ONLY_VARCHAR2_L30.
23. In the Display Properties region, leave the Prompt field with the default value.
24. In the Display Type field, select Text Box.
25. Click Enabled.
26. Click Save and Close.
27. In the Manage Descriptive Flexfields page, click Deploy Flexfield and verify that the deployment completes successfully.