I do not believe there is a way to determine this by querying the EBS database. You will have to consult your documentation that captures all customizations being made to an EBS database
Thank you for you reply, the query is not available to find out the customized workflow. but there is way to find out from the frontend.
Thanks & Regards
Not that I am aware of - the only way is to look at the documentation of your customizations
This is a tricky one to tackle because you cannot rely on the VERSION column that some design tables have - the VERSION will change everytime you upload the WFT file into the database even if you did not customize anything.
Also, check the user access level will not help because the user can switch it back to the value it had before the customization.
I think a fast (yet manual) way to find customizations is do download from the DB the current definition of the workflow into a WFT file and compare that file to the standard/seeded one provided by apps (which is located under <prod_top>/patch/115/import/US directory). For instance, WinMerge is a tool that can do the comparison fairly well and you can spot there the differences.
Edited by: Alejandro Sosa on Feb 4, 2013 6:57 AM
An another possibility is to do the opposite to what I just wrote. Upload the true definition to the database an compare with the one you are not sure about via SQL:
1. Backup the WFT file where the standard/seeded workflow is provided
2. Edit it and change the name of the ITEM_TYPE. For instance, change it from OEOL to OEOL_TMP (cannot exceed 8 characters)
3. Upload it to the database with WFLOAD
4. Compare the design tables for the two if them (WF_ITEM_TYPES, WF_ACTIVITIES, WF_MESSAGES, WF_PROCESS_ACTIVITIES, WF_ITEM_ATTRIBUTES, etc). If the table provides a VERSION column then the query would need to use a WHERE END_DATE is null (so that you get only the active/current version of the object). A select... MINUM select would do the job.
I would do this in test though, to avoid a mistake can cause any issues.
Edited by: Alejandro Sosa on Feb 4, 2013 7:07 AM
I have run the following query for finding the customization. here is the one column CUSTOM_LEVEL which tell the customization percentage. I want to know that it is the right way to find out the customization. The query is :
SELECT NAME WF_NAME,DISPLAY_NAME,CUSTOM_LEVEL FROM WF_ITEM_TYPES_TL WHERE CUSTOM_LEVEL>0 AND PROTECT_LEVEL>0 ORDER BY custom_level
Thanks & Regards
I have a similar requirement where the seeded .wft (say oexwford.wft )file has multiple item types(like OEOH, OEOL,etc) included in the same file. But the Database version of the OEOL.wft has contents only related to OEOL Item Type. So Diff command or KDIFF tool whch we use to fnd the difference will obviously show differences though the seed is not customized. Could you please suggest me if you have had any solution by now.