Dear Team,
I am new to Oracle Database (11g) and working in an integration project with SAP system. The scenario is to send reponse of a SAP request.
Oracle database stores all the vendor information.SAP requires information of vendor throuh a request and Oracle database has to send the
response.I have confirmed the schemas of the request and response and seems no issue with that.
Now the issue is with the generation of the response from Oracle database.Help is required from experts on the following.
Note : The ping connection from SAP to Database is working. with the user as we have given proper authorisation to the user to fetch the values
from the view.SAP is using select query with single value of Customer Id as primary key in every request.
1.Where to check the traces/logs in the Database for the request coming from SAP?
2.Which parameter would exactly tell the reason for the slow response for the response generation from Oracle?
3.Do we have to maintain any parameters for the request/response scenarion in database?
4.Any further valuable input would be appreciated.
Regards
Rebecca