GST: Error "APP-JA-46024" While Applying Receipt To BOE

(Doc ID 2368344.1)

Last updated on MARCH 01, 2018

Applies to:

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

Symptoms

Reported issue
------------------
GST: Eligible BOE not visible for Application in Standard Receipt form.

Steps for Replication
1) Created & approved PO with USD as currency and applied Custom type tax
2) Created BOE for the same Supplier for whom we have created the PO.
3) Here the BOE has been created with out item reference.
4) Confirmed and paid the BOE invoice in AP to the authority.
5) Now in the standard receipt form The BOE invoice is visible for application..
  But when trying to apply on the receipt , it is throwing an error

Error message from screen shot :-
-----------------------------------------
Error message
app-ja-46024


Error message from fnd debug log
-----------------------------------------
JAI.PLSQL.JAI_TAX_RATE_PKG.TAX_RATE_INSERT 2 Exception occurred in Others. ORA-00001: unique constraint (JA.JAI_TAX_RATES_U1) violated
JAI.PLSQL.JAI_RCV_TAX_DET_PKG.confirm_tax 6 ORA-00001: unique constraint (JA.JAI_TAX_RATES_U1) violated
JAI.PLSQL.JAI_RCV_TAX_DET_PKG.confirm_tax 6 confirm_tax----End----()+
per.resource.HRKPI.hr_kpi_extlib.event 2 begin
per.resource.HRKPI.hr_kpi_extlib.event 1 #event_name#WHEN-NEW-ITEM-INSTANCE*formname*JAINREAP
per.resource.HRKPI.hr_kpi_extlib.event 2 end
JAI.PLSQL.JAI_RCV_TAX_DET_PKG.confirm_tax.BEGIN 2 confirm_tax----Begin----()+
JAI.PLSQL.JAI_RCV_TAX_DET_PKG.confirm_tax 2 p_trx_id : 3235008p_entity_code : RCV_TRANSACTIONp_event_class_code : RECEIVINGp_trx_type : RECEIVE
JAI.PLSQL.JAI_RCV_TAX_DET_PKG.confirm_tax 6 before check boe trx
JAI.PLSQL.JAI_RCV_TAX_DET_PKG.confirm_tax 6 check boe trx ln_boe_id 34156
JAI.PLSQL.JAI_RCV_TAX_DET_PKG.confirm_tax 6 ORA-01427: single-row subquery returns more than one row
JAI.PLSQL.JAI_RCV_TAX_DET_PKG.confirm_tax 6 confirm_tax----End----()+

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms