My Oracle Support Banner

9.2.33PO Dispatch Is Going To No Success When A Future Dated GLN Is Setup (Doc ID 2586691.1)

Last updated on JANUARY 04, 2021

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Purchase Order Dispatch process is going to No Success when a future dated GLN is setup


Steps to Reproduce the Issue:
1.Navigate to Main Menu > Purchasing Definition > Business Unit Options (Tab) > Allow GLN Display is checked
2.Suppliers > Supplier Information > Add/Update Supplier > Supplier > Search for supplier ID (Ex -SCM00000003 > Location (Tab)
3.Add new row with future date under details for default location MAIN
   Under ID Numbers > add a row for type GLN and ID number
4.Click on Procurement link and check UPN ready flag under additional procurement options
5.Purchasing > Purchase orders > Add/Update POs > Create a PO for the supplier ID - SCM00000003
   Add PO lines and approve PO
6.Purchasing > Purchase Orders > Dispatch Pos
7.Select BU and PO ID > Run POXMLP process
8.Process goes to No success
9.Go to PO_DISPATCH Message log and found below error -

Error
SQL error. Function: SQLExec Error Position: 27 Return: 1407 - ORA-01407: cannot update ("EMDBO"."PS_POHDREXT_TAO"."STD_ID_NUM_VNDRGLN") to NULL Statement: update ps_pohdrext_tao set STD_ID_NUM_VNDRGLN = ( SELECT SUBSTR(VNDLID.STD_ID_NUM, 1, 20) FROM PS_VNDR_LOC_ID_NBR VNDLID WHERE PS_POHDREXT_TAO.PROCESS_INSTANCE = :1 AND VNDLID.SETID = PS _POHDREXT_TAO.VENDOR_SETID AND VNDLID.VENDOR_ID = PS_POHDREXT_TAO.VENDOR_ID AND VNDLID.VNDR_LOC = PS _POHDREXT_TAO.VNDR_LOC AND VNDLID.STD_ID_NUM_QUAL = 'GLN' AND VNDLID.EFFDT = ( SELECT MAX(EFFDT) FRO M PS_VNDR_LOC_ID_NBR VNDLID1 WHERE VNDLID1.SETID = PS_POHDREXT_TAO.VENDOR_SETID AND VNDLID1.VENDOR_I


SQL error in Exec. (2,280) PO_DISPATCH.PO_Dispatch_Data.OnExecute Name:getVendorGLN_UPN PCPC:927 Statement:20 Called from:PO_DISPATCH.PO_Dispatch_Data.OnExecute Name:fillHeader Statement:324 Called from:PO_DISPATCH.MAIN.GBL.default.1900-01-01.Step09.OnExecute Statement:2
Process  ABENDED at Step PO_DISPATCH.MAIN.Step09 (PeopleCode) -- RC = 8



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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