Devendrakumar Rajendran - A Blog to Oracle Financials World

Thoughts experimented by empirical and hypothesis test Good Government will work out - balancing surplus and deficits in their fiscal budget. Best of Best governance do keep capital reserves and provisions. Reserve requirement is regulated by central bank of country. Central Banks should do well and good in this aspect to boost up businesses and economy growth Thumb rule of any business -liquid cash is inversely proportional to the solvency ratio. meaning any business organization should have potential to solve its liabilities at specific point of time and its convertible cash. Its a financial saying. But i always have a strong belief in my ancestors equation -liabilities affects love and personal relations Standard Deviation In a Business- numbers keep changing Y-O-Y, Quarterly or over the time period. It can be a sale revenue or drop, it can be a swing in margins or any other asset elements. I would always suggest to business finance to use spreads, outliers, plot d...

Role of Banks in Economy Banking systems plays an important role in the economic world. Banks collect the savings of the individuals and lend them out to business people and manufacturers. Thus, Banks play a important role in creating new capital and helps country towards economic growth and development. Banks and financial institution have control over large part of money supply in circulation, and they can influence the nature and character of production in any country. Important functions of bank- Removing deficiency of capital formation In any economy, economic development is not possible unless there is an adequate degree of capital accumulation (or) formation. Deficiency of capital formation is the result of low saving made by the community. The serious capital deficiency in developing economies is reflected in small amount of capital equipment per worker and the limited knowledge, training and scientific advance. At this juncture, banks play a useful role...

-- FSG ROW SETS AND COLUMN SETS -- SELECT fst.id_flex_structure_name "COA" , decode(rw.axis_set_type,'R','ROW SET','C','COLUMN SET','##') "ROW/COLUMN" , rw.name"SET NAME" , rw.axis_set_id ,rw.creation_date FROM rg_report_axis_sets_v rw, fnd_id_flex_structures_v fst WHERE rw.structure_id = fst.id_flex_num AND substr(fst.id_flex_structure_name,1,2) in ('DC') ORDER BY 1,2,3; -- CONTENT SETS -- SELECT fst.id_flex_structure_name "COA" , cs.name , cs.content_set_id FROM rg_report_content_sets cs, fnd_id_flex_structures_v fst WHERE cs.structure_id = fst.id_flex_num AND substr(fst.id_flex_structure_name,1,2) in ('DC'); -- ROW ORDERS -- SELECT fst.id_flex_structure_name "COA" , ro.name "ROW ORDER" , ro.description "DESCRIPTION" , ro.structure_id , ro.row_order_id FROM rg_row_orders ro, fnd_id_flex_structures_v fst WHERE ro.structure_id = fst.id...

Below query is to fetch FSG report titles, names, and description along with will give a view to list of row sets and column sets associated with the report. -- FSG REPORTS -- SELECT fst.id_flex_structure_name , R.NAME , R.report_title , R.DESCRIPTION , R.column_set "COLUMN SET" , rw2.structure_id , rw2.DESCRIPTION "COL DESC" , R.row_set "ROW SET" , rw.DESCRIPTION "ROW DESC" , R.report_display_set "DISPLAY SET" , R.content_set "CONTENT SET" , R.row_order "ROW ORDER" , R.rounding_option "RND" , u.user_name , u.DESCRIPTION , R.creation_date FROM rg_reports_v R    , fnd_id_flex_structures_v fst    , fnd_user u    , rg_report_axis_sets_v rw    , rg_report_axis_sets_v rw2 WHERE r.structure_id = fst.id_flex_num AND R.row_set_id     = rw.axis_set_id AND r.column_set_id  = rw2.axis_set_id AND SUBSTR(fst.id_flex_structure_name,1,2) IN ('DC') AND R.created_by     = u.user_id OR...

How to get landed cost shipment details? Inquire below tables to get LCM shipment details inl_ship_headers_all - Get header details like item supplier name, shipment number, ship-to place inl_ship_lines_all - Get item details, quantity, cost price, and organization going to receive Can we add additional charge lines associated to an item? Yes, we can add and estimate additional charge lines, third party details, and group references What are all the additional cost factors associated to import an item in general? a. Bill of lading fees b. Container handling fees c. Marine insurance d. Onloading and offloading fees e. Port clearance charges f. Health inspection fees g. Delivery order h. Miscellaneous cost How do charges lines are classified in the LCM application: a. Shipment lines allocation b. Charge lines allocation Where do all charge lines get stored and what is a link to shipment table? Charge lines are stored in INL_CHARGE...

Landed Cost - is a overall cost incur for a buyer to bring an item to his door. Example: I'm in India going to buy a soya pass from supplier who does business in United States. Lets take quantity im going to order is 2 metric tonnes. Item cost per metric ton is - 35,000 USD Total cost of an item = 35000 * 2 = 70,000 USD Total cost of an item which is a direct cost associated for an item and there would be other charges involved in bringing items through shipments like container fees, cargo handling fees, port clearances, marine insurances and so on., Summing up all together cost of importing an item will result in landed cost. From the landed cost we can get accurate cost for an item and which helps to determine unit selling price without any losses. In landed cost, salient features are. 1. Create shipments for items your purchase 2. Associate additional expenses incur for bringing those items to your godown 3. Do estimations 4. Do billings and find actual a...

You might implement a database application as several PL/SQL packages—one package that provides the application programming interface (API) and helper packages to do the work. Ideally, only the API is accessible to clients. Also, you might create a utility package to provide services to only some other PL/SQL units in the same schema. Ideally, the utility package is accessible only to the intended PL/SQL units. Before Oracle Database 12c, PL/SQL could not prevent clients from using items exposed in helper packages. To isolate these items, you had to use relational database management system (RDBMS) security features. Some application deployment schemes made RDBMS security features hard to use. As of Oracle Database 12c, each of these statements has an optional ACCESSIBLE BY clause that lets you specify a white list of PL/SQL units that can access the PL/SQL unit that you are creating or altering