R12: WebADI for Project's Spreadsheets Inconsistently Skip or Miss Transactions (Doc ID 2127356.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Expenditure items are created through WebADI.  Inconsistently, rows do not import into the the pa_transaction_interface_all table.  This happens for all of the Project's spreadsheets, but not in any other application
(specific to Projects).  The profile options are set as follows:
.
1.  Profile option 'Self Service Personal Home Page mode' can only have 'Framework Only' as a value in R12.
.
2. Please unset the profile option BNE_REDIRECT_PORTAL at ALL levels - site,user, responsibility, ...
.
3. select fnd_profile.value('APPS_SSO') from dual; ==> should return 'SSWA'
.
The bne.log file is currently showing the error 'BUDGET_NOTE - Menu item excluded because IntegratorAppId and Code does not match that of the Top-Most Menu Item or current Integrator: 275:PAXTTRXB' but in previous testcases this
was not the error.  This error does not appear to be related to our issue.  Again, the issue is inconsistent and can happen when there are only 10 records.
.

WORKAROUNDS
===========
None...users do not know that transactions weren't uploaded until they specifically look for them in the Expenditure Inquiry.  This makes the application untrustworthy.

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