My Oracle Support Banner

Supplier 360 Error: "CAFNUI_CORE.HANDLER.FactorHandler.PivotGridPagelet.OnExecute" (Doc ID 2559324.1)

Last updated on MARCH 12, 2021

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

After Fix BUG 27869233 applied starts to get another error: Supplier 360 error: "Invalid SQLExec update for this type of PeopleCode program. "
Analyze first supplier and return to home page. Upon clicking on Supplier 360 tile getting error:

ERROR
"Invalid SQLExec update for this type of PeopleCode program.

CAFNUI_CORE.HANDLER.FactorHandler.PivotGridPagelet.OnExecute Name:GetHtml PCP:5127 Statement:49

Called from:CAFNUI_API.FactorHandler.OnExecute Name:GetFactorDisplay Statement:84

Called from:CAFNUI_API.FactorHandler.OnExecute Name:GetFactorDisplays Statement:113

Called from:CAFNUI_CORE.HANDLER.ComparisonHandler.OnExecute Name:GetDataAreaNUI_A Statement:1878

Called from:CAFNUI_CORE.HANDLER.ComparisonHandler.OnExecute Name:GetDisplayNUI Statement:254

Called from:CAFNUI_CORE.HANDLER.ComparisonH

 

SQLExec commands with UPDATE, INSERT, or DELETE statements are only allowed in SavePreChange, SavePostChange, and Workflow type PeopleCode programs."



STEPS
The issue can be reproduced at will with the following steps:
1. Click Supplier 360 Fluid tile
2. Select vendor and click on Analyze button
3. Page displays with Fluid Supplier 360 back button in top left corner
4. Returns to Suppliers selection page
5. Click “Home Page” button
6. Click on Supplier 360 Fluid Tile
7. Getting the error: "A fatal PeopleCode SQL error occurred. Please consult your system log for details."
8. OK and getting the complete error:
  "Invalid SQLExec update for this type of PeopleCode program.
  CAFNUI_CORE.HANDLER.FactorHandler.PivotGridPagelet.OnExecute Name:GetHtml PCP:5127 Statement:49
  Called from:CAFNUI_API.FactorHandler.OnExecute Name:GetFactorDisplay Statement:84..."


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
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.