Quality Pricing Tables?

QP_LIST_HEADERS_ALL

QP_LIST_LINES

QP_PRICING_ATTRIBUTES

QP_QUALIFIERS

QP_PRICING_PHASES

Inventory Tables?

MTL_SYSTEM_ITEMS_B

MTL_SYSTEM_ITEMS_INTERFACE

MTL_INTERFACE_ERRORS

MTL_ITEM_REVISIONS

MTL_ITEM_REVISIONS_INTERFACE

MTL_CATEGORY_SETS_B

MTL_ITEM_CATEGORIES

MTL_SECONDARY_LOCATORS

MTL_RELATED_ITEMS

MTL_ONHAND_QUANTITIES

CST_ITEM_COST

MTL_PARAMETERS
MTL_ITEM_ATTRIBUTES
MTL_ITEM_TEMPLATES
MTL_ITEM_TEMPL_ATTRIBUTES
MTL_UNITS_OF_MEASURE
MTL_SERIAL_NUMBERS
MTL_LOT_NUMBERS
MTL_ITEM_CATALOG_GROUPS
MTL_MATERIAL_TRANSATIONS
MTL_MATERIAL_TRANSATIONS_TEMP
MTL_DEMAND_INTERTFACE

Where we can find the release version from backend?

SELECT release_name from FND_PRODUCT_GROUPS; ---11.5.9.

AR Tables

RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL

RA_CUSTOMER_TRX_TYPE_ALL

RA_CUSTOMER_TRX_LINE_GL_DIST_ALL

RA_CUSTOMERS

RA_TERMS

RA_CUSTOMER_TRX_LINE_SALESREPS
AR_PAYMENT_SCHEDULES

AR_CUSTOMER_PROFILES
AR_CUSTOMER_PROFILE_CLASSES
AR_CASH_RECEIPTS
AR_MISC_CASH_DISTRIBUTIONS
AR_CASH_RECEIPT_HISTORY
AR_RECEIVABLE_APPLICATIONS

HZ_PARTIES

HZ_PARTY_SITES

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_SITES_ALL

HZ_CUST_SITE_USES_ALL

HZ_LOCATIONS

HZ_CONTACT_POINTS

HZ_CUST_CONTACT_POINTS

GL Tables

GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
GL_CODE_COMBINATIONS
GL_BALANCES

GL_PERIODS

GL_JESOURCES

GL_SET_OF_BOOKS
GL_IMPORT_REFERENCES
GL_BUDGETS
GL_BUDGET_ENTITIES
GL_BUDGET_ASSIGNMENTS
GL_BUDGET_VERSIONS
GL_INTERFACE

how to get org_id for current program

fnd_profile.value('org_id');

How to find request_id for current concurrent program

select fnd_global.con_request_id from dual;

query gives all function names under a menu considering submenus's also‏

SELECT   DISTINCT

           fmep.menu_id,

           DECODE (

              fmep.function_id,

              NULL,

              DECODE (

                 fmec.function_id,

                 NULL,

                 DECODE (fmec1.function_id, NULL, 'No Func', fmec1.function_id),

                 fmec.function_id

              ),

              fmep.function_id

           )

              funcid,

           fff.user_function_name,

           fff.description

    FROM   fnd_form_functions_tl fff,

           fnd_menu_entries fmec1,

           fnd_menu_entries fmec,

           fnd_menu_entries fmep

   WHERE       fmep.menu_id = (SELECT   menu_id

                                 FROM   fnd_menus

                                WHERE   menu_name = 'ONT_SUPER_USER' --Change the menu according to your requirement

                                        AND ROWNUM = 1)

           AND fmep.sub_menu_id = fmec.menu_id(+)

           AND fmec.sub_menu_id = fmec1.menu_id(+)

           AND fff.function_id =

                 DECODE (

                    fmep.function_id,

                    NULL,

                    DECODE (

                       fmec.function_id,

                       NULL,

                       DECODE (fmec1.function_id,

                               NULL, -999,

                               fmec1.function_id),

                       fmec.function_id

                    ),

                    fmep.function_id

                 )

ORDER BY   DECODE (

              fmep.function_id,

              NULL,

              DECODE (

                 fmec.function_id,

                 NULL,

                 DECODE (fmec1.function_id,

                         NULL, 'No Func',

                         fmec1.function_id),

                 fmec.function_id

              ),

              fmep.function_id

           )

 

 

SELECT FM.MENU_NAME,

(SELECT A.MENU_NAME FROM FND_MENUS_VL A WHERE a.menu_id=FME.SUB_MENU_ID)"SUB_MENU_NAME",

(SELECT F.FUNCTION_NAME FROM FND_FORM_FUNCTIONS_VL F WHERE FME.FUNCTION_ID = F.FUNCTION_ID) "FUNCTION_NAME",

(SELECT F.USER_FUNCTION_NAME FROM FND_FORM_FUNCTIONS_VL F WHERE FME.FUNCTION_ID = F.FUNCTION_ID) "USER_FUNCTION_NAME",

--FME.FUNCTION_ID,

FME.PROMPT,

