My Oracle Support Banner

R12: PA: AP: Payables Workbench Projects Related Invoice Getting Error When Navigating To Distribution Lines (Doc ID 2075936.1)

Last updated on JUNE 07, 2018

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

A user created a Payables Workbench Project Invoice receives error:

ERROR
-----------------------
sqlap-97731: The system cannot generate distributions
because tax calculation failed due to the following error:
PA_WF_ACC_LOOKUP_NODATA_FAIL: Error encountered in
pa_flexbuild.



An FND Log output will display the following type information:

wf.plsql.wf_engine_util.function_call.actfunc_callout 1 End executing PLSQL procedure - PA_ACC_GEN_WF_PKG.PA_SEG_LOOKUP_SET_VALUE [End time -1475115179]
wf.plsql.wf_engine_util.function_call.actfunc_callout 1 Start executing PLSQL procedure - FND_FLEX_WORKFLOW_APIS.ABORT_GENERATION [Start time -1475115177]
wf.plsql.wf_engine_util.function_call.actfunc_callout 1 End executing PLSQL procedure - FND_FLEX_WORKFLOW_APIS.ABORT_GENERATION [End time -1475115177]
AP.PLSQL.AP_ETAX_UTILITY_PKG.GET_CCID_FROM_PROJECTS 1 PA
AP.PLSQL.AP_ETAX_SERVICES_PKG.Populate_Lines_GT 1 PA
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

 
A Trace(raw) with Binds will display the following type information:

Bind#0
oacdty=01 mxl=128(25) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=31 siz=128 off=0
kxsbbbfp=1124050c8 bln=128 avl=25 flg=09
value="WF_ACC_LOOKUP_NODATA_FAIL"
Bind#1
oacdty=01 mxl=32(32) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=31 siz=32 off=0
kxsbbbfp=1112901b8 bln=32 avl=08 flg=09
value="PAAPINVW"
Bind#2
oacdty=01 mxl=128(32) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=31 siz=128 off=0
kxsbbbfp=111290208 bln=128 avl=04 flg=09
value="1065"
Bind#3
oacdty=01 mxl=32(13) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=31 siz=32 off=0
kxsbbbfp=70000009d48f280 bln=32 avl=13 flg=09
value="ERROR_MESSAGE"

...

Bind#2
oacdty=01 mxl=2000(256) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=2024 off=0
kxsbbbfp=1124533d8 bln=2000 avl=62 flg=05
value="AP.PLSQL.AP_GENERATE_DISTRIBUTIONS_PKG.Generate_Dists_for_Line"
Bind#3
oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=00 csi=00 siz=0 off=2000
kxsbbbfp=112453ba8 bln=22 avl=02 flg=01
value=1
Bind#4
oacdty=01 mxl=2000(38) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=01 csi=31 siz=2312 off=0
kxsbbbfp=112452a90 bln=2000 avl=38 flg=05
value="Call to EBTax api Calculate Tax failed"

 

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.