This content has been marked as final. Show 3 replies
It would be the operating unit which you find in the table HR_ALL_ORGANIZATION_UNITS. Look here for the ORGANIZATION_ID column.
select ORGANIZATION_ID from HR_ALL_ORGANIZATION_UNITS WHERE TYPE = 'OU' and NAME = :P
use the above SQL and give the name of the OU where you want to create the Purchase Orders.
You need to populate : org_id=3, PO will be based on OUs.1 person found this helpful
You can get OU details from HR_Operating_units table.
The SQL above is to make sure (double check) that you are populating the right ID, if you are confident about your first post (values are from the right organization) then go ahead and put ORG_ID =31 person found this helpful