Have you ever wondered what is going on with a customization that doesn't work properly? Do you want to understand why your Oracle Support engineer is asking you to provide them with a trace? Do you want to learn more about what such a trace reveals about how your application works? When something goes wrong in an application, you have an option of guessing at what is happening underneath the hood, or you can use utilities to gather evidence that clearly explains what the code is doing and why it is doing it. There are several video series available on My Oracle Support that help you to understand what a cobol compile error list is telling you, what a PeopleCode SQL Trace is showing or how to interpret a Cobol SQL trace. If you are new to PeopleSoft and need to learn how to troubleshoot your applications, or if you just want to improve your own skills, please consider any of these multimedia articles to learn how to use these utilities.


Cobol Compiling


Understanding the Cobol compile process and troubleshooting problems compiling Cobol [Video] (Doc ID 1640121.1)


Cobol Tracing and Troubleshooting

 

How to Acquire a COBOL SQL Trace [Video] (Doc ID 1092955.1)

Elements and the Interpretation of a COBOL SQL Trace [Video] (Doc ID 1102782.1)

Diagnosing Functional Problems with a Cobol SQL Trace [Video] (Doc ID 1119500.1)

How to diagnose performance problems using a COBOL SQL trace [Video] (Doc ID 1109345.1)

How to Diagnose Error 153 (Subscript Out of Range or Array Size Exceeded) in a COBOL job [Video] (Doc ID 1153577.1)


Page Relate Problem Troubleshooting and Tracing

 

PeopleCode and Online SQL Tracing and Troubleshooting: Acquiring and Interpreting a PeopleCode Trace [Video] (Doc ID 1581649.1)

PeopleCode and Online SQL Tracing and Troubleshooting: Acquiring and Interpreting an Online SQL Trace [Video] (Doc ID 1581652.1)

PeopleCode and Online SQL Tracing and Troubleshooting: Interpreting a combined PeopleCode and Online SQL Trace [Video] (Doc ID 1581653.1)

PeopleCode and Online SQL Tracing and Troubleshooting: The Value of "Show Each Statement" and Diagnosing Problems on a Page [Video] (Doc ID 1581654.1)