My Oracle Support Banner

P11D Output Ends In Error ORA-06592: Case Not Found While Executing Case Statement (Doc ID 2383923.1)

Last updated on SEPTEMBER 06, 2019

Applies to:

Oracle HRMS (UK) - Version 12.1 HRMS RUP10 and later
Information in this document applies to any platform.


On : 12.1 HRMS RUP10 version

When attempting to run P11D process,
the following error occurs.

} get_paye_contact_rec_at
OPEN c_oi(81|120/E50001|2017-2018)
Error at step 0 in pay_gb_p11d_xml.generate_xml_header-ORA-06592: CASE not found whi
le executing CASE statement
} EXP in .generate_xml_header(5467254|io:*0)
backtrace:{ORA-06512: at "APPS.PAY_GB_P11D_XML", line 4022
Entering pay_core_mag_file.clear_context_values
Parameters passed are
Payroll Action Id : 5467254
Leaving pay_core_mag_file.clear_context_values
Error in pay_core_mag_file.loc_merge
SQLCODE : -20001
SQLERRM : ORA-20001: Error at step 0 in pay_gb_p11d_xml.generate_xml_header

The issue can be reproduced at will with the following steps:
1. Login using UK HRMS Manager
2. (N) -> Process and Reports -> Submit process -> P11D Legislative process
3. (N) -> Process and Reports -> Submit process -> P11D XML Output


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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