Are you finally working with only one schema ?
I have a customer who is only doing sourcing/contract activity, thus I want to propose them to load directly data in Presentation schema.
They do not even have csv file upload.
For me the time to switch the schema in this case would anyway be as much time to run an incremental load on their presentation schema.
I do not foresse issue for doing so but if you have some experience, could you share ?
We are in fact operating with one schema. My coworker has implemented this and received confirmation from Ariba that it would work but they would not support any issues seen around loading data and seeing performance issues in the application at the same time since that was the reason for having the different schemas.
I do not believe there was much to change in order to get this to work. Please feel free to reach out to him at firstname.lastname@example.org. We have csv loads and loads directly from Buyer. I will let him know you will be reaching out to him. Please let me know if you do not get any response from him.
Thanks for the update - I'll talk to the customer and contact Kevin.
We're running one production 9r1 system exactly as you describe. It works just like the previous release. We started out using the as-designed 9r1 approach, but our first schema swap was so intrusive (performance wise) to the normal transactional functionality that we switched it back.
I mentioned it to Ariba, and they seemed surprised... at some point, we'll revisit it, but it's working just fine as-is right now. It will bubble up on the priority list eventually.
How does one only enbable one Analysis schema to run ? And has anyone have both Sourcing and Analysis running off the same database server ?