Posts

Showing posts from September, 2017

Define Security rules for GL segments

How to define security rules for GL account segments Query with key flex name, title, and structure Choose independent segment = account Define security rule Name, description, and error message <<Image removed>> Define security rule elements Type - you can include or exclude range of natural accounts From and To - indicate natural account which should be included or excluded Assign security rules to responsibilities <<Image Removed>> Choose invalid payables accounts in AP invoice distribution screen.

How to create Shorthand Alias for GL accounts

Navigation: GL Setup  -> Financials -> key flexfields -> Shorthand alias Query with Application -> General ledger Title -> Accounting flexfield <<Image removed>> Enable shorthand Enter maximum value size for alias Choose prompt name for alias Enter alias short code, template, and description Template should be segment values - GL code combinations <<Image Removed>> Recompile accounting flex fields Navigate to any of transactional forms where you can enter GL account combinations, Here is example taken from supplier invoice form -> distribution tab List of account alias (short hand code) defined in GL will be appearing in list of values Profile option: Flexfields:Shorthand Entry - New entries

How to Begin with Oracle BI Cloud Service

Oracle BI Cloud Service offers features for different kinds of users. Most users will develop or consume content, such as visualizations, analyses and dashboards, to help them glean important information about their business. Before users can sign in, administrators must have configured the user population and set up any database connections that their users will require. After they sign in, users can get started with Data Visualization right away. Analyses and dashboards are based on subject area data models. To get started with these, loaders must have loaded data in to connected databases and modelers must have modeled the data. When data is modeled, users can create analyses and dashboards that allow them to glean important information about their business Typical Workflow for Data Visualization Task User Access the service All Add data Content developers Blend data Content developers