Hey! I can definitely help with this. Looking at your setup, the most likely issue is that line in your prompt that says "Also please mention why Check_Reservation is not executed everytime" this is actually instructing the agent to talk about why the function isn't called rather than just calling it, which can confuse the LLM into skipping the actual function execution.
When you test the agent and provide a reservation number, what does it do does it just move on without checking, or does it acknowledge the number but skip the lookup entirely?