Oracle R12 – APPS-SQL-10000: ORA-01400: Cannot insert NULL into
I have come across this issue before. First I would be advising that you turn tax off on the POs, there is no need to have it if you recover 100% VAT and it does cause issues like the one you are seeing.
One of the causes could be that in PO, it cannot calculate offset taxes, only the positive VAT part. So the tax on the PO will be wrong anyway, it will be say FR VAT EU AP GOODS 20% and won’t have the FR OFF EU AP GOODS 20%. If you are forcing the tax rate in from the PO, then it could be causing the issue as AP would want the Offset tax.
Change the settings below to remove the ‘enforce’ options and this should fix your issue.
Latest posts by eBiz Admin & Support (see all)
- Bulgarian Oracle User Group – Spring Conference 2016 - 31/05/2016
- Join eBiz Answers at the UKOUG Financials SIG - 15/02/2016
- Register for Oracle Tax Management SIG webinars - 01/02/2016