Thursday, April 9, 2015

#391 BAM 12c --> Calculated Fields. Creation /Use of, in Business Queries

Very simple example here, based on the BAM example from post #389

Here I add a calculated field to the NCTestProcess DO -











Here is the expression -






I now go into Designer mode and create a new Business Query based on this DO -

































Create a view based on the query -




















Validate the results by doing a simple test -





















Here I have an order for an iWay, whatever that is.
It's initial price is 1900. The discount of 10% will be applied.
That makes an end price of 1710.
Now VAT at 19% is applied to that, which gives us 324.9

  



















No comments: