Failed to connect to database - Unable to connect to Oracle Applications database (afscpgcs)

PROBLEM

I had error when tried to coonect BI Discoverer.

A connection error.
- Oracle BI Discoverer is unable to authenticate using the password provided. This can happen due to an invalid password or because the password was lost while using back, forward, or refresh in your browser. Enter the password again to continue.
- Failed to connect to database - Unable to connect to Oracle Applications database (afscpgcs)


SOLUTION
Copy application .dbc file under Middelware_Home\asinst_no\config\Discoverer\Discoverer_asinst_no

how to count EBS users

query:

SELECT user_id, user_name, full_name
    FROM fnd_user fu, per_all_people_f papf
   WHERE papf.person_id = fu.employee_id
         AND SYSDATE BETWEEN fu.start_date AND NVL (fu.end_date, SYSDATE)
         AND SYSDATE BETWEEN papf.effective_start_date
                         AND NVL (papf.effective_end_date, SYSDATE ) ORDER BY 2;