Is there a back end table for bpms written?

Epicor ERP 9
1

Epicor version: 9.05.701

Just curious to know if there is a table for a list of all the BPM’s written and maybe even customisations?

That would be really useful to know.

Thanks in advance.

2

Hey there. I am using Vantage and there are a few tables that are used for BPMs in our environment:

  • bpaction
  • bpactiondata
  • bpactiongroup
  • bpactionqueue
  • bpactionqueuedata
  • bpactionsrc
  • bparguement
  • bparguementtypedef
  • bpbaseprodirective …

There are about 22 in total (I think). I don’t know about customisation’s

3

Don’t know if this will help, but when I am looking for a certain field and don’t know which table it is in I use this query:

USE [database name here]
GO
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE ‘%[Column to look for]%’
ORDER BY schema_name, table_name;

Maybe that could help you with what you’re looking for.

1 Like
4

I like to use the Solution Manager to quickly see all of my bpms, customizations, reports, etc. You need to make a new one and save it for it to populate the tabs.

Nancy

5

Thanks for your help guys, sorry for the delay.

Just exported the data tables into excel and it seems theres quite a few to work through:

6

Hi Rowley:

There are 3 tables from that list that will give you what you are looking for ( BPM’s created in Epicor). the other tables are the methods, conditions and actions listing etc.

  1. BpBaseProcDirective
  2. BpPostProcDirective
  3. BpPreProcDirective
2 Likes