FME.GRANT_FLAG

FROM

FND_MENUS_VL FM,

FND_MENU_ENTRIES_VL FME

where FM.MENU_ID= FME.MENU_ID

AND FM.MENU_NAME ='PA_SUPERUSER_GUI_PB'

supplier tables in R12

AP_SUPPLIERS
AP_SUPPLIER_SITES_ALL
AP_SUPPLIER_CONTACTS

MultiOrg and MultiOrg Access Control in R12 (MOAC)

Prior to R12, user has to switch between responsibilities to enter transaction and for doing other activities for a particular organization. This is very time consuming to do activities in an environment like this if you have 100 operating units. To overcome this factor, oracle has introduced a new feature in R12 which allow the user to switch the organization from the same responsibility which enables the user to access different organization and its data from a single responsibility. 

To achieve the new objective, Oracle has introduced new functionality called Multi-Org Access Control (MOAC) in release 12.

MultiOrg Concept in Oracle Apps R12

Multi-Org in simple term means the implementation of multiple business units (or Organization) under a single installation of Oracle Applications. The concept of Multi-Org will manage the operations of an enterprise which has got subsidiaries across globe under a single oracle apps window, taking appropriate care of data security and data maintenance. Below are some of the features of multiple organization functionality.

·         Any number of Business Units in an Enterprise can be supported within a single installation of Oracle Application

·         User can access the data corresponding to and limited to the operating unit

·         Reporting can be managed at different organization levels like, Business Group, Ledger, Operating unit etc

·         Transactions like Procurement, Receiving, Selling, Shipping Etc. with the same Party Can be Performed through Different Organization and can be managed internally through inter company postings

how to hold sales order from backend.

oe_holds_pub.release_holds
p_release_reason_code:='hold released';

how to cancel sales order from backend.

oe_order_pub.process_order
cancelled_flag ='Y'

Explain P2P Cycle

Ø  Create a requisition

Ø  create RFQ

Ø  create a quotation from quote analysis

Ø  generate a PO

Ø  receipt of material

Ø  create Invoice in payables

Ø  Transfer to GL.

Receipt Routing

Receipt Routing is of three types

Direct: once the goods arrive at the destination, we directly move them to a specific Sub-Inv.

Standard: once the goods are at the destination, we receive it at the receiving point first and then move them to the Sub-Inv.

Inspection: once the goods are at the destination, we receive it at the receiving point and then we perform inspection and accordingly we either accept it or reject them.

Link between PO_HEADERS_ALL AND RCV_SHIPMENT_HEADERS (PO and Receipts)

RCV_SHIPMENT_LINES.PO_HEADER_ID = PO_HEADERS_ALL.PO_HEADER_ID

RCV_SHIPMENT_LINES.PO_LINE_ID = PO_LINES_ALL.PO_LINE_ID

RCV_SHIPMENT_LINES.TO_ORGANIZATION_ID = PO_LINE_LOCATION_ALL.SHIP_TO_ORGANIZATION_ID

RCV_SHIPMENT_HEADERS.SHIPMENT_HEADER_ID = RCV_SHIPMENT_LINES.SHIPMENT_HEADER_ID

RCV_SHIPMENT_HEADERS. SHIP_TO_ORGANIZATION_ID= PO_LINE_LOCATION_ALL.SHIP_TO_ORGANIZATION_ID

LInk between PO_HEADERS_ALL and PO_REQUISITION_HEADERS_ALL

PO_DISTRIBUTIONS_ALL. REQ_DISTRIBUTION_ID = PO_REQ_DISTRIBUTIONS_ALL. DISTRIBUTION_ID(+)

Link between PO_HEADERS_ALL AND AP_INVOICES_ALL tables

PO_DISTRIBUTIONS_ALL. PO_DISTRIBUTION_ID = AP_INVOICE_DISTRIBUTIONS_ALL. PO_DISTRIBUTION_ID

PO_VENDORS. VENDOR_ID = AP_INVOICES_ALL. VENDOR_ID

Link between OE_ORDER_HEADERS_ALL and RA_CUSTOMER_TRX_ALL

RA_CUSTOMER_TRX_ALL will have header information

INTERFACE_HEADER_CONTEXT                      =          ‘ORDER ENTRY’

INTERFACE_HEADER_ATTRIBUTE1                  =          order_number

RA_CUSTOMER_TRX_LINES_ALL will have invoice lines

INTERFACE_LINE_CONTEXT                             =          ‘ORDER ENTRY’

INTERFACE_LINE_ATTRIBUTE1             =          order_number

INTERFACE_LINE_ATTRIBUTE6             =          line_id from oe_order_lines_all

INTERFACE_LINE_ATTRIBUTE3             =          delivery_id from wsh_new_deliveries

RA_INTERFACE_LINES_ALL will have invoice lines

INTERFACE_LINE_CONTEXT                             =          ‘ORDER ENTRY’

INTERFACE_LINE_ATTRIBUTE1             =          order_number

INTERFACE_LINE_ATTRIBUTE3             =          delivery_id from wsh_new_deliveries