workflow background process and mrp setups

8/1/13 Oracle functional

snroracle.blogspot.in/search?updated-min=2012-01-01T00:00:00-08:00&updated-max=2013-01-01T00:00:00-08:00&max-results=26 1/16

Oracle functionalThursday, 13 December 2012

Posted by Natchirajan Shenbagamoorthy at 03:11 No comments:

ROI - How To Create ASN / Perform Receipt For ASN

Already Created Via ROI? [ID 549609.1]To Bottom

Modified: 16-Jun-2011

+1 Recommend this on Google

Friday, 23 November 2012

Workflow Background Process is a concurrent program which is run for processing deferred

activities, timed out activities, and stuck processes using the parameters specified. The background

engine executes all activities that satisfy the given arguments at the time that the background

engine is invoked. This procedure does not remain running long term, so you must restart this

procedure periodically. Any activities that are newly deferred or timed out or processes that become

stuck after the current background engine starts are processed by the next background engine that

is invoked.

Workflow Background Process is run with the help of Workflow Background Engine which is PL/SQL

Procedure which runs this concurrent program with specified parameters.

Workflow Background Process Parameters:

Item Type – Specify an item type to restrict this engine to activities associated with that item type.

If you do not specify an item type, the engine processes any activity regardless of its item type.

Minimum Threshold – Specify the minimum cost that an activity must have for this background

engine to execute it, in hundredths of a second.

Maximum Threshold – Specify the maximum cost that an activity can have for this background

engine to execute it, in hundredths of a second. By using Minimum Threshold and Maximum

Threshold you can create multiple background engines to handle very specific types of activities. The

default values for these arguments are null so that the background engine runs activities regardless

of cost.

Process Deferred – Specify whether this background engine checks for deferred activities. Setting

this parameter to Yes allows the engine to check for deferred activities.

Process Timeout – Specify whether this background engine checks for activities that have timed

out. Setting this parameter to Yes allows the engine to check for timed out activities.

Process Struck -

Specify whether this background engine checks for struck process.


Use of WORKFLOW BACKGROUND PROCESS INORACLE APPS


Monday, 5 November 2012

► 2013 (17)

▼ 2012 (26)

▼ December (1)

ROI - How To Create ASN /Perform Receipt For ASN...

► November (6)

► October (1)

► September (8)

► August (10)

Blog Archive

Natchirajan

Shenbagamoorthy

49Follow

View my complete

profile

About Me

0Share More Next Blog» Create Blog Sign In

http://snroracle.blogspot.in/

https://plus.google.com/101171671359199603016

http://snroracle.blogspot.in/2012/12/roi-how-to-create-asn-perform-receipt.html

http://snroracle.blogspot.in/2012/12/roi-how-to-create-asn-perform-receipt.html#comment-form

https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=1655778599663126&id=549609.1&_afrWindowMode=0&_adf.ctrl-state=139nhmq0ir_615#



http://www.blogger.com/share-post.g?blogID=2014137703022775620&postID=9091597261117644285&target=email

http://www.blogger.com/share-post.g?blogID=2014137703022775620&postID=9091597261117644285&target=blog

http://www.blogger.com/share-post.g?blogID=2014137703022775620&postID=9091597261117644285&target=twitter

http://www.blogger.com/share-post.g?blogID=2014137703022775620&postID=9091597261117644285&target=facebook


http://snroracle.blogspot.in/2012/11/use-of-workflow-background-process-in.html

http://snroracle.blogspot.in/2012/11/use-of-workflow-background-process-in.html#comment-form

http://snroracle.blogspot.in/2012/11/use-of-workflow-background-process-in.html





http://snroracle.blogspot.in/search?updated-min=2013-01-01T00:00:00-08:00&updated-max=2014-01-01T00:00:00-08:00&max-results=17

http://snroracle.blogspot.in/search?updated-min=2012-01-01T00:00:00-08:00&updated-max=2013-01-01T00:00:00-08:00&max-results=26

http://snroracle.blogspot.in/2012_12_01_archive.html

http://snroracle.blogspot.in/2012/12/roi-how-to-create-asn-perform-receipt.html







http://www.blogger.com/next-blog?navBar=true&blogID=2014137703022775620

