VERIFIED SOLUTION i
X

Error ORA-01400 when Creating Batch Payments in Confirm

Issue

When trying to run Batch Create Payments in Confirm® the following error is received :

ORA-01400: cannot insert NULL into (""ENGINEER"".""PAYMENT_ITEM"".""PAYMENT_QUANTITY"")

Cause

In your Confirm database there is one claim_item record that has a null claim_quantity field.

Resolution

UPDATED: May 23, 2018


Supply/add the Claim Quantity through the Confirm client application. If this appears not to be possible or you are experiencing further difficulty, please raise a case with the Confirm Technical Support team.

The following SQL can be added as a datasource to identify which request items have a quantity of Null.

SELECT
   claim_header.contract_code,
   contract.contract_name,
   claim_header.claim_code,
   claim_job.order_number,
   order_job.job_number,
   claim_item.item_number,
   claim_item.sor_item_code,
   claim_item.claim_quantity,
   claim_item.claim_occasion,
   claim_item.claim_value
FROM
   claim_header,
   claim_item,
   claim_job,
   contract,
   order_job
WHERE
   contract.contract_code = claim_header.contract_code AND
   claim_header.contract_code = claim_job.contract_code AND
   claim_header.claim_code = claim_job.claim_code AND
   order_job.contract_code = claim_job.contract_code AND
   order_job.order_number = claim_job.order_number AND
   order_job.order_job_number = claim_job.order_job_number AND
   claim_job.contract_code = claim_item.contract_code AND
   claim_job.claim_code = claim_item.claim_code AND
   claim_job.order_number = claim_item.order_number AND
   claim_job.order_job_number = claim_item.order_job_number AND
   claim_item.claim_quantity IS NULL

Environment Details

Products affected: Confirm®
Product feature: Payment Processing

Downloads

  • No Downloads