My Oracle Support Banner

Error "Pa_acc_gen_wf_pkg.Ap_inv_generate_account Item" When Trying to Process Project Related Payable Invoice (Doc ID 2894252.1)

Last updated on JANUARY 08, 2024

Applies to:

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

Symptoms

 When trying to create the Project related Supplier invoice or  Concurrent process "Payables Open Interface Import" is executed or Project Invoice is adjusted in project expenditure inquiry getting the below error 

Error 

Receive Error:
Fatal Error:
Error Stack: -->pa_acc_gen_wf_pkg.ap_inv_generate_account
Error State: 20
Error Message: ORA-20002: 3136: Item 'PAAPINVW/#SYNCH' cannot be accessed while synchronous
process in progress.
Additional Information1:
Additional Information2:

or

fatal error: error stack -- pa_acc_gen_wf_pkg.ap_inv_generate_account error stack
Error stage: 390
Error Message: ORA-20002: 3136: Item 'PAAPINVW/' cannot be accessed while synchronous process in progress.
or
APP-SQLAP-1000 :cause : An error has occurred during Account Generation
Action: Please remove this record and check the workflow setup for account
generation occurred in APXINWKB

or

Error Stack: -->pa_acc_gen_wf_pkg.ap_inv_generate_account
Error Stage: 20
Error Message: ORA-20002: 3136: Item 'PAAPINVW/#SYNCH'
cannot be accessed while synchronous process in progress

or

v_check_line_project_info 4) Call pa_flexbuild
(PA Flexbuild 1) Check for PA installation and Project Info
(PA Flexbuild 1) Get User Id
(PA Flexbuild 1) PA_TRANSACTIONS_PUB.VALIDATE_TRANSACTION
(PA Flexbuild 1) PA_TRANSACTIONS_PUB.VALIDATE_TRANSACTION Failed :Insert Rejecti
on
PA_PROJECT_NOT_VALID
(Insert Rejections 1) Insert into AP_INTERFACE_REJECTIONS, REJECT CODE:PA FLEXBUILD FAILED

or

APP-SQLAP-97731: The system cannot generate distributions because tax calculation failed due to the following error
Cause: An error has occured during account generation
Action: Please remove this record and check the workflow setup for account generation: error encountered in pa_flexbuild

or

APP-SQLAP-10000: PA FLEXWF-DEFAULT MISSING occurred in APXINWKB
with parameters (Project_Id = <PROJECT ID>, Task_Id = <TASK ID>,
Exp_Type = SUPPLIER INVOICED MATERIAL, Exp_Org_Id = <ORG ID>,
Billable_Flag = Y)
while performing the following operation:
Calling PA ap_inv_generate_account

or

APP-SQLAP-97734: the system cannot generate distributions for line 1 because '&TOKEN2'
There can be a secondary workflow error:
ORA-20002: 3136: Item 'PAAPINVW/#SYNCH' cannot be accessed while synchronous process in progress.

 

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.