Custom invoice print program issue.

Our 12.2.10 EBS on 19c database is having this issue wherein custom AR Invoice print programs for US are running for hours, however, for UK the programs completed successfully. Looking for leads on how to resolve this issue. The program is assigned to a custom manager. Normally this program completes within half an hour. Most of the database sessions of the program and running either of these three queries:

SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_VALUES_SITE_V WHERE PROFILE_OPTION_ID = :B2 AND APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL

SELECT PROFILE_OPTION_ID FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1