Devendrakumar Rajendran - A Blog to Oracle Financials World

Objective Create a list of values to display all accounts receivables transaction numbers based on each operating unit. Sequence a. Enter user defined value set name b. Enter description that is informative according to value set that you display to user c. Select list type as list of values d. Define your own format validation e. Define value validation (Type should of table type) Enter Validation table information (select t.trx_number, trunc(t.trx_date) trx_date, p.party_name, t.customer_trx_id,t.org_id from ra_customer_trx_all t, hz_parties p, hz_cust_accounts_all hca where  hca.party_id = p.party_id and hca.cust_account_id = t.bill_to_customer_id) Define table columns (name, type, and size) In where/order by field - place following piece of code to rely query table results based on operating unit list of value and order by transaction date org_id = :$FLEX$.DCF_OP_UNITS_LOV order by trx_date desc In additional column , use below piece of code to add e...

Now Oracle 12c has brought out a new feature to use function in SQL statement itself rather than implementing function as a separate database object. This helps developers to gain insight on function usage with latest technique and simplifies database object maintenance. Reduces context switching between SQL and PLSQL engine. Faster the results and efficient coding. Sample Snippet: WITH     FUNCTION get_party_name ( p_cust_account_id   IN NUMBER ) RETURN VARCHAR2 IS         l_party   hz_parties.party_name%TYPE;     BEGIN         SELECT p.party_name         INTO l_party         FROM hz_cust_accounts ca, hz_parties p          WHERE ca.party_id = p.party_id             ...

IDENTITY COLUMNS Oracle 12c Release1 introduces identity columns in the tables, if table column is marked as IDENTITY, it will automatically generate an increment numeric value at the time of record creation. Before release of Oracle 12c, developers has to create additional sequence and assign it to the column to make unique. The new feature simplifies code writing and benefits the migration of non-oracle database to oracle /* Create a table for demonstration purpose */ CREATE TABLE invoice_header  (invoice_id NUMBER GENERATED AS IDENTITY, invoice_no VARCHAR2(30), invoice_date DATE, invoice_amt NUMBER ); Identity column metadata can be queried from the data dictionary views USER_TAB_COLS and USER_TAB_IDENTITY_COLS. Note that oracle implicitly creates a sequence to generate the number values of column. The custom sequence configuration is listed under IDENTITY_OPTIONS in USER_TAB_IDENTITY_COLS view: /* Query identity column information in USER_TAB...

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