How to fetch "Relationship NoCB Fiscal Year to Date" dimension balance in HCM Extarct

Summary:

Unable to pull a specific usage record in HCM extract XML that contains the Relationship NoCB Fiscal Year to Date dimension.

Content (please ensure you mask any confidential information)

When running the Oracle-provided query (below), it returns only one ID for this Balance Usage, which is PAYROLL_REL_ACTION_ID. However, for other usages we are able to retrieve CLAC_BREAKDOWN_ID, TAX_UNIT_ID, PAYROLL_REL_ACTION_ID, and PAYROLL_ASSIGNMENT_ID.

SELECT DISTINCT ctx.basecontextname, pbgu.basegroupusagename

FROM PAY_BAL_GRP_USAGES pbgu, PAY_BAL_GRP_INCLUSIONS pbgi, PAY_BALANCE_ATTRIBUTES pba,

PAY_DEFINED_BALANCES pdb, PAY_BALANCE_DIMENSIONS pbd, PAY_DIM_CONTEXT_USAGES pdcu, ff_contexts_b ctx