http://www.blogger.com/home#create

http://www.blogger.com/




(Notes taken from metalink Doc Id--- How to Reconcile Financials for India Tax Accounting

Entries with General Ledger [ID 790203.1]

1.Query to identify receipts for which multiple entries are generated with Transaction Type =

'RECEIVE'

2.Query to identify total tax amount generated at the time of Receiving

3.Query to identify total tax amount generated at the time of delivery

4.Query to identify total modvat amount generated for CENVAT entries

5.Query to identify multiple entries populated into mtl_transaction_accounts (Standard Costing

Organization) when material is delivered

6.Return to Receiving Entries: Query to identify multiple entries generated for Return to

Receiving entries

7.Query to identify total tax amount generated at the time of Return to Receipt

8.Return to Vendor Entries: Query to identify multiple entries generated for Return to vendor

entries

9.Query to identify total tax amount generated at the time of Return to Vendor

10.Query to find the Modvat entries which hit PLA for RTV when the PLA pref =1

11.Query to identify multiple entries generated at time of Receipt for AP Accrual account

12.Query to identify total tax amount genearted for AP Accrual account at the time of Receipt

13.Query to identify total tax amount generated for AP Accrual at the time of Return to Vendor

14.Sum of Credit not equal to Sum of Debit for Return To Vendor transactions

15.Query to give total tax amount for AP Accrual where the tax entries are not generated

16.Query to identify cases of discrepancy in invoice distribution and the corresponding tax

amount in Receipt / PO

17.Query to give total sum of the taxes based on transaction type from

JAI_RCV_JOURNAL_ENTRIES (IL Subledger)

18.Query to Find The Sum of Tax Amounts from JAI_RCV_LINE_TAXES table, Organization

Wise


Wise


Wise

21.Query to Find the Sum of Tax Amounts from JAI_RCV_JOURNAL_ENTRIES WHERE

TRANSACTION_TYPE='RETURN TO VENDOR'

22.Query to identify Receipts for which accounting entries are not generated

23.Query to identify receipts where tax entries have been updated in IL subledger but missing in

General Ledger

24.Query to identify Receipt where accounting entries not generated for Deliver transactions

25.Query to find Receipts for which RTR entries are not generated

26.Query to Find (RTV) Returns for which accounting is not generated

27.Query to identify Receipts not yet claimed

Step 3

--------------------------------------------------------------------------------

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and

therefore has not been subject to an independent technical review.

Applies to:

Oracle Financials for India - Version: 12.0.0 to 12.0.6 - Release: 12 to 12

Information in this document applies to any platform.

Oracle Application - India Localization - Version: 12.0 to 12.0.6

Purpose

This Note will be helpful to Reconcile Financials for India Tax Accounting Entries with General

Ledger

Financials and India tax accounting entries with general ledger identification querys



Questions and Answers

Reconciliation of the General Ledger with the subledger data provided by India Localization shall be

done as per the following process:

Step 1

Import all the records pending in interface table and ensure that there are no pending transactions in

the interface. Compare the

GL account balances with the India Localization sub-ledger balances to verify whether the balances

are tallying. The following are the India

Localization reports that could be used for this purpose:

1. India Receiving account distrubution report.

2. India Receiving accounts report.

3. Accrual re-build reconcillation report.

4. India cenvat monthly return inputs and capital goods.

5. India cenvat monthly abstract report.

Step 2

If any differences are observed in these balances, following queries should be run to find out the

exceptions.

The list of queries are given below:

Tax accounting entries generated at the time of Receipt:

1.Query to identify receipts for which multiple entries are generated with Transaction Type

= 'RECEIVE'

select receipt_num,transaction_id,shipment_line_id,acct_type,acct_nature,

a.code_combination_id,entered_dr,entered_cr, count(*) cnt,

sum(nvl(entered_cr,0)) - avg(nvl(entered_cr,0)) "Excess Credit",

sum(nvl(entered_dr,0))-avg(nvl(entered_dr,0)) "Excess Debit" ,

gcc.concatenated_segments

from JAI_RCV_JOURNAL_ENTRIES a,gl_code_combinations_kfv gcc

where 0 < (

select count(*)

from JAI_RCV_JOURNAL_ENTRIES b

where a.transaction_id=b.transaction_id

and a.code_combination_id=b.code_combination_id

and a.acct_nature=b.acct_nature

and a.acct_type=b.acct_type

and nvl(a.entered_cr,0) = nvl(b.entered_cr,0)

and nvl(a.entered_dr,0) = nvl(b.entered_dr,0)

and a.rowid <> b.rowid

)

and a.period_name='&period_name'

and a.organization_code='&organization_code'

and a.transaction_type ='RECEIVE'

and a.code_combination_id=&CCID and gcc.code_combination_id = a.code_combination_id

group by receipt_num,transaction_id,shipment_line_id,acct_type,acct_nature,

a.code_combination_id,entered_dr,entered_cr,gcc.concatenated_segments

order by receipt_num,transaction_id,shipment_line_id,acct_type,acct_nature,

a.code_combination_id,entered_dr,entered_cr

2.Query to identify total tax amount generated at the time of Receiving

SELECT

NVL(SUM(ENTERED_CR),0) SUM_CREDIT,



NVL(SUM(ENTERED_DR),0) SUM_DEBIT

FROM

JAI_RCV_JOURNAL_ENTRIES E

WHERE

E.TRANSACTION_TYPE ='RECEIVE'

AND TRUNC(E.CREATION_DATE)

BETWEEN '&from_date' AND '&to_date'

AND E.ORGANIZATION_CODE = '&P_ORGANIZATION_CODE'

3.Query to identify total tax amount generated at the time of delivery

SELECT



FROM


WHERE

E.TRANSACTION_TYPE ='DELIVER'

AND TRUNC(E.CREATION_DATE) BETWEEN '&from_date' AND '&to_date'


4.Query to identify total modvat amount generated for CENVAT entries

SELECT



FROM


WHERE

E.ACCT_NATURE ='MODVAT'



5.Query to identify multiple entries populated into mtl_transaction_accounts (Standard

Costing Organization) when material is delivered

Select

b.transaction_id,b.reference_account,b.base_transaction_value,count(*),

nvl(sum(base_transaction_value),0) - nvl(avg(base_transaction_value),0) "Excess Amount Passed"

from mtl_transaction_accounts b, org_acct_periods c, mtl_material_transactions a

where 0 < (select count(1)

from mtl_transaction_accounts d

where b.transaction_id = d.transaction_id

and b.reference_account = d.reference_account

and b.organization_id = d.organization_id

and b.request_id is null

)

and a.transaction_id = b.transaction_id

and a.organization_id = b.organization_id

and b.reference_account = &code_id

and b.request_id is null

and a.acct_period_id = c.acct_period_id

and a.organization_id = c.organization_id

and c.period_name = '&PERIOD_NAME'

and c.organization_id = &org_id

group by b.transaction_id,b.reference_account,b.base_transaction_value

having nvl(sum(base_transaction_value),0) - nvl(avg(base_transaction_value),0) <> 0

order by b.transaction_id



6.Return to Receiving Entries: Query to identify multiple entries generated for Return to

Receiving entries







where 0 < (

select count(*)









)


and gcc.code_combination_id = a.code_combination_id

and a.TRANSACTION_TYPE ='RETURN TO RECEIVING'

and trunc(a.creation_date) between '&from_date' and '&to_date'





7.Query to identify total tax amount generated at the time of Return to Receipt

SELECT



FROM


WHERE

E.TRANSACTION_TYPE ='RETURN TO RECEIVING'



8.Return to Vendor Entries: Query to identify multiple entries generated for Return to

vendor entries







where 0 < (

select count(*)









)






and a.transaction_type ='RETURN TO VENDOR'

and a.code_combination_id=&CCID





9.Query to identify total tax amount generated at the time of Return to Vendor

SELECT



FROM


WHERE

E.TRANSACTION_TYPE ='RETURN TO VENDOR'



10.Query to find the Modvat entries which hit PLA for RTV when the PLA pref =1

select receive.organization_id "Organization",

recLine.inventory_item_id "Item Id",

itemMaster.item_class "Item Class",

receive.transaction_id "Receive Transaction id",

rtv.transaction_id "Return Transaction id",

receive.quantity "Receive Qty",

rtv.quantity "Returned Quantity",

pla.dr_basic_ed "PLA amount"

from

rcv_transactions receive,

rcv_transactions rtv,

JAI_RCV_LINES recLine,

JAI_INV_ITM_SETUPS itemMaster,

JAI_CMN_RG_PLA_TRXS pla

where

receive.transaction_type = 'RECEIVE'

and rtv.transaction_type = 'RETURN TO VENDOR'

and receive.shipment_line_id = recLine.shipment_line_id

and rtv.shipment_line_id = recLine.shipment_line_id

and receive.shipment_line_id = rtv.shipment_line_id

and receive.organization_id = rtv.organization_id

and rtv.organization_id = &organization_id

and recLine.inventory_item_id = itemMaster.inventory_item_id

and recLine.organization_id = itemMaster.organization_id

and rtv.transaction_date between '&date_start' and '&date_end'

and pla.ref_document_id = rtv.transaction_id

and pla.transaction_id = 19

order by 1, 2

11.Query to identify multiple entries generated at time of Receipt for AP Accrual account









where 0 < (

select count(*)









)




and a.TRANSACTION_TYPE ='RECEIVE'

and a.code_combination_id = &CCID and trunc(a.creation_date) between '&p_date_from' and

'&p_date_to'





12.Query to identify total tax amount genearted for AP Accrual account at the time of Receipt

SELECT



FROM


WHERE

E.TRANSACTION_TYPE ='RECEIVE'



AND E.CODE_COMBINATION_ID =&CCID

13.Query to identify total tax amount generated for AP Accrual at the time of Return to Vendor

SELECT



FROM


WHERE




AND E.CODE_COMBINATION_ID =&CCID

14.Sum of Credit not equal to Sum of Debit for Return To Vendor transactions

SELECT NVL(SUM(ENTERED_CR),0), NVL(SUM(ENTERED_DR),0),RECEIPT_NUM

FROM JAI_RCV_JOURNAL_ENTRIES

WHERE TRANSACTION_TYPE='RETURN TO VENDOR'

GROUP BY RECEIPT_NUM

HAVING NVL(SUM(ENTERED_CR),0) <> NVL(SUM(ENTERED_CR),0)

ORDER BY RECEIPT_NUM



15.Query to give total tax amount for AP Accrual where the tax entries are not generated

select rct.organization_id, jrl.receipt_num, jrtl.currency,

sum(jrtl.tax_amount),rcv.code_combination_id

from JAI_RCV_LINES jrl,

JAI_RCV_LINE_TAXES jrtl,

RCV_TRANSACTIONS rct,

RCV_RECEIVING_SUB_LEDGER rcv

where jrl.shipment_header_id = jrtl.shipment_header_id

and jrl.shipment_line_id = jrtl.shipment_line_id

and jrl.shipment_header_id = rct.shipment_header_id

and jrl.shipment_line_id = rct.shipment_line_id

and rct.transaction_type = 'RECEIVE'

and not exists (select '1'

from JAI_RCV_JOURNAL_ENTRIES

where shipment_line_id = jrtl.shipment_line_id

and acct_nature = 'Receiving'

)

and rct.transaction_id=rcv.rcv_transaction_id

and NVL(rcv.entered_cr,0) > 0

and rcv.code_combination_id=&CCID

group by rct.organization_id, jrl.receipt_num, jrtl.currency, rcv.code_combination_id

order by rct.organization_id,jrl.receipt_num,jrtl.currency, rcv.code_combination_id

16.Query to identify cases of discrepancy in invoice distribution and the corresponding tax amount in

Receipt / PO

select f.segment1 "PO Number", g.receipt_num "Receipt Number",

b.transaction_id "Receipt tran id", a.po_distribution_id "PO Dist.Id",

e.invoice_num "Invoice Number ", a.invoice_id "Invoice_id",

a.distribution_line_number "Distribution Line No", a.posted_flag "Posted",

c.tax_amount "Receipt Tax Amount", a.amount "Invoice Distribution Amt.", (c.tax_amount -

a.amount ) "Differential Amt"

from ap_invoice_distributions_all a,

rcv_transactions b,

JAI_RCV_LINE_TAXES c,

JAI_AP_MATCH_INV_TAXES d,

ap_invoices_all e,

po_headers_all f,

rcv_shipment_headers g

where a.rcv_transaction_id = b.transaction_id

and b.shipment_line_id = c.shipment_line_id

and a.invoice_id = d.invoice_id

and a.distribution_line_number = d.distribution_line_number

and c.tax_id = d.tax_id

and a.invoice_id = e.invoice_id

and b.po_header_id = f.po_header_id

and b.shipment_header_id = g.shipment_header_id

and b.transaction_type= 'RECEIVE'

and e.source = 'ERS'

and abs(c.tax_amount - a.amount ) >= 1

and b.transaction_date between '&from_date' and '&to_date'

17.Query to give total sum of the taxes based on transaction type from

JAI_RCV_JOURNAL_ENTRIES (IL Subledger)

SELECT

NVL(SUM(B.TAX_AMOUNT),0)

FROM



JAI_RCV_LINES A,

JAI_RCV_LINE_TAXES B,

MTL_SYSTEM_ITEMS C,

RCV_SHIPMENT_LINES D,


WHERE

A.SHIPMENT_HEADER_ID = B.SHIPMENT_HEADER_ID

AND A.SHIPMENT_LINE_ID = B.SHIPMENT_LINE_ID

AND A.SHIPMENT_LINE_ID = D.SHIPMENT_LINE_ID

AND A.SHIPMENT_HEADER_ID = D.SHIPMENT_HEADER_ID

AND C.INVENTORY_ITEM_ID = D.ITEM_ID

AND A.SHIPMENT_LINE_ID = E.SHIPMENT_LINE_ID

AND E.TRANSACTION_TYPE ='RECEIVE'

AND D.TO_ORGANIZATION_ID = C.ORGANIZATION_ID

AND TRUNC(A.CREATION_DATE) > '&parameter_date'

AND D.TO_ORGANIZATION_ID = &P_ORGANIZATION_ID

ORDER BY D.TO_ORGANIZATION_ID,TO_NUMBER(A.RECEIPT_NUM)

18.Query to Find The Sum of Tax Amounts from JAI_RCV_LINE_TAXES table, Organization Wise

SELECT


FROM

JAI_RCV_LINES A,


MTL_SYSTEM_ITEMS C,



WHERE







AND E.TRANSACTION_TYPE ='DELIVER'






SELECT


FROM

JAI_RCV_LINES A,


MTL_SYSTEM_ITEMS C,



WHERE







AND E.TRANSACTION_TYPE ='RETURN TO RECEIVING'








SELECT


FROM

JAI_RCV_LINES A,


MTL_SYSTEM_ITEMS C,



WHERE







AND E.TRANSACTION_TYPE ='RETURN TO VENDOR'





21.Query to Find the Sum of Tax Amounts from JAI_RCV_JOURNAL_ENTRIES WHERE

TRANSACTION_TYPE='RETURN TO VENDOR'

SELECT



FROM


WHERE


AND TRUNC(E.CREATION_DATE) > '&parameter_date'


22.Query to identify Receipts for which accounting entries are not generated

select substr(rct.organization_id,1,3),substr(jrl.receipt_num,1,10),substr(jrtl.currency,1,5),

substr(CONCATENATED_SEGMENTS,1,35),sum(jrtl.tax_amount),rcv.code_combination_id




RCV_RECEIVING_SUB_LEDGER rcv,

gl_code_combinations_kfv glc









and transaction_type = 'RECEIVE'

)

