Skip to Main Content

General Development Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Automation of excel invoice entries

3819965Dec 18 2018 — edited Jan 18 2019

Hi,

We are curious to know if anyone has successfully automated the entry of excel based invoices and other docs/entries into peoplesoft? This means, instead of manually typing entries into the spreadsheet having the sheets pre-populated with functions to compute dates, etc. Then running the (I presume macro or VB Script) would load all the sheet/entries needed.  Thanks in advance for any assistance!

Comments

Gianni Ceresa

Because it is in a dashboard prompt, what behavior do you expect?
Your prompt could have various visual appearances but in the end only 2 possible values: why to write a query that will perform an operation to only return a long list of only 2 possible values?
Not even going into the logic of the query, what you are trying to do is a huge waste of resources for something that will probably not work as you expect because you have a different need than what you are trying to do.
With only 2 possible values, your prompt should not be "SQL Result" sourced but defined using "Custom Values" where you enter 'Sold' and 'Not sold' .

1 - 1

Post Details

Added on Dec 18 2018
2 comments
329 views