Catalog PV_CP_LOAD Not Updated Catalog Tree For All Catalog Item Changes
(Doc ID 1662123.1)
Last updated on JULY 08, 2020
Applies to:
PeopleSoft Enterprise SCM eProcurement - Version 9.1 to 9.2 [Release 9]PeopleSoft Enterprise SCM Catalog Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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
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 |