My Oracle Support Banner

CREATEPO Workflow Failing To Create POs When Profile Option HR: Business Group Set At Site Level ORA-01403: no data found (Doc ID 1361248.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Purchasing - Version 12.1.2 and later
Information in this document applies to any platform.


The CREATEPO workflow is failing to automatically create Purchase Orders (POs) when the profile option HR: BUSINESS GROUP is set at the site level using "local" ship to locations.

Steps to Reproduce:
1. Set the profile HR: Business Group at the site level to a default value (Say A) and HR: Cross Business Group is set to Yes.
2. There are two business groups (A and B) and two operation units available.
3. Have "Local" locations defined.
4. Using iProcurement, with the CreatePO workflow attributes set to automatically create POs once the Requisitions are approved.

The issue is:
Case 1. POs are automatically created from requisitions when created within business group A.
Case 2. When using a location from business group B the Createpo workflow is failing because it cannot find the ship to location.  The debug shows:
po.plsql.PO_INTERFACE_S.get_ship_to_loc10 1 No data found in hr_locations.
po.plsql.PO_INTERFACE_S.get_ship_to_loc20 1 No data found in hz_locations.
po.plsql.PO_INTERFACE_S.get_ship_to_loc20.EXCEPTION 4 100ORA-01403: no data found;SQLERRM = ORA-01403: no data found




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.