Documentation for 12.2 release:
docs.oracle.com/cd/E26401_01/doc.122/e22953..
The Generic Loader (FNDLOAD) is a concurrent program that can move Oracle E-Business Suite data between database and text file representations.
How it operates, and what exactly the parameter CUSTOM_MODE=FORCE does
Questions are usually asked while FNDLOAD is used. So I have made some research to understand, how to use it properly. As per documentation, "Deletion of a row is not supported". Let's check it using undocumented option CUSTOM_MODE=FORCE. Can we safely update only one segment for context in Descriptive Flexfield, if context contains another segments?
Conclusions.
"Deletion of a row is not supported", correct in any case
Context`s LAST_UPDATE_DATE has not effect on segment uploading
The only purpose of the parameter CUSTOM_MODE=FORCE is not to check entity`s LAST_UPDATE_DATE, as if it is always newer than existing one.
Unexpected behavior
As per "Oracle E-Business Suite Setup Guide 12.2",
Deletion of a row is not supported
, but for oracle forms customizations in Doc ID 395117.1 "Form Personalization (Release 12)" another statement exists:
Note that upon uploading, all prior personalizations for that function are first deleted, and then the contents of the loader file are inserted.
Experiments show that in version 12.1 form personalizations are merged by FNDLOAD, but in 12.2 it works as described: all rows are deleted, then all rows from text file are inserted. But really, rows are deleted by key FORM(or FUNCTION) + RULE_KEY.
Conclusion: for safe form persionalizations transfers, always use "RULE_KEY" field filled by customization(feature) ID, to prevent deletion of another customization rows. "FND: Enable Industry Editing" profile should be set to Yes to make RULE_KEY field appear in personalization form.
Table of all standard entities and parameters, with comments on behavior
I have gathered all _TOP/patch/115/import/.lct files in one table, and have described all FND files. It turned out that we can import 1500 types of data, including GL Budget amounts & FA_CATEGORIES! File contain working example of downloading data for processed rows. Here link to full file in github.
