In IFS Cloud, PL/SQL event actions ("Execute Online PLSQL Block") have a character limit. While the system allows up to 4000 characters (and this limit can be bypassed via direct edit), the effective limit for exporting Application Configuration Packages (ACPs) containing these actions is approximately 3980 characters. Exceeding this limit during ACP export results in the following error:
JSON
{
"error": {
"code": "DATABASE_ERROR",
"message": "Database error occurred. Contact administrator.",
"details": [
{
"code": 19202,
"message": "ORA-19202: Error occurred in XML processing"
}
]
}
}
This issue is specific to ACP exports. If the event action logic is not delivered via ACPs, this character limit does not apply, as the underlying database column is a CLOB, which can handle significantly larger text blocks. Therefore, the problem only arises when exporting ACPs containing PL/SQL event actions that approach or exceed the ~3980-character limit.
