You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Creating Reports and Extracts: How to map/link application front end fields to back end database tab

edited Jan 4, 2021 5:10PM in Reporting and Analytics for HCM 5 comments

Summary

Looking for a simple way to map application pages/fields to cloud database tables

Content

Good morning, 

I have been digging through the schema documentation while creating oracle reports for HCM, and was wondering if there was an easier way to map application fields to back-end cloud tables. 

Overview Cloud HCM Tables (oracle.com)

I come from the PeopleSoft realm where a simple CTRL+SHIFT+J would render the page menu/component for analysis. Are there any tips or tricks that could help outside of searching through the vast amounts of documentation per cloud application?

EX: I am looking at the Person Management page, and am wondering how I can extrapolate table information from the page. From digging into the documentation I know assignment data exists in the PER_ALL_ASSINGMENT_M. How would I find that without digging into the schema docs. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!