Need Help Filtering Records in ESS Job: Import and Validate Electronic Fiscal Documents
Hello Team,
We are currently loading bulk data into the FDC interface table. At present, the interface table contains approximately 50,000 records with an IMPORT STATUS of ERROR.
Our requirement is to process only the newly loaded records—specifically, those with IMPORT STATUS as NULL using the Import and Validate Electronic Fiscal Documents ESS job.
However, when we run the ESS job with the parameter "Fiscal Documents to Validate = New", it attempts to reprocess all records in Interface table, resulting in long ESS job runtimes and performance issues.
Could you please advise if there is any alternative parameter or configuration that allows us to restrict the ESS job to pick up only the records with IMPORT STATUS as NULL?