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

looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre Manager

in Reporting and Analytics for ERP 3 comments

Hi All,

I'm looking for help in building an SQL query in Oracle Fusion that can retrieve Cost Centre Manager details by combining data from both:

  • The Notifications table (WF_NOTIFICATIONS), and
  • The Administration Approval Groups tables (WFAPPROVALGROUPS and WFAPPROVALGROUPMEMBERS)

The query should ideally map each Cost Centre Manager to their respective Department / Cost Centre.

Has anyone developed a similar query or can suggest the best way to link the approval group or notification data with the department or cost centre hierarchy (for example, from FND_TREE_NODE or related GL structures)?

Any guidance or sample SQL snippets would be greatly appreciated!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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