Oracle - Troubleshooting Workflow

1. Create SQL query to get ITEM_KEY
Use wf_messages_vl and wf_notifications tables.
2. Use Workflow Administrator Web Applications responsibility
3. Select Administrator Workflow > Status Monitor
4. Add Type Internal Name and Item Key and Go.

4.1. Click on Activity History 

Go to Notification column > Click Open > Shows error message

4.2. Click on Status Diagram

Check the process you are interested in.

5. Open the workflow in Workflow Builder > Processes (double click) > Click on the button > Check Function Name -> package and function name

 6. Check the code behind
resultout := Wf_Engine.eng_completed||':F';
Determines which case of the workflow will happen. This is an error one.

Oracle - fnd_profile_option_values

level_id	level	level_value
1001	Site
1002	Application	application_id
1003	Responsibility	responsibility_id
1004	User	user_id
1005	Server
1006	Organization
1007	Server + Responsibility

Oracle - Version and location of files

.class /opt/apps/r12/<host_name>/apps/apps_st/comn/java/classes/oracle/apps/<application_code>/
.fmb, .fmx $<TOP>/forms/US
.pls $<TOP>/patch/115/sql/
.odf $<TOP>/patch/115/odf/
.pld $<AU_TOP>/resource

<TOP>:
$AP_TOP: /opt/apps/r12/<host_name>/apps/apps_st/appl/ap/12.0.0/
$AU_TOP: /opt/apps/r12/<host_name>/apps/apps_st/appl/au/12.0.0/
$FUN_TOP: /opt/apps/r12/<host_name>/apps/apps_st/appl/fun/12.0.0/
$PSA_TOP: /opt/apps/r12/<host_name>/apps/apps_st/appl/psa/12.0.0/
$ZX_TOP: /opt/apps/r12/<host_name>/apps/apps_st/appl/zx/12.0.0/