Devendrakumar Rajendran - A Blog to Oracle Financials World

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.

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

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 ...

Query to identify production batch variances (Actual VS WIP Planned) Below query will identify variances for ingredients/by-products/products Batch variance details will be electronically sent to distribution list members Set periodic alert - frequency- everyday and set timings Under actions -> set action type is message Link distribution list members and set message text In action sets -> set all the actions you have created Query select itemcode        ,plan_qty        ,wip_plan_qty        ,actual_qty        ,ROUND(diff, 2) diff        ,ptype        ,batchno        ,(select user_name from fnd_user where user_id = qry.created_by ) created_by_name        ,(select user_name from fnd_user where user_id = qry.last_updated_by ) updated_by_name        ,batchstatus     ...

Raw materials will be used in production batches to produce FG/End-Products Inorder to consume items first we have to assign it to inventory organization. It is a basic step. Assign items to inventory organization        ego_item_pub.assign_item_to_org(                    p_api_version          => 1.0                 ,  p_init_msg_list        => fnd_api.g_false                 ,  p_commit               => fnd_api.g_false                 ,  p_inventory_item_id    => 100                 ,  p_organization_code    =>  l_array(i)                 ,  x_return_status  ...

Basic business need Business organization offers price discount during festival days to attract customers to purchase goods in large volume This will promote business team to quickly clear their stocks and make cash revenue Discounts can be set up for specific dates say. Ramadan kareem offer - 10-Jun-2017 till 20-Jun-2017 - Discount of 10% on milk products Eid al adha offer - 31-Aug-2017 till 2-sep-2017 - Discount of 5% on all products Modifers Type - Discount Number - Unique code Name - Eid Al Adha promotion System is allowed to define period dates where discount offer is valid upto Discount level is at order level or line level Automatic apply - adjusted automatically at sale order header level override - set to yes or no - depends on business use-case Modifier type - discount Application method - discount percentage Value - numeric value say 5 % or 10% pricing phase - set the precedences - line level adjustments/header level/BOOK event Create sale or...

Inquire with transaction type for class invoice Check - Allow freight checkbox This will enable freight charges to enter at AR transaction level Auto accounting Set freight natural account and department as constant