BIP - how to find fields, tables and joins in HCM - Entity Relationship Diagrams (ERDs)

Geraud Andreux

Organization Name: Euroclear

As confirmed to me via SRs and messaging Oracle employees, as well as by our 3 integrators, there is no documentation currently available regarding the relationships between the tables in the system. Assuming we manage to find the table which contains the field we want (more on that in a separate idea), we would still need to find the related tables to be able to join back to other data.

Core HR tables are still relatively manageable because they are similar to EBS ones and quite simple, but the more recent modules like Learn or Journeys are proving much harder to back engineer.

The "HCM tables" document is not helpful as the only vague mentions of relations between tables is sometime a reference to "foreign key to..." but it's not systematic, nor does it show the overall structure. We end up poking in the dark for days with no guarantee of success.

In Taleo Learn, there are searchable PDFs available, displaying the tables, their names, the tables immediately linked to them (parent and children tables), the connection keys to use, hard coded parameters if relevant, and cardinalities. They are in effect ERDs (entity relationship diagrams), for those of us speaking DBease.

In Oracle RightNow, this is even completely integrated in the reporting tool, as, starting from any table, you can "drill down" into any other related table in the system, and the joining keys are built for you.

Either of these solution work very well to figure out how to structure a complex query.

As you probably have these documents available somewhere in development (how to design a system otherwise?), can you please make them available to the community?

thanks to upvote this idea if you feel the same need and, Oracle, thanks to make this a priority,

best regards,

Géraud

Sudheer YN

we need ERDs for SCM and Procurement Tables.

Garth Noakes

It makes using Reports and Analytics rather useless (or at least, very timeconsuming) - hit and miss. Is the norm to get Oracle in to develop custom reports?