and jrtl.tax_amount != 0




and rcv.code_combination_id = glc.code_combination_id


and JRL.CREATION_DATE BETWEEN '&P_DATE_FROM' AND '&P_DATE_TO'

and rct.organization_id=&p_organization_id

group by substr(rct.organization_id,1,3),substr(jrl.receipt_num,1,10),substr(jrtl.currency,1,5),

substr(CONCATENATED_SEGMENTS,1,35), rcv.code_combination_id

order by substr(rct.organization_id,1,3),substr(jrl.receipt_num,1,10),substr(jrtl.currency,1,5),

rcv.code_combination_id

23.Query to identify receipts where tax entries have been updated in IL subledger but missing in

General Ledger














from gl_je_lines

where reference_5 = to_char(jrtl.transaction_id)

and description like 'India%'

)




--and NVL(rcv.entered_Dr,0) > 0







24.Query to identify Receipt where accounting entries not generated for Deliver transactions


sum(jrtl.tax_amount)



RCV_TRANSACTIONS rct





and rct.transaction_type = 'DELIVER'

and nvl(jrtl.modvat_flag, 'N') = 'N'




and transaction_type = 'DELIVER'

)

and jrl.creation_date between '&from_date' and '&to_date'

group by rct.organization_id, jrl.receipt_num, jrtl.currency

