Application Engine Integrity
The following table describes the audit queries and resolutions for this area:
| Query | Description | Resolution |
|---|---|---|
|
AE-01 |
This audit lists the AE programs without any sections. |
If the affected program is delivered by PeopleSoft and is not modified, contact My Oracle Support. If the affected program is converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. Otherwise, use the Application Engine designer to either create valid sections for the program or remove the program. It is not possible to recover the missing sections. |
|
AE-02 |
This audit lists the AE sections without AE programs. |
If the affected program is delivered by PeopleSoft and is not modified, contact My Oracle Support. If the affected program is converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. If the affected program is a customization, it is not possible to recover the missing program. Restore it from a backup if needed. Run SysAECleanUp.dms to remove any orphans remaining after you have followed the steps above. |
|
AE-03 |
This audit lists the AE state records without AE programs. |
If the affected record is delivered by PeopleSoft, contact My Oracle Support. If the affected program is converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. Otherwise, ignore the warnings or restore the program from a backup. It is not possible to recover the missing program. |
|
AE-04 |
This audit lists the AE state records without record definitions. |
If the affected record is delivered by PeopleSoft, contact My Oracle Support. If the affected program is converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. Otherwise, use Application Designer to remove invalid records from the program definition or create record definitions. |
|
AE-05 |
This audit lists the AE section details without base section definitions. |
If the affected program is delivered by PeopleSoft and is not modified, contact My Oracle Support. If the affected program is converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. Otherwise, ignore the warnings or restore the program from a backup. It is not possible to recover the missing sections. |
|
AE-06 |
This audit lists the AE base section details without section definitions. |
If the affected program is delivered by PeopleSoft and is not modified, contact My Oracle Support. If the affected program is converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. Otherwise, ignore the warnings or restore the program from a backup. It is not possible to recover the missing sections. |
|
AE-07 |
This audit lists the AE steps without sections. |
If the affected program is delivered by PeopleSoft and is not modified, contact My Oracle Support. If the affected program is converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. If the affected program is a customization, it is not possible to recover the missing program; restore it from a backup if needed. Run SysAECleanUp.dms to clean up these orphans. |
|
AE-08 |
This audit lists the AE Call Section actions referring to nonexistent sections |
If the affected record is delivered by PeopleSoft, contact My Oracle Support. If the affected program is converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. Otherwise, use the Application Engine either to open the program containing the Call Section and change it to call the correct section, or create the required section. |
|
AE-09 |
This audit lists the AE Log Message actions without an AE step. |
If the affected record was delivered by PeopleSoft, contact My Oracle Support. If the affected program was converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. If the affected program is a customization, it is not possible to recover the missing program; restore it from a backup if needed. Run SysAECleanUp.dms to remove any orphans remaining after you follow the steps above. |
|
AE-10 |
This audit lists the AE actions without an AE step. |
If the affected program was delivered by PeopleSoft, contact My Oracle Support. If the affected program is converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. If the affected program is a customization, it is not possible to recover the missing program; restore it from a backup if needed Run SysAECleanUp.dms to clean up these orphans. |
|
AE-11 |
This audit lists the AE temp tables that are attached to invalid AE programs. |
If the affected temp table was delivered by PeopleSoft, contact My Oracle Support. If the affected program is converted as part of an upgrade, this may be a symptom that the conversion failed. Contact My Oracle Support. Otherwise, ignore the warnings or restore the program from a backup. It is not possible to recover the missing programs. |
|
AE-12 |
This audit lists the orphaned AE PeopleCode. |
Because of platform issues and Structured Query Report (SQR), this check may not be included in the audit report. Run SysAECleanUp.dms to clean up these orphans. |
|
AE-13 |
This audit lists the orphaned AE SQL objects. |
Because of platform issues and Structured Query Report (SQR), this check may not be included in the audit report. Run SysAECleanUp.dms to clean up these orphans. |
|
AE-14 |
This audit verifies that PS_AEONLINEINST contains the correct number of rows. |
Run ps_aeonlineinst.dms. If you do not have the Data Mover script, contact My Oracle Support. |
|
AE-15 |
This audit verifies that PS_AEINSTANCENBR contains the correct number of rows. |
Run ps_aeinstancenbr.dms. If you do not have the Data Mover script, contact My Oracle Support. |
|
AE-16 |
This audit verifies that PS_AELOCKMGR contains a row. |
Resolution may vary based on implementation. Contact My Oracle Support. |
Note:
Locate the Data Mover scripts in the PS_HOME\scripts directory unless otherwise noted.