210 Oracle Error Ora-01403 No Data Found
Contents |
pl/sql is due to following reasons,Simplicity of the solutionEasier to develop separate small activities(procedure) instead of ora 01403 no data found ora 06512 in oracle single big one.Easy for future re-usability by just changing the Workflow
Ora 01403 No Data Found In Forms
activitiesEasier to change the order of processing by moving the activitiesSaving time by just moving the activitiesand most interestingly, Visible solution to provide an overview of business process.Workflow Upload ErrorsSometimes uploading/saving a workflow to the database may cause constraint errors as below,- 1602: Could not save.- 1400: Could not save to database. MODE=UPGRADE EFFDATE=- 1401: Could not upload ACTIVITY entity 'POAPPRV/POAPPRV_TOP'.- 210: Oracle Error: ORA-00001: unique constraint (APPLSYS.WF_PROCESS_ACTIVITIES_U2) violatedORA-01403: no data foundORA-06512: at "APPS.WF_LOAD", line 1988ORA-06512: at line 1. SQL text: BEGIN WF_LOAD.UPLOAD_PROCESS_ACTIVITY(:process_item_type, :process_name, :process_version, :activity_item_type, :activity_name, :instance_id, :instance_label, :protect, :custom, :start_end, :default_result, :icon_geometry, :perform_role, :perform_role_type, :user_comment, :level_error); END;So to avoid these kind of errors we need to remove the workflow from the database and then re-load the workflow.Offending rows are found by $FND_TOP/sql/wfrefchk.sql and Workflow should be removed from the database by the script provided by oracle at $FND_TOP/sql/wfrmitt.sqlThis takes ItemType as the parameter.Now upload the workflow from the command line with the following command,WFLOAD apps/apps@ XXXX.wftUPLOAD - honors both protection and customization level of the workflowUPGRADE - honors only protection level of dataFORCE - FORCE upload regardless of protection or customization levels.Unable to set NLS_LANGAUGE Error while saving or opening a Workflow from a Database:210: Oracle Error: ORA-01403: No Data Found: SQL Text: SELECT NLS_LANGAUGE from WF_LANGAUGES where :1 IN(NLS_LANGAUGE, CODE)This error occurs while you try to open an existing workflow from an Oracle Database or Save changes of an Workflow to the Database as below,This error occurs if no NLS_LANG environment variable comprising Language, Territory and Chara
» General Category » Technical Questions » Error saving PA Project Workflow - PAPROWF to database « previous next » Print Pages: [1] Go Down Author Topic: Error saving PA Project Workflow - PAPROWF to database (Read 2286 times) 0 Members and 1 Guest are viewing this topic. Saket Newbie Posts: 10 Error saving PA Project Workflow - PAPROWF to database « on: February 15, 2006, 04:01:46 PM » Hi,Thanks a lot for your answers.I am however facing a http://oracleappsilearn.blogspot.com/2009/07/oracle-workflow-faq.html strange problem now.I am trying to put back the standard PA Project Workflow - PAPROWF into the database. And I am now not able to save that and am getting this error:1602: Could not save.1400: Could not save to database. MODE=UPGRADE EFFDATE=2006/02/14 19:24:411401: Could not upload ACTIVITY entity 'PAPROWF/SUBPRO_PROJECT_APPROVAL'.210: Oracle Error: ORA-00001: unique constraint (APPLSYS.WF_PROCESS_ACTIVITIES_U2) violatedORA-01403: no data foundORA-06512: http://smforum.workflowfaq.com/index.php?topic=69.0 at "APPS.WF_LOAD", line 1987ORA-06512: at line 1. SQL text: BEGIN WF_LOAD.UPLOAD_PROCESS_ACTIVITY(:process_item_type, :process_name, :process_version, :activity_item_type, :activity_name, :instance_id, :instance_label, :protect, :custom, :start_end, :default_result, :icon_geometry, :perform_role, :perform_role_type, :user_comment, :level_error); END;I have searched on Metalink and have been advised to remove all standard processes and save and then save with the standard processes.That worked.But since the workflow requires the standard processes to run I am stuck.I have also run the following script:wfrmitms.sqlThis is severly affecting my work.Hope someone can help me resolve this issue.Thanks,Saket Report to moderator Logged Matthew Searle Administrator Hero Member Posts: 923 Re: Error saving PA Project Workflow - PAPROWF to database « Reply #1 on: February 16, 2006, 10:05:10 AM » Hi,Are you saving from the Workflow Builder, or via the command line? If you are not saving via the command line, do you get the same errors if you do?Matt Report to moderator Logged View my online profile on LinkedIN: http://www.linkedin.com/in/mattsearleHave you read my blog? http://www.workflowfaq.com/blog Saket Newbie Posts: 10 Re: Error saving PA Project Workflow - PAPROWF to database
due to following reasons,Simplicity of the solutionEasier to develop separate small activities(procedure) instead of single big one.Easy for future re-usability by just changing the Workflow http://oracleappsebizz.blogspot.com/2009/04/oracle-workflow-faq.html activitiesEasier to change the order of processing by moving the activitiesSaving time by just moving the activitiesand most interestingly, Visible solution to provide an overview of business process.Workflow Upload ErrorsSometimes uploading/saving a workflow to the database may cause constraint errors as below,- 1602: Could not save.- 1400: Could not save to database. MODE=UPGRADE EFFDATE=- 1401: Could not upload ACTIVITY entity no data 'POAPPRV/POAPPRV_TOP'.- 210: Oracle Error: ORA-00001: unique constraint (APPLSYS.WF_PROCESS_ACTIVITIES_U2) violatedORA-01403: no data foundORA-06512: at "APPS.WF_LOAD", line 1988ORA-06512: at line 1. SQL text: BEGIN WF_LOAD.UPLOAD_PROCESS_ACTIVITY(:process_item_type, :process_name, :process_version, :activity_item_type, :activity_name, :instance_id, :instance_label, :protect, :custom, :start_end, :default_result, :icon_geometry, :perform_role, :perform_role_type, :user_comment, :level_error); END;So to avoid these kind of errors we need to remove the workflow from the database and then re-load the workflow.Offending rows are no data found found by $FND_TOP/sql/wfrefchk.sql and Workflow should be removed from the database by the script provided by oracle at $FND_TOP/sql/wfrmitt.sqlThis takes ItemType as the parameter.Now upload the workflow from the command line with the following command,WFLOAD apps/apps@ XXXX.wftUPLOAD - honors both protection and customization level of the workflowUPGRADE - honors only protection level of dataFORCE - FORCE upload regardless of protection or customization levels.Hiding 'Request Information' button in an Email NotificationSometimes you may need to hide the Request Information button for an Email-notification according to client business requirements. For this oracle had provided a special message attribute with the internal name #HIDE_MOREINFO to hide the Request Information button in the notification details page.Usually when users view a notification that require a response from their worklist page, the response region in the notification details page includes the Request Information button by default. If you want to prevent users from requesting more information about a notification, you can add #HIDE_MOREINFO attribute to control whether the Request Information button is displayed or hidden.The #HIDE_MOREINFO attribute must be either of type text or Lookup