My Oracle Support Banner

GST: Unable to apply the BOE on the receipt - Error ORA-01400: cannot insert NULL into ("JA"."JAI_BOE_MATCHINGS_GT"."BOE_ID") (Doc ID 2636473.1)

Last updated on FEBRUARY 14, 2020

Applies to:

Oracle Financials for India - Version 12.1.3 to 12.2.8 [Release 12.1 to 12.2]
Information in this document applies to any platform.


When attempting to apply the BOE on the receipt,
the following error occurs.


ORA-01400: cannot insert NULL into ("JA"."JAI_BOE_MATCHINGS_GT"."BOE_ID")

Steps for replication
The issue can be reproduced at will with the following steps:
1. Create BOE with reference to PO.
2. System will generate the BOE invoice, and make payment to the invoice.
3. Create receipt and navigate to receipt line application.
4. Observe the system is not allowing to apply BOE on the receipt with an error.

Note: This is observed specifically for cases where shipment stands cancelled.

The issue has the following business impact:
Due to this issue, users cannot import the goods.


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.