General Ledger - EBS (MOSC)

MOSC Banner

Query to Start Fiscal Year on July? YTD_Actual, YTD_Budget, Annual Budget, PYTD_Actual SQL

edited Dec 3, 2024 10:31PM in General Ledger - EBS (MOSC) 2 commentsAnswered

Hello Everyone, this is my draft query. Please advise what is missing to achieve the questions. Thank you so much.

SELECT DISTINCT
GB.PERIOD_NAME,
GCC.SEGMENT1,
FVS1.DESCRIPTION AS COMPANY_NAME,
GCC.SEGMENT2,
FVS2.DESCRIPTION AS FUND_TYPE,
GCC.SEGMENT3,
FVS3.DESCRIPTION AS REGION,
GCC.SEGMENT4 AS DEPARTMENT_CODE,
FVS4.DESCRIPTION AS DEPARTMENT_DESCRIPTION,
GCC.SEGMENT5 AS NATURAL_ACCOUNT_CODE,
FVS5.DESCRIPTION AS NATURAL_ACCOUNT_DESCRIPTION,
(SELECT NVL(SUM(GB1.PERIOD_NET_DR - GB1.PERIOD_NET_CR), 0)
FROM GL_BALANCES GB1
WHERE GB1.CODE_COMBINATION_ID = GB.CODE_COMBINATION_ID AND GB1.ACTUAL_FLAG = 'A') AS YTD_Actual,

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