change organization

when use the change organization to change the org, you can't change org_id because the profile of org_id is confirmed when enter a resp, but you can chang the mfg_organization_id because the value of the profile was assigned after you chose the organization.

---------------------------------------------------------------------------------------------------

 

BEGIN

 

fnd_global.apps_initialize(user_id=>67750,

 

resp_id =>67651,

 

resp_appl_id =>702

 

);

END;

select *from org_organization_definitions ood where ood.ORGANIZATION_ID=7324

 

To chose mfg_organization_id

--------------------------------------------------------------------------------------------------

 

SELECT *

FROM hr_operating_units

WHERE organization_id =1703

 

selectfnd_profile.value('ORG_ID')from dual

To chose org_id

---------------------------------------------------------