Entity Property Sync (SCC_ESYNC_AE) Error 'SCC_ENTITY_20200403215254:Invalid parameter 1 for function CreateRecord. (2,116)' (Doc ID 2795989.1)

Last updated on MARCH 05, 2024

Applies to:

Symptoms

When attempting to run Entity Property Sync (SCC_ESYNC_AE), the following error occurs, as shown in the message log and log (.stdout) file:

Because of the last line in the code above, indicating that the process itself ended normally, the status will show 'success' in the process monitor, so the error may not be immediately obvious.

In at least one case, the process was being run after seeing a different error with the Student Financial Planning (SFP) Application Engine program SCC_SFP_PUL2, as documented in <Note 2744291.1>, which indicated that this issue may be fixable by running the Entity Property Sync. However, the issue with Entity Property Sync could be encountered by both SFP and non-SFP schools. 

The issue can be reproduced with the following steps:

1. Navigate to Main Menu > Set Up SACR > System Administration > Entity > Entity Property Sync.
2. Click “Sync All Entity Properties” and wait for the process to finish. 
3. Click on "Wipe Entity Cash" and wait for this process to complete. 
4. Check Process Monitor via Main Menu > PeopleTools > Process Scheduler > Process Monitor and look for the row for SCC_ESYNC_AE that just completed. Note that the run status shows "success".  
5. Click 'Details' then 'View Log/Trace'. 
6. Click the .stdout file in the file list and note the error message shown in the file. 

Cause

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