order by rct.organization_id, jrl.receipt_num, jrtl.currency



25.Query to find Receipts for which RTR entries are not generated





RCV_TRANSACTIONS rct





and rct.transaction_type = 'RETURN TO RECEIVING'

and nvl(jrtl.modvat_flag, 'N') = 'N'




and transaction_type = 'RETURN TO RECEIVING'

)




26.Query to Find (RTV) Returns for which accounting is not generated












and rct.transaction_type = 'RETURN TO VENDOR'




and transaction_type = 'RETURN TO VENDOR'

)











27.Query to identify Receipts not yet claimed





rcv_transactions rct








and nvl(jrtl.modvat_flag, 'N') = 'Y'

and exists (select '1'

from JAI_RCV_CENVAT_CLAIMS


and cenvat_claimed_ptg <> 100

)






Sunday, 4 November 2012

Quick Review on MRP setups....

Introduction

Setting up the Oracle Master Scheduling/MRP and Oracle Supply Chain Planning modules is easy.

Determining how your business will leverage the features,

is the hard part. This document can be used as a guide during your implementation.

Before you set up Oracle Supply Chain Planning, you must complete the setup for the following:

products:

Oracle Inventory

Oracle Purchasing

Oracle Bills of Material

Oracle Work in Process

Oracle Project Manufacturing

Planning Setup Checklist

Required steps for System Administration, General Ledger, Inventory, Purchasing, Bills of Material,

and WIP modules need to be completed before

Planning is setup.

The following steps need to be completed in the order shown:

Step 1:

Define your Master Scheduling/MRP Setup Parameters (Required)

NAV/Supply Chain Planning/Setup/Parameters or

NAV/Material Planning/Setup/Parameters

You can override the execution defaults, when defining the MPS, MRP or DRP for your

organization(s).

To have all past due demand (sales orders, forecast, etc.) reflected in your plans, select Null for

Include MDS Days.

Entering a value will limit the past due information visible in the Plan.

Step 2:

Define your Deliver-to Locations (Optional)

NAV/Inventory/Setup/Organizations/Locations


http://snroracle.blogspot.in/2012/11/financials-and-india-tax-accounting.html

http://snroracle.blogspot.in/2012/11/financials-and-india-tax-accounting.html#comment-form







Step 3:

Define your Employees (Optional)

NAV/Work In Progress/Setup/Employees

Note: Enter Employees through Human Resources, if installed.

A required step when implementing planning recommendations from the Planner Workbench (Step

21).

Step 4:

Set Profile Options (Required with Defaults)

NAV/Profiles/System/Find MRP

Note: Use the Sysadmin Responsibility. The value for Snapshot Workers can be increased

depending on the number of items being planned. Use the

following formula to determine how many Standard Managers are required to support the process.

The value for the Planning Manager Max Workers should

not be more than the number of Standard Managers.

(Snapshot workers value *2) + 4 = # of Standard Managers

(2*2) + 4 = 8 Standard Managers

Recommended initial values:

MRP:Environment variable to set path for MRP files Null/Blank

MRP:Planning Manager Max Workers 6

MRP:Retain Dates within Calendar Boundary Yes

MRP:Snapshot Workers 2

MRP:Use Direct Load Option No

Step 5:

Define your Forecast Sets (Optional)

NAV/Supply Chain Planning/Forecast/Sets

NAV/Material Planning/Forecast/Sets

Step 6:

Define your Master Demand Schedules (MDS)(Optional)

NAV/Supply Chain Planning/MDS/Names

NAV/Material Planning/MDS/Names

Step 7:

Define your Master Production Schedules (MPS) (Optional)

NAV/Supply Chain Planning/MPS/Names

NAV/Material Planning/MPS/Names

Step 8:

Define your Material Requirements Plans (MRP);

Define your Distribution Requirements Plans (DRP) (Optional)

NAV/Supply Chain Planning/MRP/Names

NAV/Supply Chain Planning/DRP/Names

NAV/Material Planning/MRP/Names

Step 10:

Define your Sourcing Rules or Bills of Distribution (BOD)

NAV/Supply Chain Planning/Sourcing

Note: When you select All Orgs for your Sourcing Rule, it can be used by all organizations when

defining an Assignment Set. A Local

Sourcing Rule would only have the Org selected, and can only be used by the defining organization.

The Planning Active box will only be checked

if the allocation % = 100. The planning process will not use the rule, unless the Planning Active box

is checked

Step 11:



Create your Assignment Sets

NAV/Supply Chain Planning /Sourcing/AssignSourcing Rules/BOD

Note: A Local Sourcing Rule assigned at the Item-Organization level, overrides all others for that

item.

Step 12:

Define your Inter-organization Shipping Network

NAV/Inventory/Setup/Organizations/Shipping Network

Step 13:

Define Shipping Methods and associated intransit lead times

NAV/Inventory/Setup/Organization/Shipping Methods

NAV/Inventory/Setup/Organization/Shipping Network

Special Menu: Shipping Methods Intransit Times

Step 14:

Run the Information Audit (Optional-highly recommended)

NAV/Supply Chain Planning/Reports/Audit Information Report

NAV/Material Planning/Reports/Audit Information Report

Step 15:

Define your Planning Parameters (Required)

NOTE: this is a duplicate of Step 1.

Step 16:

Start the Planning Manager (Required)

NAV/Supply Chain Planning/Setup/Planning Manager or

NAV/Material Planning/Setup/Planning Manager

(See screen shot below; the active box should be checked and you should see current messages)

Step 17:

Define your Planners (Optional)

NAV/Inventory/Setup/Planners

Step 18:

Define your Planning Exception Sets (Optional)

NAV/Supply Chain Planning/Setup/Exception Sets

Or NAV/ Material Planning/Setup/Exception Sets

Step 19:

Define your Demand Classes (Optional)

NAV/Supply Chain Planning/Setup/Demand Classes

OR NAV/Material Planning/Setup/Demand Classes

Note: Selecting a Demand Class when defining your MDS or MPS,restricts data seen in the

schedules. Only Sales Orders with the

demand class entered at the line level will be included in your MDS.

Only Discrete Jobs with the demand class added,(NAV/WIP/Discrete/Discrete Jobs/More) will be

included in your MPS.

Step 20:

Create Source Lists (Optional)

NAV/Supply Chain Planning/Forecast or MDS or MPS /Source List

NAV/Material Planning/Forecast or MDS or MPS/Source List

Step 21:

Set Up Planner Workbench (Required)

For instructions, see: Setting Up Planner Workbench:

Oracle Master Scheduling/MRP and Supply Chain Planning User's Guide Release 11: page 1-28.



Newer Posts Older PostsHome

Subscribe to: Posts (Atom)

Step 22:

Set Up for Supplier Planned Inventories (Optional) For instructions on setting up Supplier Planned

Inventories, see the prerequisites in

Oracle Master Scheduling/MRP and Oracle Supply Chain Planning User's Guide Release 11, page

5-8.



Ethereal template. Powered by Blogger.


http://snroracle.blogspot.in/search?updated-min=2012-01-01T00:00:00-08:00&updated-max=2012-11-04T03:50:00-08:00&max-results=26&start=4&by-date=false


http://snroracle.blogspot.com/feeds/posts/default


http://snroracle.blogspot.in/2012/11/quick-review-on-mrp-setups.html

http://snroracle.blogspot.in/2012/11/quick-review-on-mrp-setups.html#comment-form






workflow background process and mrp setups

Documents

background engine checks

background engine thatis

deferred activities

item type

multiple background

struck process

activities regardlessof

process timeout