Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

how to join pjf_projects_all_b and PAY_COST_ALLOCATION_KEYFLEX in fusion

In EBS we used the below query and later it needs to be linked with AP Invoices details….

SELECT
hou.name,
pcak.segment2 cost_center,

from
pjf_projects_all_b ppa,
hr_all_organization_units hou,
PAY_COST_ALLOC_KEYFLEX pcak
where
1=1
AND ppa.carrying_out_organization_id = hou.organization_id (+)
AND pcak.cost_allocation_keyflex_id (+)= hou.cost_allocation_keyflex_id

But in Fusion cost_allocation_keyflex_id is NULL in hr_all_organization_units

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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