Skip to main content

Debug OAF Page

How to Debug OAF Page

We can enable logging by setting the below profile option:-
Option: 1)
FND: Debug Log Enabled profile set to ‘Yes’
• Turn on low level statement logging for a single user to monitor
• FND: Debug Log Level= Statement



Option: 1)
Another way of gathering the same info is the following:

1)  Enable profile option FND: Diagnostics 
2)  Add following at the end of existing page URL,   &aflog_level=Statement&aflog_module=*

• Use '*' for wildcard, not '%'. '%' is a special URL character)

Example:
• http://host:port/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE&aflog_level=STATEMENT&aflog_module=pa

You can see the log on screen by using by below code in your controller OR in Application ModuleImpl

For AM

getOADBTransaction().writeDiagnostics(this, "I am in the Application Module", 1);

For Controller

 pageContext.writeDiagnostics(this, "I am in Controller PFR", 1);

Comments

  1. Hi…
    Thank you for posting this useful information.
    I think it is mostly helpful to who are ready to learn Oracle OAF.

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle APPS Create Responsibility and User in Oracle EBS

How to create Responsibility and User in Oracle EBS How to Create a Responsibility? Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User. Step 2: Go to Application Administrator. Step 3: Go to Security then Responsibility then Define Step 4: Enter the Data in the opened Window. Note: Above Information of Responsibility is stored in FND_RESPONSIBILITY Table. How to Create a User? Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User. Step 2: Go to Application Administrator. Step 3: Go to Security then User then Define Step 4: Enter the Data in the opened Window. Note: Above Information of User is stored in FND_USER Table. User Responsibilities stored in FND_USER_RESP_GROUPS Table.

Use of Who Columns in Oracle APPS table

Oracle APPS : WHO COLUMNS WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed. Steps required to Track WHO Information in our form   1. ALTER the table by adding WHO columns in the table.   2. Open TEMPLATE.fmb in form Builder.   3. Perform all the pre‐requisites to develop a form.   4. Include all the WHO columns in the Data Block with NULL Canvas.   5. Call FND_STAND.SET_WHO procedure in Pre‐Insert and Pre‐Update triggers       at Block Level.   6. Save and Compile the Form.   7. Perform all the pre‐requisites to register the form Note: 1. WHO Columns need not register with the table registration option.           2. Table registration will be done only for KFF and DFF col...

गारपीट

                                                ।। गारपीट ।।                              आल्या पावसाच्या धारा, सरा  मांडला पसारा, उभं पिक रानामधी, गेल्या  नासवून गारा.  झाला   फुलाले अघात, समधि गळाली रे पानं पाणी पाणी चोहीकडे  तरी जळाली रे मनं                                                          काही माणूस भी गेले                                                           काही तुटले छप्पर                  ...