My Oracle Support Banner

Oracle Public Sector Budgeting 'Excel Issues' Frequently Asked Questions (FAQ) (Doc ID 208843.1)

Last updated on AUGUST 10, 2018

Applies to:

Oracle Public Sector Budgeting - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Purpose

 To provide information concerning the Top Excel Issues seen for Oracle Public Sector Budgeting

Questions and Answers

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
Purpose
Questions and Answers
 What to do when receiving the error Invalid Connect Information in Excel when trying to connect to the PSB instance via Excel.
 After connecting to the database from Excel, see error:Run-time error ‘440’: SQL execution error, ORA-00942: table or view does not exist
 When trying to Import Worksheets from PSB Interface, why are there no worksheets listed?
 How to limit the list of Worksheet IDs from the Export in Excel to those moved (Move Worksheet from PSB to Interface) by that user.
 Modifying non-zero Estimate year amounts on a Worksheet imported to Excel and then exported back into Oracle Public Sector Budgeting showing Estimate year amounts different than the modified amount.
 What to do when trying to create a new account line in Excel for a position worksheet and the following error is encountered: Error: 1004, Error Text: Copy method of range class failed.
References

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