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 JANUARY 04, 2017

Applies to:

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

Symptoms

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms