Visio stencils for adf faces

https://blogs.oracle.com/jdeveloperpm/entry/adf_faces_stencils_for_visio_available_on_samplecode

Found this link pretty useful to create mockup screens for ADF screens.

You can convert them in to xml and use in ConcepDraw also

iExpenses Basic Setup steps

Recently I participated in i Expenses roll out for 5 countries.

1. Profile Options
2. Payables Options
3. Document Sequences
4. Define Responsibilities
5. Define Expense templates
6. Define policies
7. Create Employees & Cost centers
8. Create user and Notification Preferences
9. Create Approval Hierarchy using AME
10. Delegate manager’s expense note create access to their secretory
11. Expense report Export
12. Optionally Payment Profiles
13. Workflow Modification where required

• Profile Options

Profile Name	Values
MO: Default Operating Unit
MO: Operating Unit
MO: Security Profile
OIE:Report Number Prefix	For example “IT-“
OIE:Enable Cost Center	Yes/No

• Payables Options

1. DEFAULT TEMPLATE
2. PAY GROUPS
3. PAYMENT TERMS
4. AUTOMATICALLY CREATE EMPLOYEE AS SUPPLIER

• Document Sequences

Define your document sequence for Expanse note in system administrator

• Define Responsibilities

Need to define responsibilities based on your requirement. There are two seed menus

1. Users
2. Global Policy

Define Expense template

In Payables > setup > Invoice > Expense template

PO Unexpected error occurred during Tax Calculation

   Check value populated value tax_attribute_update_code in po_headers_all, po_lines_all and Po_line_locations_all

Can’t see Move Orders Created by other users

ref Metalink : 280131.1

A. Define the INV_INVTOMAI_CREATOR function if is does not already exist:

Navigate: System Administrator > Application > Function
Enter Function Name: INV_INVTOMAI_CREATOR
Enter User Function Name: ‘Move Orders Creator’
Under the Properties tab, enter Type: Subfunction
Enter Maintenance Mode support: None
Enter Context Dependence: Responsibility
Save

B. Assign the function to the Menu you are using:

Navigate System Administrator > Application > Menu
Query for menu ‘INV_MOVE_ORDER’
Add a new line to the menu:
Prompt: ‘Move Order Creator’
Function: select ‘Move Orders Creator’ from the LOV
Description: ‘Move Orders Creator’
Save

Check Unposted SLA events

check if you have any Unprocessed events in SLA tables before your period closing. following sql will help you to identify those events.  need to run Create Accounting to process them to GL.

select xla.event_type_code
, EVENT_DATE
, xla.event_status_code
,xla.PROCESS_STATUS_CODE
,  count(*)
from xla_events xla
where xla.event_date between to_date(:p_date_from,’DDMMYYYY’) and to_date(:p_date_to,’DDMMYYYY’)
AND EVENT_STATUS_CODE != ‘P’
and trunc( xla.creation_date) between to_date(:p_date_from,’DDMMYYYY’) and to_date(:p_date_to,’DDMMYYYY’)
group by xla.event_type_code, xla.event_status_code, PROCESS_STATUS_CODE, EVENT_DATE

Create Adhoc roles in WF Process

you need to create roles if you are using WF to send emails that are not assigned to any application users. following script will help to create them.

PROCEDURE create_adhoc_role (
P_role_email varchar2 )
IS
v_role_email VARCHAR2 (1000);
n_ctr INTEGER := 0;
BEGIN

v_role_email := p_role_email;
SELECT COUNT (1)
INTO n_ctr
FROM wf_local_roles
WHERE NAME = v_role_email;

IF n_ctr = 0
THEN
wf_directory.createadhocrole (role_name => v_role_email,
role_display_name => v_role_email,
role_description => v_role_email,
notification_preference => ‘MAILHTML’,
email_address => v_role_email,
status => ‘ACTIVE’,
expiration_date => NULL
);
END IF;

END create_adhoc_role;

R12 Italian Localization Guide

Please find step by step guide to implement R12 Italian Localizations

Clikc Hear

LPN Controlled vs Non LPN Controlled subinventory

LPN Controlled vs Non LPN Controlled

If a subinventory has the LPN Controlled flag

• Subinventory can hold packed and unpacked material
• It can strore LPN’s packed.
• Miscellaneous receipts into this subinventory is not necessarily packed
• Material in this subinventory can be packed

Advantage are huge as you can transact LPN instead of conformation on single item specially items are serial controlled.

If a subinventory has the LPN Controlled flag disabled,
• it cannot store LPNs ( it doesn’t mean that you can’t generate LPN during receiving or select existing LPN)
• LPNs moved into this subinventory are automatically unpacked.
• Miscellaneous receipts into this subinventory must be for loose material
• Material in this subinventory cannot be packed.

Non-LPN controlled subinventories can be used for several different reasons, but two
common scenarios are forward picking areas [retail sales, material is always picked in small quantities ] and backflush subinventories [WIP process, material is automatically pulled for jobs, either as assembly pull or operation pull on the bill of materia ]

R12 COGS Accounting

Summary on R12 Deferred COGS Accounting

• The role of COGS workflow is not changed.
•  A new account called Deferred COGS account is introduced
• when the order shipped the entry will be                       Cr Inventory Material account                                                 Dr Deferred COGS Account  
• After revenue is recognized, the following programs need to be run to relieve deferred COGS value and debit actual COGS account.

Requests to Run

1. In  Inventory Responsibility run “Collect Revenue Recognition Information”
2. In  Inventory Responsibility run “Generate COGS Recognition Events”

R12 Internal Requisition Flow

Internal Requisition

Reference Metalink : 744481.1 and  406312.1
Metalink notes are described at great detailed on required setup,

• Organization witch ships the Goods [Source Organization /Shipping ]

, Organization witch request the goods [Destination Organization / Selling]

• Create Location, assign Destination Inventory Organization

 Create customer in Source organization assign, the location at ship to internal location, [ you can’t assign same internal location to any other customer , it’s 1to1 mapping]  

Destination ORG	Source ORG
PO Responsibility : Create Internal Requisition, Approve it Note: You can’t make any modification once the requisition is approved You can’t even cancel the Requisition You also noticed that Item Price in Requisition will be defaulted automatically the item cost of sourcing Organization , after selecting the source Inventory org.   Need by date will be the Scheduled Shipping date of the Order Run Create Internal Orders This request imports Order lines in source organization
	OM Responsibility Run  Import internal Orders Order will be created in Booked status. Run Pick Release and ship confirm Any changes to the order will reflect to the linked Internal requisition Canceling the Order will result canceling the requisition too You can’t  add any lines to the order, item change will be allowed  incase of item replacement /substitution
Based on Shipping Network setup In transit / Direct In Transit: Receive Goods using the Requisition numbers This can be done using Inventory / PO Responsibility
Cost manager worker costs the inventory transaction, with out this worker running successfully , you can’t create AR or AP invoices. Make sure all transaction  cost calculated . 1) calc of Average costing in Destination Organization is taking the price from List Price
	In Inventory Organization Run Inter company  AR Invoices In AR Responsibility Run Auto Invoice Interface
In Inventory Organization Run Inter company  AP Invoices In AP Responsibility Run Payables Open Interface Import