If one has had disturbed digestion for an extended time and/or if one is getting on in years, B12 absorption can be poor even when proper digestion is restored.
That has been true in my case.
I have used B12 in various forms.
Oral does not absorb very well for me.
I have used the self-administered shots at about the amount and frequency that you are using for several years in the past.
Had at least 2-3 years where I needed 1-3 or more 10 ml shots a week.
Now, I mainly use an inhaled form. Take a look at this thread for a few more details:
Feel free to ask if U have more questions.
BTW, I determine whether I need more by whether I develop otherwise unexplained fatigue. I take a sample shot every 3-6 months to see if I do better with it.
Never had the colored pee.
Have the symptoms for which you were taking the B12 resolved???
If not, the colored pee may indicate it is not being utilized???