Oracle Software Developer interview questions

The process was highly disorganized. The recruiter gave me a set of teams to select from and initially told me that there would be an onsite interview. Later, she set up phone interviews with the teams. One of the interviewer asked for a programming interview but my recruiter didn't arrange for that despite my repeated emails. I was then dropped from consideration on that team which I wasn't told about until I had to send them repeated emails. Finally they asked me to fly to headquarters and interview two teams. On site, one of the team interview was pretty easy. It was with the manager and he wanted to know more about me and almost offered me a job on that team. The second team had about five rounds of interviews all technical. After the interview they asked me to send team preferences and within 2 hours, they sent me a reject. I asked them what happened to the "almost offer" and was met with radio silence! There was no feedback and nothing after a harrowing process they put me through.