Categories
Add the ability to see what the base table name and column name is behind a field on the screen
There are many times, when knowing what a value within the oracle application represents behind the scenes that would be very helpful. For example, a description on an inventory item, a ledger entry, etc. can display on the application screen but linking that value to an available pvo isn't so apparent.
Our idea is this, have an account level setting that can be enabled/disabled as needed, that when you hover over a field within the oracle application, you get the base table and column name that that field represents. Many large-scale applications have this kind of functionality such as EPIC, where it is available via a keystroke. With ERP being in cloud, that functionality is obviously going to need a different trigger mechanism, but it should be implementable.
Once we have that information, back tracking it to a pvo should be a simple matter by leveraging the lineage documentation.
The business justification for this implementation would be the time savings associated with the removal of guess work as to which PVO needs to be pulled and which do not.
Comments
-
I believe that functionality is already there actually. something related to "Externalize" on the RPD client admin tool. HTH
Marcelo
0 -
Thanks for the comment, I'm having someone take a look, for the most part, I'm just the data transport person, I don't actually know what the RPD client admin tool is.
It's just something I get asked about often.
0 -
Welcome.
If they cannot get it to work, maybe Oracle Support would help them set it up.
And if all that failed, and they would like us to collaborate on that, feel free to contact me. we can have fun : )
Cheers,
MF
0 -
Did you find a solution you can share @Dave Kekish ?
I need the same to see database table.column reference, this will help to speed up the report creation
referring to: How To Find Table / View Objects Behind Self Service / OA Framework Pages (Doc ID 605089.1)
I would like to point out for popup pages this doc seems not applicable
Best Regards
Pietro
0 -
@Pietro Papaioannu I unfortunately still do not have a solution to this, though I will look at the doc you linked.
0 -
Any updates on this? This is a very helpful and time saving feature we have in EBS.
0 -
@Dave Kekish — are you looking to have this surface in the ERP application direclty or in a report? If in ERP directly — this idea probably belongs in a Fusion specific idea area as it would need to be surfaced by the application.
Such as:
0 -
@Bret Grinslade - Oracle Analytics-Oracle
I would take this in any format I can get it. To me, it would be a highly useful feature.
Do I now need to take this idea submitted nearly a year ago and put it into a new area to have it even looked at?
0 -
I hope this idea will be considered, is very helpful have direct access to the information from the screem of user, many others ERPs have this functionality. It would save a lot of effort and time.
1
