Skip to content

An FNDMIG data migration importing parts into a Customer Agreement intermittently throws 'ORA-20110: RmAccUsage. Developer Error: CustomerAgreement... Most likely a usage definition is wrongly defined for LU [CustomerAgreement]' against the same set of data, with no obvious logical pattern to when it happens.

Answer

This misleading low-level error is commonly a symptom of a completely different underlying problem — the parent Customer Agreement header record failing to import successfully first, due to unrelated separate errors on that header, meaning the agreement referenced by a subsequent part-level import record doesn't actually exist yet at all when that part-level import runs. Rather than treating this as a genuine usage-definition/dictionary problem, add an explicit existence check, calling the Customer Agreement API's Exists-style method against the target agreement ID, before attempting to import a part into that agreement, and skip or flag the part-level import when the parent agreement doesn't actually exist — this avoids triggering the confusing RmAccUsage-level error entirely for what is really just a missing-parent-record issue.

← Browse Data migration questions