Oracle Application Blog

How to Extract All the Asset Categories Book Wise with all Code Combinations.

gl3.segment1||’-‘||gl3.SEGMENT2||’-‘||gl3.SEGMENT3||’-‘||gl3.SEGMENT4||’-‘||gl3.SEGMENT5 DEPRN_RESERVE_ACCOUNT, deprn_method, life_in_months, (life_in_months/12) lIFE, prorate_convention_code FROM apps.fa_categories a, apps.FA_CATEGORY_BOOK_DEFAULTS b, apps.fa_category_books c, apps.gl_code_combinations gl1, apps.gl_code_combinations gl2, apps.gl_code_combinations gl3 WHERE a.category_id = b.category_id AND c.category_id = b.category_id AND c.category_id…

Read More

OPEN PO Details (Standard PO)

SELECT poh.type_lookup_code source_type,     prh.segment1 pr_number,     trunc(prh.creation_date) pr_date,     (select action_date from po_action_history         where object_type_code=’REQUISITION’ and action_code=’APPROVE’         and…

Read More

Sales Order Dispatch details (Link between Material Transactions and Invoice)

SELECT     oola.line_number,     oola.line_id,     ooha.orig_sys_document_ref ,     ooha.order_source_id,     ooha.order_number sale_order_no,     trunc(ooha.ordered_date) sale_order_date,     hp_ship.party_name customer_name,     –hl_ship.address1,  …

Read More

OnHand Quantity – With Serial number and Locator

select ohd.item, ohd.item_desc, ohd.org_code, ohd.org_name, ohd.sub_inventory, ohd.locator, msn.serial_number, ohd.item_status, ohd.uom, NVL2(msn.serial_number,1,ohd.total_onhand_qty) onhand_qty, ohd.total_onhand_qty, ohd.total_reserve_qty, ohd.total_transact_qty, mmt.transaction_date stock_in_date, mst.transaction_source_type_name stock_in_type from (SELECT msi.inventory_item_id ,     (select max(mq.create_transaction_id) from mtl_onhand_quantities mq…

Read More

An Introduction to Report Manager in Oracle EBS R12

This article describes Report Manager functionality in Oracle R12 which allows users to primarily publish and store Financial Statements/reports that are written using Financial Statement Generator (FSGs). Note that Report…

Read More

CROSS VALIDATION RULE EBS R12

What are Cross Validation Rules Cross Validation Rules are used to restrict the combination between the segments of a particular Chart of Accounts. As per our Example, we have the…

Read More

How to Update the Web Adi Template

How to Update the Web Adi Template: This document target is ADI template update required Purpose As per the business requirement user had requested to add the some fields to…

Read More

How to Define a Chart of Accounts Instance in FUSION Applications

1  Define a Chart of Accounts Instance Please find the below steps to define a Chart of Accounts Step1: Login as Application User Step2: you will be in home page as below…

Read More

How to Define a Chart of Accounts in FUSION Applications

Please find the below steps to define a Chart of Accounts Step1: Login as Application User Step2: you will be in home page as below Step3: we need to navigate…

Read More

Creating the Legal Entity and Assign legal Entity to Primary Leger in Oracle Fusion Applications

Please find the below steps for creating the Legal Entity Step1: Login as Application User Step2: you will be in home page as below Step3: we need to navigate to…

Read More