I've looked everywhere, and can't seem to find a current answer. Can you see books you've published besides the royalty report, as that cuts off after a number of books. Can you purchase books you've published? I can't imagine so many years after the release that you couldn't, but I don't know.
Welcome to the forum
@Aarontsc I'd like to address your question about purchasing books.
Honestly, I don't know whether Sims 4 on Console works the same as with Sims 4 for PC in this respect.
However, on the PC version, my sims can make/buy copies of books they've written but only before they've been published.
After a book's been published, it's gone (except for the royalties).
A copy of a book cannot be published, but it can be stored in the sims' bookcase for the household's reading enjoyment.
So a writer sim can publish the originals and, for specific books, keep copies to read.
To make a copy, place the original book on a surface, then have the sim click on the book and choose the option "Copy ($price)."
The original book remains on the ground while the copy appears in the sim's personal inventory.
For your sake, I hope copying books works the same for Sims 4 on Console.
Best wishes and happy simming