Projects - EBS (MOSC)

MOSC Banner

How to verify data of pa_bc_balances & pa_bc_commitments_all from System?

edited Sep 1, 2022 9:38AM in Projects - EBS (MOSC) 10 commentsAnswered

Hi All,

I need to cross-check the data of pa_bc_balances & pa_bc_commitments_all tables from system (values appearing on the forms). Please share details (navigations etc.) of the respective forms of Projects to verify the same.

Let me make it more clear. I am developing a report to show the BUDGET, ACTUAL, & AVAILABLE FUNDS against certain Project/Task. Below is the query, I developed to get my goal:

======================================================================

SELECT project_id, task_id,  

SUM (budget_period_to_date) Budget,

SUM (actual_period_to_date) Actuals,

SUM (encumb_period_to_date) Commitment,

SUM (actual_period_to_date) + SUM (encumb_period_to_date) USAGE,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center