My Oracle Support Banner

Statements: How to Enable Debugging for Statement Generation Program ARXSGP (Doc ID 436733.1)

Last updated on DECEMBER 14, 2023

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.
ARXSGP Statement Generation Program
ARXSGPO Print Statements
ARXSUPST Statements Form

This document is applicable to Release 11i as well as R12, R12.1 and R12.2

Goal

The purpose of this article is provide steps to enable debugging for the Statements Generation program.

This document assumes you have minor technical knowledge of Oracle Receivables and have SQL access to tables as well as usage of the Help > Examine feature within Oracle Applications.

Enabling debug may impact performance and should be done with care. You are advised to disable it as soon as you get the required debug log/file.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1. Clear out temporary tables used by Statements Process
 2. Edit the Concurrent program ARXSGP
 3. Set the profile Option AR: Enable Debug Message Output
 4. Enable debug_flag in Statements Form
 5. Verify Debug was set correctly
 6. Using the debug information

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