R12: AP: Unable To Enter Invoices, Invoice OnLine Validation or Tax Calculation Raises Error APP-SQLAP-97731 (AP_CANNOT_GEN_DIST_DUE_TAX)
(Doc ID 2885124.1)
Last updated on DECEMBER 07, 2023
Applies to:
Oracle Payables - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
India and EMEA users are unable to enter Payables Invoices.
When attempting to create an invoice, the following error occurs.
Steps to reproduce:
- Log into Oracle Applications using Payables responsibility.
- Open the Invoice Workbench screen
(N) Invoices > Entry > Invoices - Create a new Invoice.
- Try to Validate (OnLine) the Invoice.
THE ERROR OCCURS
FND Debug Log of the issue reproduced shows the customer is using a third party software, SABRIX for Tax calculation and the failure is raised within the SABRIX code:
MODULE - LOG_LEVEL - MESSAGE_TEXT - CALLSTACK
...
...
ZX.PLSQL.ZX_TPI_SERVICES_PKG.CALL_PARTNER_SERVICE 1 No. of records in ZX_PTNR_SRVC_INTGRTN_PKG.G_TAX_CURRENCIES_TBL : 50
ZX.PLSQL.ZX_PTNR_SRVC_INTGRTN_PKG.INVOKE_THIRD_PARTY_INTERFACE.BEGIN 2 ZX_PTNR_SRVC_INTGRTN_PKG: INVOKE_THIRD_PARTY_INTERFACE()+
ZX.PLSQL.ZX_THIRD_PARTY_1242031_PKG.MAIN_ROUTER.BEGIN 2 ZX_THIRD_PARTY_1242031_PKG: MAIN_ROUTER()+
ZX.PLSQL.ZX_THIRD_PARTY_1242031_PKG.CALCULATE_TAX.BEGIN 2 ZX_THIRD_PARTY_1242031_PKG: CALCULATE_TAX()+
ZX.PLSQL.SABRIX_TAX_P2P.CALCULATE.BEGIN 2 SABRIX_TAX_P2P: CALCULATE()+$Header: sabrix_tax_p2p.sql, 84, 09/01/11 TC$
fnd.plsql.fnd_file.open_files 1 sid:88967681: open OUT_FNAME =o0001576585.tmp
fnd.plsql.fnd_file.open_files 1 sid:88967681: open OUT_FNAME =o0001576585.tmp
fnd.plsql.fnd_file.open_files 1 sid:88967681: open OUT_FNAME =o0001576585.tmp
ZX.PLSQL.ZX_SRVC_TYP_PKG.ptnr_calculate_tax_pvt 1 Incorrect Status returned by ZX_TPI_SERVICES_PKG.call_partner_service. RETURN_STATUS = E
ZX.PLSQL.ZX_SRVC_TYP_PKG.ptnr_bulk_calc_tax_pvt 1 Incorrect Status returned by Ptnr_calculate_tax_pvt. RETURN_STATUS = E
ZX.PLSQL.ZX_SRVC_TYP_PKG.ptnr_bulk_calc_tax_pvt 5 Expected Error exception occurred for Trx_id 334844
ZX.PLSQL.ZX_SRVC_TYP_PKG.delete_from_lines_det_gt.BEGIN 2 ZX_SRVC_TYP_PKG: delete_from_lines_det_gt(+)
ZX.PLSQL.ZX_SRVC_TYP_PKG.delete_from_lines_det_gt 1 Deleting data for Trx_id : 334844
ZX.PLSQL.ZX_SRVC_TYP_PKG.delete_from_lines_det_gt 1 Rows Deleted from ZX_LINES_DET_FACTORS: 1
ZX.PLSQL.ZX_SRVC_TYP_PKG.delete_from_lines_det_gt 1 Rows Deleted from ZX_DETAIL_TAX_LINES_GT: 0
ZX.PLSQL.ZX_SRVC_TYP_PKG.delete_from_lines_det_gt 1 Rows Deleted from ZX_SUMMARY_TAX_LINES_GT: 0
ZX.PLSQL.ZX_SRVC_TYP_PKG.delete_from_lines_det_gt 1 Rows Deleted from ZX_REC_NREC_DIST_GT: 0
ZX.PLSQL.ZX_SRVC_TYP_PKG.delete_from_lines_det_gt.END 2 ZX_SRVC_TYP_PKG: delete_from_lines_det_gt(-)
ZX.PLSQL.ZX_SRVC_TYP_PKG.ptnr_bulk_calc_tax_pvt.END 6 ZX_SRVC_TYP_PKG: ptnr_bulk_calc_tax_pvt(-) quit processing
ZX.PLSQL.ZX_SRVC_TYP_PKG.ptnr_bulk_calc_tax_pvt 6 RETURN_STATUS: E
ZX.PLSQL.ZX_SRVC_TYP_PKG.ptnr_bulk_calc_tax_pvt 2 RETURN_STATUS: E
ZX.PLSQL.ZX_SRVC_TYP_PKG.ptnr_bulk_calc_tax_pvt.END 2 ZX_SRVC_TYP_PKG: ptnr_bulk_calc_tax_pvt(-)
ZX.PLSQL.ZX_SRVC_TYP_PKG.calculate_tax 1 Incorrect status returned by Ptnr_bulk_calc_tax_pvt. RETURN_STATUS = E
ZX.PLSQL.ZX_GLOBAL_STRUCTURES_PKG.DELETE_TRX_LINE_DIST_TBL.BEGIN 1 ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()+
ZX.PLSQL.ZX_GLOBAL_STRUCTURES_PKG.DELETE_TRX_LINE_DIST_TBL.END 1 ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()-
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX 1 ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX 1 ZX_API_PUB: CALCULATE_TAX:Calculate_Tax_Pvt returned errors. Return Status: E
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX 5 EXCEPTION : Expected Error
"----- PL/SQL Call Stack -----
object line object
handle number name
0x71d2134b0 73 package body V_20220211_2300(Edition).APPS.FND_LOG.STR_UNCHKED_INT_WITH_CONTEXT
0x71d2134b0 216 package body V_20220211_2300(Edition).APPS.FND_LOG.STRING
0x718f72830 1425 package body V_20220211_2300(Edition).APPS.ZX_API_PUB.CALCULATE_TAX
0x6da25eb10 1008 package body V_20220211_2300(Edition).APPS.AP_ETAX_SERVICES_PKG.CALCULATE
0x6fb709418 117 package body V_20220211_2300(Edition).APPS.AP_ETAX_PKG.CALLING_ETAX
0x24804f5e8 650 package body V_20220211_2300(Edition).APPS.AP_GENERATE_DISTRIBUTIONS_PKG.GENERATE_DISTS_FOR_LINE "
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Start Time :29-06-2022 07:39:29
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 End Time :29-06-2022 07:39:30
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Total Time :0:0:1
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Number of partner calls :0
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Time taken by partner(secs) :0
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Number of records in ZX_TRX_HEADERS_GT :1
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics 6 Number of records in ZX_TRANSACTION_LINES_GT :1
AP.PLSQL.AP_ETAX_SERVICES_PKG.Calculate 1 Handle errors returned by API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages 1 Get error message from eTax API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages 1 Get error message from stack
AP.PLSQL.AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Line 1 Call to EBTax api Calculate Tax failed
wf.plsql.WF_EVENT_OJMSTEXT_QH.dequeue.queue_empty 3 No more messages in dequeue.
wf.plsql.wf_event.setNavigationParams 2 BEGIN agent(), navigationThreshold(0)
wf.plsql.wf_event.setNavigationParams 2 END navigation(FIRST_MESSAGE), threshold(0), messageCount(0), message grouping(FALSE)
..
The DB ALERT.log file shows a lot of INVALID server-side APIs related to "EMEA Add0On Localization" product, and ORA-700, ORA-800 Errors:
Beginning log switch checkpoint up to RBA [0x11.2.10], SCN: 5980004310881
2022-02-13T08:47:00.980614-08:00
Thread 1 advanced to log sequence 17 (LGWR switch), current SCN: 5980004310881
Current log# 1 seq# 17 mem# 0: /oraprd/apps_st/data01/prdredo/PRDCDB/redo01a.log
Current log# 1 seq# 17 mem# 1: /oraprd/apps_st/data02/prdredo/PRDCDB/redo01b.log
Current log# 1 seq# 17 mem# 2: /oraprd/apps_st/data03/prdredo/PRDCDB/redo01c.log
2022-02-13T08:47:01.039163-08:00
ARC3 (PID:27235): Archived Log entry 10 added for T-1.S-16 ID 0xd74e1ddb LAD:1
2022-02-13T08:47:02.698809-08:00
...
[[ 496 Pages. Last Page ]]
...
prd(3):...Current username=APPS
prd(3):...Application: e:SQLAP:frm:APXINWKB Action: SQLAP/F5_CORP_AP_USER
2022-06-29T10:51:49.722892-07:00
prd(3):WARNING: too many parse errors, count=11414 SQL hash=0xff3e6426
prd(3):PARSE ERROR: ospid=22563, error=904 for statement:
2022-06-29T10:51:49.722999-07:00
prd(3):select 'x' from dual where :1 is not null AND :2 is not null AND :3 is not null AND :4 is not null AND CLE_F125_UNIQ_INVNUM_PKG.INVOICE_VALD_CHK(:5,:6,:7,:8,:9,'WB') = 2 AND '' ='Y' AND jg_zz_shared_pkg.get_country(:10)='IT' and rownum=1
prd(3):Additional information: hd=0x311313570 phd=0x47e6b4720 flg=0x100476 cisid=173 sid=173 ciuid=173 uid=173 sqlid=1znmy73zmwt16
prd(3):...Current username=APPS
prd(3):...Application: e:SQLAP:frm:APXINWKB Action: SQLAP/F5_CORP_AP_USER
2022-06-29T10:52:06.198382-07:00
prd(3):WARNING: too many parse errors, count=11461 SQL hash=0xae75e6ed
prd(3):PARSE ERROR: ospid=29143, error=904 for statement: :
2022-06-29T10:52:06.198478-07:00
prd(3):select 'x' from dual where :1 IS NOT NULL AND :2='N' AND CLE_F274_VAT_EXEMPT_PKG.CLE_F274_CHECK_CUSTOMER(:3,:4,:5,:6) = 1 AND CLE_F274_VAT_EXEMPT_PKG.CLE_F274_LETTER_NUM(:7,:8,'IT','OM',:9)=0 AND '' ='Y' and 'US' ='IT' and rownum=1
prd(3):Additional information: hd=0x242c6f698 phd=0x5ce9d8f90 flg=0x100476 cisid=173 sid=173 ciuid=173 uid=173 sqlid=4nu3kyqr7btrd
prd(3):...Current username=APPS
prd(3):...Application: e:OKS:wf:OEOL Action: OKS/WW_REVENUE_OPS
2022-06-29T10:52:36.865441-07:00
Incremental checkpoint up to RBA [0x51d5.d7d04.0], current log tail at RBA [0x51d5.ef86e.0]
2022-06-29T10:53:16.438934-07:00
prd(3):WARNING: too many parse errors, count=6952 SQL hash=0x44f7a4a9
prd(3):PARSE ERROR: ospid=22563, error=904 for statement: :
2022-06-29T10:53:16.439020-07:00
prd(3):select 'x' from dual where :1 IN ('NEW','INSERT') AND (:2 IS NULL) AND CLEF119_FORM_PERS_PKG.AP_VAT_TEST(:3,:4,:5,:6,:7,:8) = 'Y' AND '' ='Y' and 'US' ='IT' and rownum=1
prd(3):Additional information: hd=0x4441c8ca0 phd=0x45c66d438 flg=0x100476 cisid=173 sid=173 ciuid=173 uid=173 sqlid=95mcm152gg959
prd(3):...Current username=APPS
prd(3):...Application: e:SQLAP:frm:APXINWKB Action: SQLAP/F5_CORP_AP_USER
prd(3):WARNING: too many parse errors, count=35230 SQL hash=0xb88be1d8
prd(3):PARSE ERROR: ospid=22563, error=904 for statement: :
2022-06-29T10:53:16.440844-07:00
prd(3):select 'x' from dual where :1 IN ('INSERT','NEW') AND :2 IS NULL AND clef119_form_pers_pkg.check_ap_doc_seq(:3, :4, :5, :6, :7, :8) = 'Y' AND FND_PROFILE.VALUE('CLE_IT_VAT_DATE') = 'Y' AND (:9 < :10 OR :11 > SYSDATE OR :12 IS NULL) AND '' ='Y' and 'US' ='IT' and rownum=1
prd(3):Additional information: hd=0x3922a6678 phd=0x3922a6dd0 flg=0x100476 cisid=173 sid=173 ciuid=173 uid=173 sqlid=cmwz64uw8rsfs
prd(3):...Current username=APPS
prd(3):...Application: e:SQLAP:frm:APXINWKB Action: SQLAP/F5_CORP_AP_USER
prd(3):WARNING: too many parse errors, count=35230 SQL hash=0x11f2bda2
prd(3):PARSE ERROR: ospid=22563, error=904 for statement: :
2022-06-29T10:53:16.442073-07:00
prd(3):select 'x' from dual where :1 IN ('INSERT','NEW') AND :2 IS NULL AND clef119_form_pers_pkg.check_ap_doc_seq(:3, :4, :5, :6, :7, :8) = 'Y' AND FND_PROFILE.VALUE('CLE_IT_VAT_DATE') = 'Y' AND EXISTS (select JZV.tax_calendar_name from jg_zz_vat_rep_entities JZV where JZV.LEGAL_ENTITY_ID = :9) AND :10 > :11 AND :12 = 0 AND '' ='Y' and 'US' ='IT' and rownum=1
prd(3):Additional information: hd=0x46f331488 phd=0x46f4179b0 flg=0x100476 cisid=173 sid=173 ciuid=173 uid=173 sqlid=bqp2vf88z5gd2
...
...
**********************************************************************
PGA_AGGREGATE_TARGET specified is high
Errors in file /oraprd/tech_st/db/diag/rdbms/prdcdb/prdcdb/trace/prdcdb_ora_22332.trc (incident=1542646):
ORA-00700: soft internal error, arguments: [pga physmem limit], [53687091200], [46215380172], [], [], [], [], [], [], [], [], []
Incident details in: /oraprd/tech_st/db/diag/rdbms/prdcdb/prdcdb/incident/incdir_1542646/prdcdb_ora_22332_i1542646.trc
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 16
...
...
2022-06-29T11:22:57.631837-07:00
Errors in file /oraprd/tech_st/db/diag/rdbms/prdcdb/prdcdb/trace/prdcdb_vktm_22357.trc (incident=1542687) (PDBNAME=CDB$ROOT):
ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Incident details in: /oraprd/tech_st/db/diag/rdbms/prdcdb/prdcdb/incident/incdir_1542687/prdcdb_vktm_22357_i1542687.trc
...
...
**********************************************************************
PGA_AGGREGATE_TARGET specified is high
Errors in file /oraprd/tech_st/db/diag/rdbms/prdcdb/prdcdb/trace/prdcdb_ora_31048.trc (incident=1554648):
ORA-00700: soft internal error, arguments: [pga physmem limit], [53687091200], [46215380172], [], [], [], [], [], [], [], [], []
Incident details in: /oraprd/tech_st/db/diag/rdbms/prdcdb/prdcdb/incident/incdir_1554648/prdcdb_ora_31048_i1554648.trc
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
...
...
2022-06-29T11:29:36.735844-07:00
Errors in file /oraprd/tech_st/db/diag/rdbms/prdcdb/prdcdb/trace/prdcdb_vktm_31071.trc (incident=1554689) (PDBNAME=CDB$ROOT):
ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Incident details in: /oraprd/tech_st/db/diag/rdbms/prdcdb/prdcdb/incident/incdir_1554689/prdcdb_vktm_31071_i1554689.trc
2022-06-29T11:29:36.736878-07:00
Error attempting to elevate VKTM's priority: no further priority changes will be attempted for this process
VKTM started with pid=5, OS id=31071
...
...
]]
prd(3):...
...
Current username=APPS
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |