My Oracle Support Banner

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

Last updated on MAY 21, 2021

Applies to:

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


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:

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

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




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

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