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

HDL to update / create Cost Centre Managers (PER_GL_COST_CENTER_INFO)

Accepted answer

A customer I support has approximately 1,500 Cost Centre Managers defined across 4 different Departments.

I can see that using this SQL:

-- cost centre count per department

	select dept
		 , count(*)
	 from hr_organization_v hov
	 join hr_organization_information_f hoif on hov.organization_id = hoif.organization_id
	 where 1 = 1
	  and hoif.org_information_context = 'PER_GL_COST_CENTER_INFO'
	  and hov.classification_code = 'DEPARTMENT'
	  and sysdate between hov.effective_start_date and hov.effective_end_date
	  and sysdate between hoif.effective_start_date and hoif.effective_end_date
	  and 1 = 1
 group by
 order by

When the customer first went live, most of the Cost Centre Manager setup was done using HDL against the "Organization" Business Object, and since Go Live a few hundred have been set up via the front-end in the "Manage Departments" screen.

Howdy, Stranger!

Log In

To view full details, sign in.


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