Monday 4 September 2017

R12 Statement Generation Program (ARXSGP) Debugging

The Statements program use the following 2 temp tables to generate the statement:

The AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are temp tables populated by the Statement Generation program. You can  check the data in tables only when debug_flag =Y


System Administrator
Concurrent > Program > Define
Query shortname = ARXSGP 

Click Parameters
Scroll to parameter debug_flag ,default  value set as 'N'

Change this to : 'Y'

Save
 

Set the profile Option AR: Enable Debug Message Output

System Administrator
Profile > System
Query for Application = Receivables
Responsibility = Receivables Manager (you need to put in the actual Responsibility name here)
user = <your user name>
Profile Option = AR: Enable Debug Message Output
Ensure it is set to Yes.


Enable debug_flag in Statements Form



Receivables Manager
Print Documents > Statements
Invoke the Menu: Help > Diagnostic > Examine 
Enter the following values:
Block = SUPST_BLK
Field = DEBUG_FLAG
Value = Y
Click OK


Now  from the two tables we can view the data .














No comments:

Post a Comment