You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Create analysis using logical SQL error?

Summary:

Invalid SQL Identifier: fusion.per_allocated_checklists ac. error

Content (required):

Hi All,

We are looking at building OTBI analyses for identifying allocated checklists for data cleanup. We downloaded this SQL from a KM (Doc ID 2918203.1) and tried to build an analysis using logical SQL. We received this error below. Has anyone run into this before?

Invalid SQL Identifier: fusion.per_allocated_checklists ac.

Issued SQL: SELECT l.meaning FROM fusion.hcm_lookups l WHERE l.lookup_type = 'CHECKLIST_CATEGORY' AND l.lookup_code = ac.checklist_category ) category_name , ac.checklist_id , nvl ( ( SELECT c.name FROM fusion.per_checklists_vl c WHERE c.checklist_id = ac.checklist_id ), to_char (ac.checklist_id)) template_name , count (ac.allocated_checklist_id) total_more_than_180days_allocations , sum (CASE WHEN ac.checklist_status IN ('COM', 'REJ') THEN 0 ELSE 1 END) open_more_than_180days_allocations , ( SELECT count (pac.allocated_checklist_id) FROM fusion.per_allocated_checklists pac WHERE pac.checklist_id = ac.checklist_id AND ( pac.checklist_status IS NULL OR pac.checklist_status NOT IN ('COM', 'REJ') ) AND pac.creation_date < trunc (sysdate) - 180 AND ( SELECT max (atv.last_update_date) FROM fusion.per_allocated_tasks atv WHERE atv.abs_allocated_checklist_id = pac.allocated_checklist_id ) <= trunc

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!