Devendrakumar Rajendran - A Blog to Oracle Financials World

Define Tax regime code and name Add parties. Party can be legal entity or operating units Once you select parties, party type, address and country details will be auto populated. party configuration is of common or party specific you can select service subscriptions if service provider is vertex or third party company Define Tax Each tax you define in the system will be under tax regime Define Tax rates Rate type can be based on quantity or percentage

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