R12: WebADI for Project's Spreadsheets Inconsistently Skip or Miss Transactions
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms