Devendrakumar Rajendran - A Blog to Oracle Financials World

create or replace function CI_Calculator ( p_principal number                                           , p_tenure number                                           , p_compound_freq number                                           , p_roi number) return number is begin  -- Formula to calculate compound interest   -- Principal * ( 1 + (rate of interest% / n ) )^nt     return round (p_principal * power( 1 + ((p_roi/100) / p_compound_freq ) , p_tenure ), 2 ); end CI_Calculator; select ci_calculator (p_principal      => 100                       ,p_tenure     ...

Creating user in oracle cloud is part of oracle identity manager. Go to financials -> Create implementation user This will navigate to oracle identify manager product -> choose administration on top right corner link -> This will take you away to create new user Fill in basic information, account settings, and account effective dates and apply save. This will create a new user account in oracle cloud You can lock user account, disable user, delete user, or reset password. Implementation user has to be assigned with data roles by using roles tab.

Defining accounting calendar 1. Enter Calendar name and description 2. Select start date period of calendar 3. Select period frequency (Monthly/Quarterly/Yearly/4-4-5 periods) based on frequency no.of periods will be allocated 4. Choose how many adjusting periods are required in a year ( once @ year end, twice @ year end, once mid year and once @ year end, ... ) 5. Choose your own period name format using separator/format/user defined prefix Create accounting calendar period details is shown below with 13 calendar periods

Common User experience Features R11 offers modernized and simplified the user experience with New look and feel to the transaction pages that provides clear layout infolets and infotiles provides at-a-glance access to information a new panel drawer for simplified access to tasks and actions The home page enables you to take a quick glance at your work-related conversations and announcements and provides you with easy access to perform your regular work functions. Use the icons on the springboard to easily access relevant work areas and dashboards. Alternatively, use the Navigator to access any additional applications. Infolets allow users to view information at a glance from different sources in an efficient, timely, and engaging way directly from the home page. If something needs your attention, get more detailed information by using either the arrow in the lower corner of the infolet, hovering over the infolet, or clicking the center of the infolet. In...

Migrating oracle financials data to cloud can be achieved through FBDi tool. FBDi is file based data import tool which is used in oracle financials cloud applications to migrate data. Steps: 1. Prepare data in CSV file according to the template given by oracle 2. Zip it and generate data file 3. Transfer data file to cloud using UCM import/export option 4. Run ESS job for loading and importing into oracle base tables

Lexical parameters can be added in data definition using &variable name This is flexible variable string where you can execute runtime conditions based on user-inputs Example 1. Append &gc_journal_filter at the end of sql statement 2. Define beforereport function in package signature FUNCTION beforereport RETURN BOOLEAN; 3. Define all the report parameters as a package variable in package signature including lexical parameters 4. Implement beforereport function by building your runtime conditions to be added to SQL statements  FUNCTION beforereport RETURN BOOLEAN IS  BEGIN          IF p_journal_source IS NULL THEN       gc_journal_filter := ' AND jh.je_source IN (''AutoCopy'',''Manual'')';     END IF;          IF p_journal_category IS NULL THEN       gc_journal_filter := 'AND jh.je_category IN (''Other'') ';     E...

Drill down from GL journal lines to Actual transaction can be done through sub ledger accounting (SLA). XLA header, line number, and event id is a key to drill down from GL to source transaction via SLA Bank account transfer (Cash management)  To get sub ledger document reference     SELECT pt.trxn_reference_number     INTO l_doc_no     FROM ce_cashflows cf         ,ce_payment_transactions pt         , xla_distribution_links dl     WHERE cf.cashflow_id         = dl.source_distribution_id_num_1     AND pt.trxn_reference_number = cf.trxn_reference_number     AND dl.ae_header_id          = p_xla_header_id     AND dl.ae_line_num           = p_xla_line_num     AND dl.event_id              = p_event_id; To get sub ledger document details ...