Account Generator

 Documents

 3 views
of 6
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Description
Account Generator & Workflow Frequently Asked Questions (FAQ's) [ID 224308.1] Modified 13-APR-2011 Type FAQ Status PUBLISHED In this Document Purpose Questions and Answers Q1. Why is the expense report account generator item type (PAAPWEBX) named Web Employees Account Generator Q2. What are the main workflows/item types related to Oracle Projects and where are these files located? Q3. How do you determine the WF Item Key value to run wfstatus.sql for Account Generator workflows? Q4. Does the
Share
Tags
Transcript
    Account Generator & Workflow Frequently Asked Questions (FAQ's) [ID 224308.1]   Modified  13-APR-2011 Type  FAQ Status  PUBLISHED In this Document   Purpose Questions and Answers Q1. Why is the expense report account generator item type (PAAPWEBX) named Web Employees AccountGenerator  Q2. What are the main workflows/item types related to Oracle Projects and where are these files located? Q3. How do you determine the WF Item Key value to run wfstatus.sql for Account Generator workflows? Q4. Does the Project Supplier Invoice Account Generator have to be customized? Q5. How do I save my workflow definition to the database? Q6. How do I assign different account generator processes for different operating units? Q7. How do I verify the version of Oracle Workflow that I have installed? Q8. How do I display the Internal Name of an object in the Object Navigator? Q9. How do I display the Performer of a Notification in the Process Detail screen? Q10. How do I create a shortcut for Workflow Builder which connects to a particular instance? Q11. How do I customize an Account Generator Workflow process for my company? Q12. What Access Level should I be using in Oracle Workflow Builder? Q13. Where can I obtain the Oracle Workflow Builder client? References   Applies to: Oracle Project Costing - Version: 11.5.10.2 and later [Release: 11.5.10 and later ]Information in this document applies to any platform. Purpose This FAQ document identifies the most frequently reported how-to questions relating to AccountGenerator & Workflow. Questions and AnswersQ1. Why is the expense report account generator item type (PAAPWEBX) named WebEmployees Account Generator Answer:  The name was inadvertently changed to this value in the initial versions of 11i. Bug: 1580069 was loggedfor this issue and the display name was reverted to Project Expense Report Account Generator inPAAPWEBX.wft version 115.8. However, if the workflow was customized when the name was changed,it will remain as Project Web Employees Account Generator unless you specifically change it. Forexample in Vision databases, the stored name remains Project Web Employees Account Generator .  Q2. What are the main workflows/item types related to Oracle Projects and where are thesefiles located? Answer:  Display Name Item Type File Name PA : Project Execution PAPRJEX PAPRJEX.wftPA :Project Assignments PAWFAAP PARASGMT.wftPA AR Notification PAPWPAR PAPWPARN.wftPA Advertisements Workflow PARADVWF PARADVWF.wftPA Apply Team Template PARAPTEM PARAPTEM.wftPA Budget Integration Workflow PAWFBUI PAWFBUI.wftPA Budget Workflow PABUDWF PABUDGWF.wftPA Candidate Notification Process PACANDID PARCANDD.wftPA Deduction Approval PADCTNWF PADCTNWF.wftPA Forecast Item Generation Workflow PARFIGEN PARFIGEN.wftPA Issue and Change Action Workflow PAWFCIAC PAWFCIAC.wftPA Issue and Change Workflow PAWFCISC PAWFCISC.wftPA Mass Assignment Transaction Workflow PARMATRX PARMATRX.wftPA Mass Pipeline Projects Update PAYPRJNT PAYPRJNT.wftPA Overcommittment Notification Processes PAROVCNT PAROVCNT.wftPA Project Workflow PAPROWF PAPROJWF.wftPA Status Report Workflow PAWFPPRA PAWFPPRA.wftPA Task Approval Workflow PATASKWF PATASKWF.wftPA Workplan Workflow PAWFPPWP PAWFPPWP.wftPA: CRM Workaround Workflow PACRMUPD PACRMUPD.wftPA: HR Related Updates Workflow PAXWFHRU PAXWFHRU.wftPA: Mass Assignment Approval PARMAAP PARMAAPW.wftPA: Performance Notification PAEXNOWF PAEXNOWF.wftProject Budget Account Generation PABDACWF PABDACWF.wftProject Expense Report Account Generator PAAPWEBX PAAPWEBX.wftProject Supplier Invoice Account Generation PAAPINVW PAAPINVW.wftThe seeded wft files can be located in $PA_TOP/patch/115/import/US Q3. How do you determine the WF Item Key value to run wfstatus.sql for Account Generatorworkflows? Answer:  The item key is required in order to run wfstatus.sql for account generator. The wfstatus.sql givesimportant debug messages, including error messages for processes that are erroring out. This providessimilar information to that provided by the workflow status monitor.   Steps to determine the WF Item Key value:The item key can be found in the Workflow->Status form in Projects (Querying by item type and dates) or,more generally, via SQL*Plus from the table WF_ITEMS. A sample script for getting the key for thesupplier invoice account generator workflow is below: SELECT item_key, begin_date, end_dateFROM wf_items   WHERE item_type = 'PAAPINVW'   AND begin_date BETWEEN '&low_start' AND '&high_start';  If this does not definitively identify your item you can query on the various items in the workflow statusform to give you more information about the activities associated with them. Q4. Does the Project Supplier Invoice Account Generator have to be customized? Answer:  Yes, this account generator process MUST be customized. The seeded workflow calls a dummy functionPA_ACC_GEN_WF_PKG.AP_INV_ACC_UNDEFINED_RULES. This function does nothing but raise theerror FLEXWF-DEFAULT MISSING and exit with failure:The default workflow for the Oracle Payables account function Project Supplier Invoice Charge Accounthas not been customised.Please replace the dummy function in the default process for account generationby your own account generation method. Q5. How do I save my workflow definition to the database? Answer:  There are three options to use when saving your workflow definition to the database:Option #1If you have the file open in workflow builder select File > Save As > Database. Enter the apps usernameand password and provide the connection string (from the tnsnames.ora in the%ORACLE_HOME%\network\admin directory).Option #2The WFLOAD utility is used for loading and extracting workflow definition files to and from the database.Command Line Syntax:WFLOAD 0 Y [DOWNLOAD | UPGRADE | UPLOAD | FORCE] filename.wft[ITEMTYPE1 ITEMTYPE2 ...]   NOTE: The item type parameter is used only for the DOWNLOAD option. For full details of the modeoptions and WFLOAD see the chapter Oracle Workflow Loaders in the Oracle Workflow AdministratorsGuideOption #3  Run the concurrent program, Workflow Definitions Loader. The system administrator will need to add thisconcurrent program to a request security group for the responsibility that you want to run this programfrom. For additional information on the Workflow Definitions Loader program review the Oracle WorkflowGuide, Release 2.6 pages 2-84 thru 2-87. Q6. How do I assign different account generator processes for different operating units? Answer:  The actual process that will be called when the account generator is invoked is defined in the AccountGenerator Processes form. The navigation is Setup > Flexfields > Key > Accounts. In this form theFlexfield Application is Oracle General Ledger and the Flexfield is the Accounting Flexfield. Thestructure you select is the Accounting Flexfield structure being used by the set of books/ledger whoseaccount generator processes you are assigning. In the bottom zone of the form, there is a list ofapplicable item types followed by the process being used to generate the corresponding account.For each item type, you can select any 'Runnable' process defined within the workflow item type. A'Runnable' process is one which has the 'Runnable' attribute enabled in workflow builder. This processwill be called for all operating units which are using the select flexfield structure (chart of accounts).If multiple operating units use the same chart of accounts, then in order to use different logic for theaccount generation you would have to incorporate this logic into your workflow process. The ProjectSupplier Invoice Account Generator and Project Expense Report Account Generator include an attributefor the expenditure operating unit which can be used to branch to different logic or subprocesses basedon its value. Q7. How do I verify the version of Oracle Workflow that I have installed? Answer:  If you are running Oracle Workflow Embedded in Oracle Applications  You can run the following query: SELECT text FROM wf_resources WHERE name = 'WF_VERSION';    Alternatively you can use the script wfver.sql to extract this informationa. cd $FND_TOP/sqlb. Connect to SQL*Plus as APPS userc. Start wfver.sql (this script details the Workflow Server version, status and versioninformation for the Workflow packages and version information for the Workflow views) Q8. How do I display the Internal Name of an object in the Object Navigator? Answer:  Choose View, Developer Mode (this toggles on/off) With Developer Mode ON, the Internal Nameis displayed in the Navigator and the Display Name appears in brackets. o With Developer Mode OFF, the Display Name is displayed in the Navigator.
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks