P2P & O2C Technical Flow

                                 P2P Backend FLOW

Indent

SELECT * FROM PO_REQUISITION_HEADERS_ALL WHERE SEGMENT1=5671

SELECT * FROM PO_REQUISITION_LINES_ALL

WHERE REQUISITION_HEADER_ID = (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_HEADERS_ALL WHERE SEGMENT1='5671')

PO Related

SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1=4500

SELECT * FROM PO_LINES_ALL

WHERE PO_HEADER_ID= (SELECT PO_HEADER_ID FROM PO_HEADERS_ALL WHERE SEGMENT1=4500)

SELECT * FROM PO_LINE_LOCATIONS_ALL

WHERE PO_HEADER_ID=(SELECT PO_HEADER_ID FROM PO_HEADERS_ALL WHERE SEGMENT1=4500)

SELECT * FROM PO_DISTRIBUTIONS_ALL

WHERE PO_HEADER_ID=(SELECT PO_HEADER_ID FROM PO_HEADERS_ALL WHERE SEGMENT1=4500).

Receipt Information

 SELECT * FROM RCV_SHIPMENT_HEADERS    WHERE RECEIPT_NUM =9621

SELECT * FROM RCV_SHIPMENT_LINES WHERE SHIPMENT_HEADER_ID IN (SELECT SHIPMENT_HEADER_ID FROM RCV_SHIPMENT_HEADERS  

        WHERE RECEIPT_NUM =9621 AND SHIPMENT_HEADER_ID=69428)

Select * from RCV_TRANSACTIONS

          Where PO_HEADER_ID IN (SELECT PO_HEADER_ID   FROM PO_HEADERS_ALL

                                   WHERE SEGMENT1=4500) 

SELECT * FROM mtl_material_transactions

WHERE RCV_TRANSACTION_ID IN (select TRANSACTION_ID

    From RCV_TRANSACTIONS  Where PO_HEADER_ID IN (SELECT PO_HEADER_ID FROM

                       PO_HEADERS_ALL WHERE SEGMENT1=4500))

        

            AP Invoice related

SELECT * FROM AP_INVOICES_ALL  WHERE INVOICE_NUM=4579

SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL WHERE INVOICE_ID IN (SELECT INVOICE_ID

                       FROM AP_INVOICES_ALL WHERE INVOICE_NUM='4579')

Payment Related

 SELECT * FROM AP_PAYMENT_SCHEDULES_ALL WHERE INVOICE_ID IN (SELECT INVOICE_ID FROM AP_INVOICES_ALL WHERE INVOICE_NUM='4579')

SELECT * FROM AP_INVOICE_PAYMENTS_ALL WHERE INVOICE_ID IN (SELECT INVOICE_ID FROM AP_INVOICES_ALL

        WHERE INVOICE_NUM='4579')

SELECT * FROM AP_PAYMENT_DISTRIBUTIONS_ALL WHERE INVOICE_PAYMENT_ID IN (SELECT INVOICE_PAYMENT_ID  FROM AP_INVOICE_PAYMENTS_ALL WHERE INVOICE_ID IN (SELECT INVOICE_ID FROM AP_INVOICES_ALL  WHERE INVOICE_NUM='4579'))

SELECT * FROM AP_CHECKS_ALL   WHERE CHECK_ID=28698  

à Corresponding vendor_id and bank_account is related to that particular vendor

Bank Reconciliation in Cash Management

SELECT STATEMENT_HEADER_ID FROM CE_STATEMENT_HEADERS_ALL

WHERE STATEMENT_HEADER_ID =75826

SELECT * FROM CE_STATEMENT_LINES WHERE STATEMENT_HEADER_ID IN (SELECT STATEMENT_HEADER_ID FROM CE_STATEMENT_HEADERS_ALL

WHERE STATEMENT_HEADER_ID =75826)

GL Related

Ø  After these Invoice’s are transferred to GL by running

  Payables Transfer to General Ledger  PROGRAM

The tables affected are

    GL_JE_BATCHES

    GL_JE_HEADERS

    GL_JE_LINES    

                                           O2C FLOW

Order Related

SELECT * FROM oe_order_headers_all WHERE order_number = 57803

SELECT * FROM oe_order_lines_all WHERE header_id = (SELECT header_id FROM oe_order_headers_all WHERE order_number = 57803);

Once order is booked and pick release is next step

 SELECT * FROM wsh_delivery_details WHERE source_header_id = (SELECT header_id FROM oe_order_headers_all WHERE order_number = 57803)

Once order is pick confirm

SELECT delivery_id FROM wsh_delivery_assignments WHERE delivery_detail_id =

(SELECT delivery_detail_id FROM wsh_delivery_details WHERE source_header_id = (SELECT header_id FROM oe_order_headers_all WHERE order_number = 57803))

SELECT * FROM wsh_new_deliveries WHERE delivery_id = 211904

SELECT * FROM mtl_material_transactions WHERE transaction_id IN (11262482, 11262483)

    Once Move order is transacted

SELECT header_id FROM mtl_txn_request_headers WHERE request_number = '187252'

       SELECT * FROM mtl_txn_request_lines WHERE header_id = 209289

Once order is ship confirmed

Interface trip stop program automatically launches and order line status gets interfaced, and delivery id status is closed.

SELECT * FROM wsh_delivery_legs WHERE delivery_id = 211904

SELECT * FROM wsh_trip_stops WHERE stop_id IN (216963, 216964)

SELECT * FROM wsh_trips WHERE trip_id = 179789

Inventory Interface- SRS updates inventory with the ship confirmation information.

Inventory balances are decremented and reservations relieved. This program always spawns the Order Management Interface - SRS program. It is very important in the process flow that the Inventory Interface complete before the Order Management Interface to ensure the integrity of the reservation information.

Inventory Interface picks records from MTI (MTL_TRANSACTIONS_INTERFACE) and inserts them into MMTT (MTL_MATERIAL_TRANSACTIONS_TEMP). The Inventory Manager then processes rows and inserts them in to MTL_MATERIAL_TRANSACTIONS.

Order Management  Interface runs to update Order Management with the ship confirmation information. Order line shipped quantities will be updated.

At the end of ship confirm, invoice lines are created in Ra_interface_lines_all table.

Once Ship Confirm is done, Workflow background process runs, and inserts data in below table

Auto Invoice Master program runs to generate entry in AR tables

SELECT * FROM ra_interface_lines_all where interface_line_attribute1 = <order_number>

AR Invoices Related Tables

SELECT * FROM Ra_customer_trx_lines_all where interface_line_attribute1 = <order_number>

SELECT * FROM Ra_customer_trx_all where trx_header_id = <trx_header_id> (trx_header_id fetched from Ra_customer_trx_lines_all)

AR Receipt Table

Select * from ar_cash_receipts_all

Select * from ar_receivable_applications

Transfer TO GL

Run General Ledger Transfer Program, to transfer Accounting info in to GL.

Select * from GL_INTERFACE

Journal Import

Run Journal Import program, to import GL interface data into GL Tables.

GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES :- While importing GL , data in these tables will be in UN Posted Form.

Post IN GL

Once GL Batch is posted, Data will be finally available in

Select * from GL_BALANCES

Order to Cash Cycle - Tables get Affected @ Each Step

1) Order Entry
------------------------------------
oe_order_headers_all.flow_status_code = 'ENTERED'
oe_order_headers_all.booked_flag = 'N'

oe_order_lines_all.flow_status_code = 'ENTERED'
oe_order_lines_all.booked_flag = 'N'
oe_order_lines_all.open_flag = 'Y'

2) Order Booking
------------------------------------
oe_order_headers_all.flow_status_code = 'BOOKED'
oe_order_headers_all.booked_flag = 'Y'

oe_order_lines_all.flow_status_code = 'AWAITING SHIPPING'
oe_order_lines_all.booked_flag = 'Y'

wsh_delivery_details.released_status = 'R' (ready to release)

wsh_delivery_assignments.delivery_id = BLANK

3) Reservation
------------------------------------
mtl_demand

mtl_reservations

4) Pick Release
------------------------------------
wsh_new_deliveries.status_code = 'OP'

wsh_delivery_assignments.delivery_id gets assigned

wsh_delivery_details.released_status = 'S' (submitted for release)

mtl_txn_request_headers

mtl_txn_request_lines

mtl_material_transactions_temp

5) Pick Confirm
------------------------------------
oe_order_lines_all.flow_status_code = 'PICKED'

mtl_material_transactions

wsh_delivery_details.released_status = 'Y' (Released)

mtl_onhand_quantities

6) Ship Confirm
------------------------------------
Data will be removed from wsh_new_deliveries

oe_order_lines_all.flow_status_code = 'SHIPPED'

wsh_delivery_details.released_status = 'C' (Shipped)

wsh_serial_numbers

data will be deleted from mtl_demand and mtl_reservations

item qty gets deducted from mtl_onhand_quantities

7) Enter Invoice
------------------------------------
After shipping the order, workflow backgroud engine picks up records and post it to

ra_interface_lines_all

Auto invoice program picks up records from interface table and insert them into

ra_customer_trx_all (trx_number is invoice number)

ra_customer_trx_lines_all (line_attribute_1 = Order number and line_attribute_6 = Order line id)

8) Complete Line
------------------------------------
oe_order_lines_all.flow_status_code = 'SHIPPED'
oe_order_lines_all.open_flag = 'N'

9) Close Order
------------------------------------
oe_order_headers_all.flow_status_code = 'CLOSED'

oe_order_lines_all.flow_status_code = 'CLOSED'
oe_order_lines_all.open_flag = 'N'

10) Create Receipt
------------------------------------
AR_CASH_RECEIPTS_ALL

11) Transfer to General Ledger
------------------------------------
GL_INTERFACE

12) Journal Import
------------------------------------
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES

13) Posting
------------------------------------
GL_BALANCES

Whenever Production team raises request for Move order against any batch in OPM, Automated mail should go to Stores Team.

Oracle Alert : Move order Created from Production Batch

I Got one Requirement from Production and Store Team, as below
So I created one Event Based Alert on Move Order Headers Table.


Query is:



SELECT  distinct ORG.ORGANIZATION_NAME,
         TRH.REQUEST_NUMBER,
         GBH.BATCH_NO,
         TRL.TO_SUBINVENTORY_CODE,
         TRL.STATUS_DATE,
         (SELECT (ppf.first_name || ' ' || ppf.last_name)
            FROM fnd_user fnd, per_all_people_f ppf
           WHERE fnd.user_id = trh.created_by
             AND ppf.person_id = fnd.employee_id) creater,
          (SELECT NVL (ppf.email_address, fnd.email_address)
            FROM fnd_user fnd, per_all_people_f ppf
           WHERE fnd.user_id = trh.created_by
             AND ppf.person_id = fnd.employee_id) Email
      INTO &ENTITY,
           &MOVE_ORDER,
           &BATCH_NO,
           &SUB_INV,
           &MV_DATE,
           &CREATER,
           &EMAIL_ID      
    FROM MTL_TXN_REQUEST_HEADERS TRH,
         MTL_TXN_REQUEST_LINES TRL,
         GME_BATCH_HEADER GBH,
         ORG_ORGANIZATION_DEFINITIONS ORG,
         MTL_PARAMETERS MP,
         MFG_LOOKUPS ML1,
         MTL_SYSTEM_ITEMS MSI,
         MFG_LOOKUPS ML2
   WHERE TRH.HEADER_ID = TRL.HEADER_ID
     AND TRH.ORGANIZATION_ID = TRL.ORGANIZATION_ID
     AND TRH.ORGANIZATION_ID = ORG.ORGANIZATION_ID
     AND TRL.TXN_SOURCE_ID=GBH.BATCH_ID
     AND GBH.ORGANIZATION_ID = TRH.ORGANIZATION_ID
     AND GBH.ORGANIZATION_ID = ORG.ORGANIZATION_ID
     AND TRH.ORGANIZATION_ID = MP.ORGANIZATION_ID
     AND TRH.MOVE_ORDER_TYPE = ML1.LOOKUP_CODE
     AND ML1.LOOKUP_TYPE = 'MOVE_ORDER_TYPE'
     AND TRL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
     AND TRL.ORGANIZATION_ID = MSI.ORGANIZATION_ID
     AND TRL.LINE_STATUS = ML2.LOOKUP_CODE
     AND ML2.LOOKUP_TYPE = 'MTL_TXN_REQUEST_STATUS'
     AND TRH.MOVE_ORDER_TYPE=5
     AND TRL.LINE_STATUS IN (3,7)
     AND ORG.OPERATING_UNIT=82--------------Operating unit ID
    AND TRH.rowid=:rowid
     ORDER BY 3,4





Message Body :

Stores Team : Below Move Order Generated from Plant Against Batch No :&BATCH_NO From &SUB_INV


Message Text:

From :Support Team

Below Move Order Generated from Plant

MOVE ORDER NO       : &MOVE_ORDER
ORGANIZATION NAME   : &ENTITY

Thank You
(ERP Support Team)



Screen Shots Captured As:

Provide Email Id's in Action Details and The Message Subject as per the need.

Sunday, September 13, 2015

Run Concurrent Program from Form: Launch SRS Built In

Form Personalization to run Concurrent Program from Form 

Built-in : Launch SRS Program.

Example :

Our Requirement is to Run Production Batch Sample Label from Production Batch Form.

We could completed this requirement through Form Personalization in below steps.

A)-Define 1 Menu : Special Menu for the Report, that shall show in tools Menu bar.

B)-Attach Concurrent Program menu with this Special Menu (defined in the above step).

C)- Store batch id ( For parameter to run your concurrent) in one Global variable.

D)- In Concurrent Definition window , Assign Global variable value to the Parameter for Batch id.

Here are the screen shots.

Requirement is like Below.

Goto Help --> Diagnostics --> Custom Code --> Personalize.

Add 1 New Sequence for You personalization, and Select Event as When-New-Form-Instance.

Goto Actions, and Choose any 1 special Menu.

Once menu is define, we need to attach Concurrent program to this menu.

Create new Sequence, for attaching The concurrent program with special menu defined in above step.

Goto Actions, here we need to define 2 Actions

1)- Global Variable to store Batch ID for Parameter.

2)- Attach Concurrent program to the Special Menu.

Global Variable name should be Logical and unique, as this needs to be pass to your concurrent program.

Save your work, Till here personalization is done for Concurrent program is attached and run, now Concurrent program will be run , but we have to assign Parameters manually, it will not pick any parameter automatically.

Step-3, To pass parameters from Batch form automatically.

GO TOà System adminà applicationà Concurrentà define

Now we have to attach Global variable from above steps to Concurrent Program.

Go to Parameters, and then pass global variable from the earlier form i.e, Batch Form.

Select Batch id parameter.

Its Default Type Should be SQL Statement.

Then Pass the 

“select :GLOBAL.XX_BATCH_ID from dual”

Now try to run report from Batch form,

It will automatically pass your current (Batch opened at form) to the report.

Tuesday, July 28, 2015

Daily Production Query with LOT

SELECT ood.organization_code, ood.organization_id, ood.organization_name,
       ood.operating_unit, gbh.batch_no,
     /*   DECODE (gmg.group_id,1002, 'PLANT_1'
                           ,1003, 'PLANT_2'
                           ,1004, 'PLANT_3'
                           ,1001 ,'WIP_CUBE'
                           ,1000, 'OSP' ) Plant, */
       TRUNC (gbh.actual_cmplt_date) date_of_production,
       TRUNC (gbh.actual_start_date) actual_start_date,
       msik.concatenated_segments product,
       msik.description product_description, gmd.actual_qty qty_produced,
       gmd.plan_qty, gmd.dtl_um uom,
       (Select gms.SOURCE_COMMENT
        from GMD_SAMPLES gms
        where gms.LOT_NUMBER = mtln.lot_number
        and gms.organization_id = msik.organization_id
        and gms.INVENTORY_ITEM_ID = msik.INVENTORY_ITEM_ID
        and rownum = 1) QC_Comments,
       ROUND (  gmd.actual_qty
              * 100
              / (SELECT DECODE (SUM (gmd1.actual_qty),
                                NULL, 1,
                                0, 1,
                                SUM (gmd1.actual_qty)
                               )
                   FROM gme_material_details gmd1
                  WHERE gmd1.line_type = '-1' AND gmd1.batch_id = gbh.batch_id),
              2
             ) yield_percent,
       flv.meaning batch_status,
                                --mmt.transaction_id,
                                --mmt.source_code,
                                mtln.lot_number,
          av.STATUS_CODE quality_status,
     /*  (SELECT flv_spec_disp.meaning spec_disposition
          FROM gmd_samples gs,
               gmd_sampling_events gse,
               gmd_event_spec_disp gesd,
               fnd_lookup_values flv_spec_disp
         WHERE gs.sampling_event_id = gse.sampling_event_id
           AND gse.sampling_event_id = gesd.sampling_event_id
           AND gesd.disposition = flv_spec_disp.lookup_code
           AND flv_spec_disp.lookup_type = 'GMD_QC_SAMPLE_DISP'
           AND gs.lot_number = mtln.lot_number
           AND gs.inventory_item_id = gmd.inventory_item_id
           AND gs.organization_id = gmd.organization_id
           AND ROWNUM = 1) quality_status,*/
       mmt.transaction_quantity, mmt.transaction_uom, mmt.transaction_date,
       gbh.attribute1 dcs_batch_number, gbh.attribute2 dcs_batch_date
  FROM gme_batch_header gbh,
       gme_material_details gmd,
       mtl_system_items_kfv msik,
       MTL_LOT_NUMBERS_ALL_V av,
       org_organization_definitions ood,
   --    gme_batch_groups_association gmg    ,
       fnd_lookup_values flv,
       (SELECT *
          FROM mtl_material_transactions
         WHERE transaction_type_id IN (44, 17)) mmt,
       mtl_transaction_lot_numbers mtln
 WHERE gbh.batch_id = gmd.batch_id
   --AND gmg.batch_id=gbh.batch_id
   AND gmd.line_type = 1
   AND gmd.cost_alloc =
                  (SELECT MAX (gmd1.cost_alloc)
                     FROM gme_material_details gmd1
                    WHERE gmd1.batch_id = gmd.batch_id AND gmd1.line_type = 1)
   AND gmd.inventory_item_id = msik.inventory_item_id
   AND gmd.organization_id = msik.organization_id
   AND gmd.organization_id = ood.organization_id
   AND gbh.batch_status = flv.lookup_code
   and av.inventory_item_id=mtln.inventory_item_id
   and av.organization_id = mtln.organization_id
   and av.lot_number = mtln.lot_number
   AND flv.lookup_type = 'GME_BATCH_STATUS'
   AND flv.LANGUAGE (+) =  'PTB'
   AND gmd.batch_id = mmt.transaction_source_id(+)
   AND gmd.inventory_item_id = mmt.inventory_item_id(+)
   --AND mmt.source_code(+) = 'OPM'
   AND mmt.transaction_id = mtln.transaction_id(+)
    --  AND ood.organization_id in (select ood.organization_id from
--AND gbh.batch_no = '3040004832';
   AND ood.operating_unit = :p_org_id
  /*  and DECODE (gmg.group_id,1002, 'PLANT_1'
                           ,1003, 'PLANT_2'
                           ,1004, 'PLANT_3'
                           ,1001 ,'WIP_CUBE'
                           ,1000, 'OSP' ) = nvl(:p_plant,  DECODE (gmg.group_id,1002, 'PLANT_1'
                                               ,1003, 'PLANT_2'
                                               ,1004, 'PLANT_3'
                                               ,1001 ,'WIP_CUBE'
                                               ,1000, 'OSP' )) */
   AND gbh.batch_no BETWEEN NVL (:p_from_batch, gbh.batch_no)
                        AND NVL (:p_to_batch, gbh.batch_no)
   AND flv.meaning = NVL (:p_status, flv.meaning)
   AND msik.concatenated_segments between NVL(:P_FROM_ITEM,msik.concatenated_segments)
                                                                 AND NVL(:P_TO_ITEM,msik.concatenated_segments)
   AND TRUNC (mmt.transaction_date) BETWEEN NVL
                                                (TRUNC (TO_DATE (:p_from_date,
                                                                 'DD-MON-RRRR'
                                                                )
                                                       ),
                                                 TRUNC (mmt.transaction_date)
                                                )
                                         AND NVL
                                               (TRUNC (TO_DATE (:p_to_date,
                                                                'DD-MON-RRRR'
                                                               )
                                                      ),
                                                TRUNC (mmt.transaction_date)
                                               )
ORDER BY gbh.batch_no

Friday, July 24, 2015

SQL Query for Oracle OPM Receipe and Formula Dump

select gmd.RECIPE_NO Receipe_code,RECIPE_DESCRIPTION Receipe_Name ,gmd.RECIPE_VERSION,
(select distinct description from mtl_system_items mtl1,FM_MATL_DTL fd1
where fd1.line_type=1
and fd1.formula_id=fd.formula_id
and fd1.inventory_item_id = mtl1.inventory_item_id
and fd1.organization_id= mtl1.organization_id) product,
fm.formula_no,fm.FORMULA_DESC1,fm.FORMULA_VERS,
decode (gmd.RECIPE_STATUS,'900', 'Frozen','700','Approved for General Use') Rec_Status,
b.segment1||'-'||b.segment2 Item_code,
b.description item_desc,
fd.line_no,
fd.qty
from FM_FORM_MST fm,
FM_MATL_DTL fd,
mtl_system_items b,
GMD_RECIPE_VALIDITY_RULES GV,
gmd_recipes gmd
where  fd.formula_id=fm.formula_id
and fd.organization_id=fm.OWNER_ORGANIZATION_ID
and fm.formula_id =gmd.formula_id
and fm.owner_organization_id=gmd.owner_organization_id
AND GV.RECIPE_ID=GMd.RECIPE_ID
and b.inventory_item_id=fd.inventory_item_id
and b.organization_id=fm.OWNER_ORGANIZATION_ID
and fm.OWNER_ORGANIZATION_ID in (XXXX)
and fd.line_type in (-1,2)
--and fm.FORMULA_STATUS=700
and gmd.RECIPE_STATUS in (700)
--and gmd.RECIPE_NO=''XXXX
order by 1

Oracle EBS Practical Approaches

Run Concurrent Program from Form: Launch SRS Built In

Form Personalization to run Concurrent Program from Form 

Built-in : Launch SRS Program.

Example :

Our Requirement is to Run Production Batch Sample Label from Production Batch Form.

We could completed this requirement through Form Personalization in below steps.

A)-Define 1 Menu : Special Menu for the Report, that shall show in tools Menu bar.

B)-Attach Concurrent Program menu with this Special Menu (defined in the above step).

C)- Store batch id ( For parameter to run your concurrent) in one Global variable.

D)- In Concurrent Definition window , Assign Global variable value to the Parameter for Batch id.

Here are the screen shots.

Requirement is like Below.

Goto Help --> Diagnostics --> Custom Code --> Personalize.

Add 1 New Sequence for You personalization, and Select Event as When-New-Form-Instance.

Goto Actions, and Choose any 1 special Menu.

Once menu is define, we need to attach Concurrent program to this menu.

Create new Sequence, for attaching The concurrent program with special menu defined in above step.

Goto Actions, here we need to define 2 Actions

1)- Global Variable to store Batch ID for Parameter.

2)- Attach Concurrent program to the Special Menu.

Global Variable name should be Logical and unique, as this needs to be pass to your concurrent program.

Save your work, Till here personalization is done for Concurrent program is attached and run, now Concurrent program will be run , but we have to assign Parameters manually, it will not pick any parameter automatically.

Step-3, To pass parameters from Batch form automatically.

GO TOà System adminà applicationà Concurrentà define

Now we have to attach Global variable from above steps to Concurrent Program.

Go to Parameters, and then pass global variable from the earlier form i.e, Batch Form.

Select Batch id parameter.

Its Default Type Should be SQL Statement.

Then Pass the 

“select :GLOBAL.XX_BATCH_ID from dual”

Now try to run report from Batch form,

It will automatically pass your current (Batch opened at form) to the report.

Friday, July 24, 2015

ZOOM Functionality and Global variable in Form Personalization

1)- Global Variable in forms Personalization.

  A)- These variables are accessible through out the application until the current active session becomes inactive.

B)- Data type for Global variables are always CHAR, hence if global variable needs to initialize or assign for any numeric value , use TO_CHAR

C)- Oracle 10g Can store as max as 4000 Bytes in Global variable, as compared wit just 255 bytes in 6i.


Syntax to Access of global variable.

  :GLOBAL.VARIABLE_NAME


2)- ZOOM Functionality.

   This functionality gives feature to pass the control from one form to Another.

So For any event we can set zoom functionality , for example on button click , control passes from the current form to another form, that is defined in personlization.



ZOOM Functionality is same as BUILT-IN Launch SRS Form with just one difference is that
In Launch SRS Form built-in we have to pass parameters manually, but in zoom functionality parameters can be passed automatically form the values available on current form.

Oracle Process Manufacturing (OPM) Product Development Status Codes

This appendix outlines how status codes change when workflow is and is not running.

Workflow Running and Approval Required for the Current Data

A status of New changes to a status of:

• Pending Approval for Laboratory Use when the Requester selects Approve for Laboratory Use.
  
• Pending Approval for General Use when the Requester selects Approve for General Use.
  
• Obsolete or Archived when the Requester selects Obsolete or Archived.

A status of Pending Approval for Laboratory Use changes to a status of:

• Approved for Laboratory Use when the Approver approves the request.
  
• Revise for Laboratory Use when the Approver rejects the request.

A status of Revise for Laboratory Use changes to a status of:

• Pending Approval for Laboratory Use when the Requester selects Approve for Laboratory Use.

A status of Approved for Laboratory Use changes to a status of:

• Pending Approval for General Use when the Requester selects Approve for General Use.
  
• On hold when the Requester selects On Hold.
  
• Obsolete or Archived when the Requester selects Obsolete or Archived.

A status of Pending Approval for General Use changes to a status of:

• Approved for General Use when the Approver approves the request.
  
• Revise for General Use when the Approver rejects the request.

A status of Revise for General Use changes to a status of:

• Pending Approval for General Use when the Requester selects Approve for General Use.

A status of Approved for General Use changes to a status of:

• On hold when the Requester selects On Hold.
  
• Frozen when the Requester selects Frozen.
  
• Obsolete or Archived when the Requester selects Obsolete or Archived.

A status of On Hold changes to a status of:

• Pending Approval for Laboratory Use when the Requester selects Approve for Laboratory Use.
  
• Revise for Laboratory Use when the Requester selects Revise for Laboratory Use.
  
• Revise for General Use when the Requester selects Revise for General Use.
  
• Pending Approval for General Use when the Requester selects Approve for General Use.
  
• Obsolete or Archived when the Requester selects Obsolete or Archived.

A status of Frozen changes to a status of:

• On hold when the Requester selects On Hold.
  
• Obsolete or Archived when the Requester selects Obsolete or Archived.

A status of Obsolete or Archived changes to a status of:

• Revise for Laboratory Use when the Requester selects Revise for Laboratory Use.
  
• Revise for General Use when the Requester selects Revise for General Use.

Workflow Not Running

A status of New changes to a status of:

• Approve for Laboratory Use when the Requester selects Approve for Laboratory Use.
  
• Approve for General Use when the Requester selects Approve for General Use.
  
• Obsolete or Archived when the Requester selects Obsolete or Archived.

A status of Approved for Laboratory Use changes to a status of:

• Approve for General Use when the Requester selects Approve for General Use.
  
• On hold when the Requester selects On Hold.
  
• Obsolete or Archived when the Requester selects Obsolete or Archived.

A status of Approved for General Use changes to a status of:

• On hold when the Requester selects On Hold.
  
• Frozen when the Requester selects Frozen.
  
• Obsolete or Archived when the Requester selects Obsolete or Archived.

A status of On Hold changes to a status of:

• Approve for Laboratory Use when the Requester selects Approve for Laboratory Use.
  
• Approve for General Use when the Requester selects Approve for General Use.
  
• Obsolete or Archived when the Requester selects Obsolete or Archived.

A status of Frozen changes to a status of:

• On hold when the Requester selects On Hold.
  
• Obsolete or Archived when the Requester selects Obsolete or Archived.

A status of Obsolete or Archived changes to a status of:

• Approve for Laboratory Use when the Requester selects Approve for Laboratory Use.
  
• Approve for General Use when the Requester selects Approve for General Use.

Set up Workbench Responsibilities for each user. The following are menu and submenu selections available to each listed Workbench Responsibility:

• Formulator
  
  • Formulator Workbench
    
  • Formulas
    
  • Recipes
    
  • Mass Search and Replace
    
  • Simulator
    
  • Formulation Specification Workbench
    
  • Inventory Items
    
  • Indented Bill of Materials
    
  • Formula Inquiry
    
  • Validity Rules - Product
    
  • Validity Rules - Recipe
    
  • Technical Data: Technical Parameters
    
  • Technical Data: Technical Parameter Sequences
    
  • Technical Data: Item Technical Data
    
  • Formula Analysis: Parameters
    
  • Formula Analysis: Analysis
    
  • Setup: Formula Class
    
  • Setup: Status Codes
    
  • Setup: Recipe Generation
    
  • Setup: Item Substitution List Setup
    
  • Setup: Process Engineering Items
    
    • Master Items
    • Organization Items
  • Others
    
    • Profile Options
    • Lookups
    • Change Organization
    • Session Parameters
    • User Organizations
  • Workflow
    
    • Advanced Worklist
  • Self Service Workflow
    
    • Home
    • Status Monitor
    • Notifications
  • Recipe Designer
• Process Engineer
  
  • Engineering Workbench
    
  • Process Routings
    
  • Process Operations
    
  • Recipes
    
  • Mass Search and Replace
    
  • Setup: Routing Classes
    
  • Setup: Operation Classes
    
  • Setup: Activities
    
  • Setup: Generic Resources
    
  • Setup: Plant Resources
    
  • Setup: Alternate Resources
    
  • Setup: Status Codes
    
  • Setup: Process Parameters
    
    • Define Parameters
    • Parameter Sets
    • Generic Resource Parameters
    • Plant Resource Parameters
  • Others
    
    • Profile Options
    • Lookups
    • Change Organization
    • Session Parameters
    • User Organizations
  • Workflow
    
    • Advanced Worklist
  • Self Service Workflow
    
    • Home
    • Status Monitor
    • Notifications
  • Recipe Designer
    
  • Routing Designer
• Product Development Security Manager
  
• Product Development Security Profile Manager