Breadcrumb

AI-Powered Natural Language Querying for PeopleSoft Campus Solutions

Session Date & Time
-
Session Room
MR 9
Standard Presentation Intermediate

This proof of concept integrates Large Language Models (LLMs) with Oracle PeopleSoft Campus Solutions to enable natural language querying of class and course data, democratizing access to data. PeopleSoft manages essential student records and supports critical academic processes. This prototype, built with Python, LangChain, the ChatGPT API, Streamlit, prompt engineering, and schema transformation, offers a chatbot-style interface for users who may not be SQL experts to access data. User testing confirmed that LLM-generated SQL queries were syntactically correct and accurately reflected user intent, improving accessibility for non-technical users. Challenges included controlling query output and handling complex SQL operations like aggregation and pagination. Security and privacy considerations were also addressed. These findings lay the groundwork for future AI-driven natural language interfaces in Oracle PeopleSoft and other enterprise systems

Speaker/Host

Primary/Host Speaker
Frankie Pun

Frankie Pun

Application Programmer at UC Berkeley

Frankie is proud to be an integral part of the student journey. Students interact with his work throughout their time at UC Berkeley, from admission to graduation. He plays a crucial role in enhancing systems such as payment, student portal, and more, improving many aspects of the student experience.

Let us help you with your search