How to Extract XML Tags used in Payslip

Below are the Steps to Extract XML tags used in Payslip

11.       Create a temporary table to hold the XML Data using APPS Login

CREATE TABLE TEMP_PDF_PAYSLIP_XML
(
XML_DATA BLOB,
ASSIGNMENT_ACTION_ID NUMBER,
CREATION_DATE DATE)

22.       Add below mentioned code to the end of procedure PAY_PAYROLL_XML_EXTRACT_PKG.GENERATE. Make sure to identify the GENERATE procedure used by PDF Payslip as per the signature mentioned above.

INSERT INTO TEMP_PDF_PAYSLIP_XML
VALUES (P_XML,P_ACTION_CONTEXT_ID,SYSDATE);
COMMIT;

Save the Package Body and compile the changes. Make sure the compilation completes successfully.

33.       Acess PDF Payslip for the required employee. The XML generated will now be saved to temporary table TEMP_PDF_PAYSLIP_XML. The Column ASSIGNMENT_ACTION_ID has the Assignment Action ID corresponding to the Payroll Archive run of the Employee for which Payslip is viewed. For debugging purpose, if same Payslip is accessed multiple times, the column CREATION_DATE can be used to retrieve the latest XML.

44.        Do not Forget to remove the changes in PAY_PAYROLL_XML_EXTRACT_PKG.GENERATE once the debug activity is complete.

Reference Note ID: How To Find Custom XML Tags For PDF Online Payslip (Doc ID 1909531.1)