Sairam Nimmagadda

When a concurrent request for an Xml Publisher concurrent Request ends up with a Warning. If you have system administrator access you can access the Output Post Processor Log using the Concurrent -- Manager Menu. If you don't have access to System Administrator Responsibility, using the following query you can get the location of the log that's stored on the application server. From the Log: +------------- 1) PUBLISH -------------+  Beginning post-processing of request 19280863 on node SERVER at 15-MAY-2014 13:39:18. Post-processing of request 192808 failed at 15-MAY-2014 13:39:18 with the error message: One or more post-processing actions failed. Consult the OPP service log for details.  The actual error returned by the XML Publisher Core engine is captured in the OPP log file. One of the easiest way to obtain the OPP log file is to run the below script from the database by providing request_id. SELECT fcpp.concurrent_request_id req_id, fcp.node_na...

To purge the workflow from the Oracle Database, we need to use the standard workflow purge sql file provided by Oracle. The file is located under the FND_TOP/sql folder. The file name is wfrmitt.sql Connect to the server. Connect to the sqlplus session as apps/*****. Execute the above mentioned file sql> @wfrmitt.sql sql> @FND_TOP/sql/wfrmitt.sql Will list all the item types. Will ask for the item type that needs to be purged. XXXXXX (item type) The workflow will be purged and all the activity information, error information will be purged. The child workflow (WF_ERRORS) for the workflow wont be purged. That would be a pre requisite for this activity.

Oracle Workflow Builder Installation on Windows 7 Install the workflow builder with a separate home other than the default Oracle Home. Once the installation completes successfully, before logging into the workflow builder, Add the TNSNAMES.ora  and the SQLNET.ora to the network --> ADMIN folder. One more thing that needs to be done is, adding couple of variables to the Environment variables on your notebook. My Computer --> Properties --> Advanced System Settings In the Advanced tab  Click on Environment Variables Add variable TNS_ADMIN   Value is the path of your new oracle home  sample: c:\ ORA_WORKFLOW_HOME\network\ADMIN Next Variable LDAP_ADMIN Value Sample: c:\ ORA_WORKFLOW_HOME\network\ADMIN Hope this helps people who are in need. 

I have been having a lot of issues with BI Publisher lately. One of them is Module_editFF i had BI Publisher installed for a while and out of the blue i got this error and the BI Publisher wont work any more. I had to uninstall the existing BI Publisher, and re-install the BI Publisher again. After successful re-installation of the BI Publisher, open MS Word. Click on the MS Word logo, click Word Options. Click Add-ins menu. In the Manage option, look for templates and hit go. Looks for TemplateBuilder.dot and check that and hit ok. By doing this the BI Publisher worked for me. Hope this helps others who face this issue.

How to Create a Concurrent Program as a Function and assign it to a menu? Create a new executable. ( Sysadmin --> Concurrent --> Program --> Executable ) Create a new Concurrent Program with the executable as the short name ( Sysadmin --> Concurrent --> Program Define ) Assign the parameters based on the requirement. Assign the concurrent program to any request group if needed. Create a new function Sysadmin --> Application --> Function Description Tab: Provide the  Function  name (name it as close as short name of the concurrent program for ease) Provide a Function Name and description Properties Tab: Provide the type as 'Form', Maintenance mode support as 'None' and Context Dependence as 'Responsibility' Form Tab: Under Form provide the value Run Reports, Application as Application Object Library and Parameters should be the Concurrent_program_name and Program_Application_short_name and title Sample: Concurren...

Compilation of forms on local machine First thing, copy all the files from $AU_TOP/resource to a place on the local machine. c:\FORMS\US (new folder on local machine) we need to add this new location in the forms_path registry variable. run --> regedit Hkey Local Machine --> Software --> Oracle Home looks for FORMA_PATH Dont delete the variables that are present, just add the new location and it should work. use " ; " to add the new path.. so c:\devsuite\forms ;c:\FORMS\US  Refer to Metalink Note: 236803.1

Recently , I had to use SQL*Loader for Oracle R12. Faced some issues, but finally got it sorted out. First things first. What do we need? 1) Data file: Can be .csv, txt etc. Here in my case it was .csv file. I had to place the file on the application server. The location is one that has been set up for saving data files. 2) we need a Control file for the SQL*Loader utility to load the data into the database. Structure of the Control file. --/****************************************************************************** --    NAME:        myfile.ctl --    PURPOSE:     Description -- --    REVISIONS: --    Ver         Date          Author            Description --    ---------   ----------    ---------------   --------------...