Accounting Date in HCM - Workforce Rewards - Payroll Costing

Sean-B-01

I have a need from end users to add in the Accounting Date column to our payroll reports. It's an ootb column, when I add it to the report it returns the error of:

State: HY000. Code: 14025. [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Detail,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Detail,,[Dim - HCM - Payroll Action.Payroll Action Code, Dim - HCM - Payroll Action.Payroll Action],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - HCM - Payroll Run Costing Details.Balance Or Cost, Dim - HCM - Payroll Run Costing Details.Balance Or Cost Code],,,,Detail,,,,,[Dim - HCM - Costing Segments.Segment1 Code, Dim - HCM - Costing Segments.Segment1 Description, Dim - HCM - Costing Segments.Segment2 Code, Dim - HCM - Costing Segments.Segment2 Description, Dim - HCM - Costing Segments.Segment4 Code, Dim - HCM - Costing Segments.Segment4 Description, Dim - HCM - Costing Segments.Segment5 Code, Dim - HCM - Costing Segments.Segment5 Description, Dim - HCM - Costing Segments.Segment6 Code, Dim - HCM - Costing Segments.Segment6 Description, Dim - HCM - Costing Segments.Segment7 Code, Dim - HCM - Costing Segments.Segment7 Description],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - HCM - Input Value.Input Value Name],,,,,,,,,,,,,,,,,,,[Dim - HCM - Payment Costing Details.Accounting Date],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Worker.Person Full Name, Dim - Worker.Person Number],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Details,,,,,,,,,,,,,,,,,,,,,[Dim - Assignment Details.Assignment Status Code, Dim - Assignment Details.Assignment Status, Dim - Assignment Details.Assignment Number],,,,,,,,,,,,,,,,[Dim - Department.Department Name, Dim - Department.PER_ORGANIZATION_UNIT_NNRS_TPRTNT_CT_],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, (HY000)State: HY000. Code: 14025. ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Detail,Detail,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]. (HY000)

I'm curious if anyone else has run into this and if so did you join the tables through SQL Developer or what would best practice be for linking the tables?

Thank you,

Sean

Ashish-Oracle

@Sean-B-01 The error you are observing is clearly due to absence of underlying fact table at the requested details. Have you tried using the CAA functionality and see if your requirement can be achieved.

FAW:23.R3.x:CAA: Using GA advanced reporting feature Configurable Account Analysis (CAA) (Doc ID 2980290.1)

. https://docs.oracle.com/en/cloud/saas/analytics/24r2/faiae/advanced-configurations.html#GUID-2B6FB331-FB88-485E-9A8B-802F1B95B40E

Sean-B-01

@Ashish-Oracle I have not tried using the CAA functionality, I will test later today and see if that solves the issue!

Thank you!

Ashish-Oracle

Sure @Sean-B-01

Nupur Joshi-Oracle

@Sean-B-01 @Ashish-Oracle - CAA cannot be used for anything related to Payroll Costing. It is not a supported use case. Here you are trying to use Accounting date which is only supported on Payment Costing ( same as OTBI ) - this cannot be used against Run costing Fact.

Regards,

Nupur