E-AE/CI: Error() Statement Executed in CI Component Logic Abends Batch AE program, But Not PIA Online Program (Doc ID 1911220.1)

Last updated on AUGUST 17, 2021

Applies to:

Symptoms

PT 8.52.19 /HCM 9.1 Bundle#13

A customized Application Engine(AE) program using a customized Component Interface(CI) based on delivered component TRN_STUDNT_CRS_DT2 to load courses.  Course that do not have licenses are loading correctly. Courses that have a license attached where the user has and expired license, the process errors.

Detailed analysis showed the following use case in triggering the issue:

1. An AE program that using a custome CI to update data, when an error() statement is executed in CI context, a SQL rollback happened and abended the AE program

2. The same transaction using the same component running online on PIA, same error() statement executed in CI context, does not trigger a SQL rollback to abort the transaction

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.