Catalog PV_CP_LOAD Not Updated Catalog Tree For All Catalog Item Changes (Doc ID 1662123.1)

Last updated on MAY 24, 2021

Applies to:

Symptoms

Catalog –PV_CP_LOAD does not update Catalog tree for all catalog item changes. Full Load for catalog happens correctly, but when doing incremental load\update to the existing catalog item. For example, updating category for items, it does not happen for all. Item Master, it updates the category, but tree node does not change\updates.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
There are 2 sections –
Section A-Full Load

----------------------------

Section B-Incremental Load

----------------------------------

Section A-CATALOG FULL LOAD

1. Navigate to Main Menu-Catalog Management-Catalogs-Maintain Catalogs-Add a New Value

2. Enter Catalog Name , Catalog type , Partners , Enterprise User ID, Categories and workflow Option-Save the Page

3. Navigate to Catalog Management > Catalogs > Maintain Catalog Sources > Define Catalog Source

4. Enter the Description and Upload Sample files

5. Sample File Uploaded-Check the Source fields. Save the Page

6. Navigate to Main Menu > Catalog Management > Catalogs > Import Catalog Sources

7. Upload the File

8. Click on Import to Import the file-Run EOCM_IMPORT process to Success and Posted. Check the File-It should be  Imported now

9. Navigate to Main Menu > Catalog Management > Catalog Management Home

10. Navigate to Partner Catalog Console > Define Catalog Map. Enter the Source and Save the Page

11. Navigate to Map Field Details and Click on Apply Auto Mapper. Enter the Source Input type as well as Source Prompt. Check the Target Field Defaults. Save the Page

12. Navigate to Partner Catalog Console > Load Catalog Map

13. Run a Full Load . Run EOCM_RUN_MAP to success and Posted

14. Check the Catalog. It is Loaded

15. Navigate to Catalog Management > Categories > Maintain Rules > Add a new Categorization Rule

16. Navigate to Catalog Management Home > Partner catalog Console > Categorize Offerings > Enter the Categorization Rule ID and save the page

17. Run Categorization . Run EOCM_CZATION process to success and posted

18. Check the Partner catalog console. It is Categorized

19. Navigate to Partner Catalog Console and Click on Approve Proposed Categories and Catalog Offerings

20. Run EOCM_APPROVE to Success and Posted

21. Navigate to partner Catalog Console and click on Stage Partner offerings-Run EOCM_STAGE to Success and Posted

22. Navigate to Partner Catalog Console > Browse Staged Partner Offerings

23. Navigate to Enterprise Catalog Console > Move Catalog to Production. Run EOCM_MTP to Success and Posted

24. Check the Catalog Version no in Enterprise catalog Console

25. Navigate to eProcurement > Administer procurement > eProcurement installation options > Ensure catalog search type is TSE and catalog management as epro item source is checked

26. Navigate to eprocurement > Administer procurement > Maintain Linked Supplier > Add a Catalog Management Supplier. Enter the Partner ID and Trading Partner name

27. Navigate to eprocurement > Administer procurement > Maintain Supplier integration > Import Item Catalog File. Create a new Tree name. Enter the item defaults also. Save the Page

28. Run the PV_CP_LOAD to Success and Posted

29. Check the Items loaded by clicking on Process Imported Items available in run control page for PV_CP_LOAD

30. Check the Items in Item-Define items and attributes

31. Check the items in Tree manager. Hence the Full Load got completed.

Now Section B Starts
Section B—Incremental Load

1. Navigate to Main Menu > Catalog Management > Catalogs > Import Catalog Sources. Enter the Catalog Source used for Full Load and SET ID and Search

2. Add a File –Upload the Incremental Load CSV File

3. Click on Import and run EOCM_IMPORT to Success and Posted

4. The file is imported now

5. Navigate to Main Menu > Catalog Management > Catalog Management Home > Check the Catalog

6. Navigate to Main Menu > Catalog Management > Catalog Management Home >Define Catalog Map> Take an Existing Map used for Full load earlier

7. Navigate to Partner Catalog Console > Take and Incremental Upload option this time. Run EOCM_RUN_MAP to Success and Posted

8. Check the Partner catalog Console-It is loaded now

9. Navigate to Main menu > Catalog Management > Categories > Maintain Rules > take the existing categorization rule

10. Navigate to Partner Catalog Console > Categorize Offerings > Run Categorization > Click OK to kick off the AE. Use the same Categorization Rule ID as used for full load. Run EOCM_CZATION to Success and Posted

11. Check the Partner Catalog Console. Load state is “Categorized”

12. Navigate to Partner Catalog Console > Approve Proposed Categories and Catalog Offerings. Run EOCM_APPROVE to Success and Posted

13. Navigate to partner catalog console >Stage Partner offerings. Run EOCM_STAGE to Success and Posted

14. Partner catalog console is staged

15. Navigate to Main Menu > Catalog Management > Catalog Management Home >Enterprise Catalog Console > Move Catalog to production > Run Move to production process. Run EOCM_MTP to Success and Posted

16. Check the Enterprise Catalog Console Version no

17. Check the eprocurement installation option page. Navigate to eprocurement >Administer procurement >eProcurement installation Options >TSE is enabled

18. Navigate to eprocurement > Administer procurement > Linked Supplier > Search for Catalog Management Supplier

19. Navigate to eprocurement >Administer procurement > Supplier Integration> Import item catalog file > procurement catalog load > Run the PV_CP_LOAD to Success and Posted

20. Check the Tree Manager

21. Replication Finishes. Lets verify the file

22. The modified  category after incremental upload does not get updated in the Tree Manager however the category gets updated correctly in Define items > Items and Attributes

Changes

Cause

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