I have connected apex(24.2.10) on-premises with OCI Gen Service(cloud).
I have configured the below query in RAG soruce.
SELECT STORE_ID AS "store code",
STORE_NAME AS "store name",
CHAIN_NAME AS "chain",
REGION_NAME "region",
DISTRICT_NAME AS "district"
FROM EVA_STORES
When I prompt assistant regarding “How many stores under chain SENSI” then the Ai service is giving wrong result
For example the actual records are 10 but AI service returning 9 and some time 7.
I am using “cohere.command-r-plus-08-2024” model.
Also when I debug the log then I came to know that the request is sending incomplete data to AI service thats why result is wrong.
body: {"chatRequest":{"apiFormat":"COHERE","message":"how many stores in SENSI chain","preambleOverride":"PES Agent","chatHistory":[{"role":"CHATBOT","message":"STORES\005Cn```csv\005Cnstore code,chain,region,district\005Cn13024,TRAVEL RETAIL DUTY PAID,EASTERN,DAMMAM\005Cn13026,SENSI,EASTERN,DAMMAM\005Cn13027,OUTLET,EASTERN,DAMMAM\005Cn11096,TRAVEL RETAIL DUTY PAID,WESTERN,JEDDAH\005Cn11103,TRAVEL RETAIL DUTY PAID,WESTERN,JEDDAH\005Cn22001,MISHKAT,WESTERN,JEDDAH\005Cn11036,TRAVEL RETAIL DUTY PAID,WESTERN,JEDDAH\005Cn11038,TRAVEL RETAIL DUTY PAID,WESTERN,JEDDAH\005Cn11109,HNAK SOUVENIRS,WESTERN,MAKKAH\005Cn12045,SHAHBABUNA CONCEPT STORE,CENTRAL,RIYADH\005Cn11118,SHAHBABUNA CONCEPT STORE,WESTERN,TAIF\005Cn11122,JAD,WESTERN,MADINAH\005Cn12046,TRAVEL RETAIL DUTY PAID,CENTRAL,RIYADH\005Cn13006,TRAVEL RETAIL DUTY PAID,EASTERN,DAMMAM\005Cn13014,SENSI,EASTERN,DAMMAM\005Cn13023,SENSI,EASTERN,DAMMAM\005Cn11102,TRAVEL RETAIL DUTY PAID,WESTERN,JEDDAH\005Cn11105,TRAVEL RETAIL DUTY PAID,WESTERN,JEDDAH\00~
'