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.
- Profile Options
- Payables Options
- Document Sequences
- Define Responsibilities
- Define Expense templates
- Define policies
- Create Employees & Cost centers
- Create user and Notification Preferences
- Create Approval Hierarchy using AME
- Delegate manager’s expense note create access to their secretory
- Expense report Export
- Optionally Payment Profiles
- 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
- DEFAULT TEMPLATE
- PAY GROUPS
- PAYMENT TERMS
- 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
- Users
- 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
