Knowledge Management for Attachments conversion in 11.5.10

1 Responsibility / Navigation / Module
Application Developer

2 Conversion Approach / Reference Documents
Direct insert/ Oracle Application developers guide

3 Application Setup Requirements
N/A

4 Assumptions / Prerequisites / Validations
ITEMS,
BOMS,
OE_ORDER_HEADERS,
OE_ORDER_LINES,
PO_HEADERS,
PO_LINES,
AR_CUSTOMERS and AP_INVOICES.
Operating unit mappings must exist.

List of validations:

FND_ATTACHED_DOCUMENTS
1. Organization_code
2. Item number
3. Assembly item number
4. Bill sequence id
5. Org name
6. Order number (Sales)
7. Order line number (Sales)
8. Purchase order number
9. Purchase order line number
10.Custoemr name
11.Customer number
12.Customer type
13.Invoice number

FND_DOCUMENTS
14.Document data type
15.Document category

FND_DOCUMENTS_TL
16.Language
17.Source language

5 Base Tables Effected
FND_DOCUMENTS_SHORT_TEXT
FND_DOCUMENTS_LONG_TEXT
FND_DOCUMENTS_LONG_RAW
FND_LOBS
FND_DOCUMENTS
FND_DOCUMENTS_TL
FND_ATTACHED_DOCUMENTS

6 Interface Tables / APIs
N/A

7 Navigation of Import Program & Parameters
Direct Insert by executing the main procedure of the package