Expired Global Blanket Agreement Items Still Available In iProcurement Catalog (Doc ID 375678.1)

Last updated on APRIL 20, 2023

Applies to:

Symptoms

And expired Global Blanket Purchase Agreement is still available in iProcurement search results.  The Global Blanket Purchase Agreement (GBPA) was extracted into iProcurement. The GBPA reached the end-date. 

The users ran the Catalog data purge and only the item tied to the same org_id where the GBPA was created is deleted. Users can still search the item in iProcurement in other organizations.

Steps to Reproduce
1.  Create GBPA with one line (expense or master item) and enter a future end-date under terms.
2.  Run the Catalog extractor
3.  Verify that the item is available for ALL the organizations and is searchable in iProcurement
4.  When the GBPA reaches the end-date defined under terms in the GBPA, run the Catalog Data Purge program.
5.  Search for the item in the organization where the GBPA was created and the item is not found.
6.  Search for the item in other organizations - the item is still found (it should have been purged)


Error received
No error received. Users expect to have all the items in all the organizations deleted for this GBPA after running the Purge program

Business Impact
Inconsistent iProcurement catalog search results.

Cause

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