UK Pay: P11D Legislative Process Ran in Supplementary Mode not Available When Running P11D Reports (PDF) (Doc ID 2565346.1)

Last updated on DECEMBER 04, 2019

Applies to:

Symptoms

Problem Statement:
Unable to Find Supplementary P11d in P11D Reports (PDF)
User made a supplementary P11D run using P11D Legislative Process. This archive request id is not available in the LOV when running P11D Reports (PDF)
The value set for Archive request ID (PY_GB_SRS_P11D_ARCH_ACTIONS) it only allows P11D runs of type Main or Test:

WHERE a.report_type='P11D'
AND a.report_qualifier='GB'
AND a.report_category in('P11D_ARCHIVE_SS' ,'ARCHIVE')
AND a.action_status = 'C'
AND a.action_type = 'X'
AND a.business_group_id +0 =
:$PROFILES$.PER_BUSINESS_GROUP_ID
AND PAY_GB_P11D_ARCHIVE_SS.get_parameter_value(a.payroll_action_id,'Run_Type') in ('M','T')
ORDER BY a.effective_date desc, a.request_id desc

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1.Run P11D Legislative Process with Run Type parameter set to Supplementary
2. Try to run P11D Reports (PDF). The archive ID is not in the list

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.