Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Wednesday, March 6, 2013

Oracle IExpenses Setups In R12

:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:

I Expenses:
iExpenses is basically an extension Oracle Payables. Employee and Contingent Worker expense reports become supplier invoices and get paid from Payables. You will need following responsibilties to set up Internet Expenses: Payables Manager, Internet Expenses Setup and Administration, System Administration, Application Developer, and AX Developer. If you are also planning on charging expense reports to projects, you will also need Project Billing Super User and General Ledger Super User responsibilities. You will also need access to Oracle Workflow Builder to customize the Expenses workflow and Project Expense Reports Account Generator.

Setups for IExpenses : 
1.Define MOAC
2.Define Job
3.Define Position.
4.Define Employee.
5.Define Financial Options.
6.Define Expenses Template.
7.Define Payable Options.  
8.Assign Cost Center Flexfield qualifier to Department segment or Cost center segment.
9.Define Signing Limits.
10.Assign Profile Option to IExpenses Responsibility.

 1.Define MOAC
·                     Define Responsibilities for GL, AP,PO,HRMS,IEXPENSES
·                     Define Business Group.
·                     Define Ledger.
·                     Define Operating Unit.
·                     Define Security Profile.
·                     Run Security List Maintenance Program. 
·                     Assign Security Profile to Responsibilities. 
·                     Run Replicate Seed Data Program.  

2.Define Job
Navigation:HRMS --> Work structures --> Job --> Description.

Click on New button. 
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqxSjWjs1R5ZT5ZtBo8di_DK5Sw-CYusRl5FvE-ka29uWw0RBLrmom-BMlUw1w1jUsQOO3_rq2Hc_6NfDnUuwzY3ayQfb1DWguh1R3cmsOI-Ym0ZVlTcZBDE7CQWgyx-uaNNhAo5VU5S1Y/s640/Job.jpg


Enter the Job Name and Code.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzVJZc8ctzpf6NYuPyC__d8k7axMjJENz5ssLVVSoF-QHhDVsSZdDr_BU9NEtbiJ5RUvQqQesGtk-SRtuQb63G6Uq8YRHG8soNoTRMPugManxFAVxmSK2fXYZSe5fXinYfaj9_8hNBxkZR/s640/Job1.jpg

 Save.

 3.Define Position.
Click on New button. 
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmgA1vTCtn5un0J4j1TLjmd_IV8sdA00a-f0Z6GihH5LTAORhUie153a8rh9uCGoGWuUuXnNup7PMt7n4ZXeswc4EnCXN2LZzZLqoguhS-mTusKNyLjBXw71qn_UIeVzbdW6oY96zKbcai/s640/Pos.jpg

Enter Position number and name ,type, Organization,job,and Status of the position.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTw405UXcf4DHbatBMIkBqiDbZo60Vyw4W_XXuF3zQyL8Fax_phnByNMdGXNX9rOKh08NmdtdUiKLK8AkPG0_H1NJoGxEzs2nbPwt1QbPG5IcR3rMqyyKyG2WjsK-ccdfGKFuJTaxShTCG/s640/Pos1.jpg

Save.

Note: If you want create more position please follow same as above procedure.

  4.Define Employee.
Navigation: HRMS --> People --> Enter and Maintain.

Click on New. 
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6mebIYwYrGcQh64MLwY0NgoPkExqB47qRcCcdhHC64oszzaGVe3R2ki28dgQAcbvZab-JJj0Wa9AZNbT-SZk4jArSq4cTjU42GpQe5rguXldsMUVoTbuu9639H7P5zoj0Pjc1KpER3yPJ/s640/Emp.jpg


 Enter Employee Last name,gender,action and birth date.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkUecfdhuKW4_wd8cc1PrH8SGFv-PvjEvGxY_a4wsWI7kIU7MrdneYsGdNj8n_1Mu-OsL5hnK4LZvXPenIr1w8MuzToCYHeoFjCJU4S9RPdI6MYtfQPQLlXhKKBBwl2F0qTBBMwOkOthqu/s640/emp1.jpg

Save and click on Assignments. 

 Enter HR Organization name,job name and Position name.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdG6S2Qja4ZDbQw_lI8Y-W20cNFzSgW36C5_GdBuymKsAn11nopjP7NuaXazq3CgA0pWs10oQoTjSRXmMKjCmQYR_i9shqm5bPK13ndY8X1g36BV0NnVaSAl5oWktKKZLpvVQjxTFMPcjz/s640/Emp2.jpg

Save.

Click left lov button and select the purchase order information.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt9PDqsBMXbg61qo81dB4e8_xzkjajPvE7A_0Tc756-tg_V8aVrta831PW0yHUecayFmM0HtYOoKvC-8KsuxNzLCSTk7PdKvKPjOfv-JXZ5BH1cDC1id8_2ITIDSizjSzY1IY_MJG5wjQw/s640/Emp3.jpg

 Enter the primary ledger name and default expenses account.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgR3t0ujblll9s1kMaOYunN6GlozEniwXhTtNC0LAdPQRR6-_QkVFc4ZSyTBWKzGWZf2TZqr798WTd5XgooaKoc7AFeE7ckH9F1f4Q7KmhjQpYZHD9t3uVcU_GKSJH0hqz_8Az7_y2mnJ-J/s640/Emp4.jpg

Save. 

5.Define Financial Options.
Use the Financials Options window to define the options and defaults that you use for your Oracle Financial Application(s). Values you enter in this window are shared by Oracle Payables, Oracle Purchasing, and Oracle Assets. You can define defaults in this window to simplify supplier entry, requisition entry, purchase order entry, invoice entry, and automatic payments. Depending on your application, you may not be required to enter all fields.
Although you only need to define these options and defaults once, you can update them at any time. If you change an option and it is used as a default value elsewhere in the system, it will only be used as a default for subsequent transactions. For example, if you change the Payment Terms from Immediate to Net 30, Net 30 will be used as a default for any new suppliers you enter, but the change will not affect the Payment Terms of existing suppliers.

Navigation: Payables --> Setup --> Options --> Financial.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhA48tOx8oe8aVQpaz8BmDX60ctParb7kEWEXJcHG7guacL36SkS_j-FjoN1KOvfnPrAYaHtqorysmvhKtnU8htnXq-dC1nfvcNL7Mfg1Zma0VBfxJcuMDtCgh6UpwGnlTcKW1kTqfbvdIB/s640/Fin1.jpg
 
 Click on New button.

Accounting Tab:
You are required to enter defaults for the Accounting Financials Options in the Accounting region. 

Accounts Like:
Liability, Prepayment, Discount Taken.  
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6Tej1AVJsZZm1y9vFDGiKuHnc6pqt2s05YK7XzWUBE2g0DOqBWdPjFH0DBBvaw0pLrNhk-cN_LDWmMrmFJTTrZG7GFwvJ5mitpTukpvTZ4tpgLJrXii4QN8GrgVu9qDXSoaUbOnxJe-_t/s640/Fin2.jpg

Supplier-Purchasing Tab:
If you do not also have Oracle Purchasing installed, you do not need to enter defaults in the Supplier- Purchasing region.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOhllStbN836P7hQsN1Sx8z6NbNHr63nBZiyrk4o6mQ13hJm6sY7OPvn9YpCOq6IZIefM5XYw21Ts2Inukpb-NqnoKYc3AcYLIsArLvyQuPPqmu4I6LUzLBiFM5uzs1Oeb35pm1yrw9RB3/s640/Fin3.jpg

 Encumbrance Tab:
If you do not use encumbrance accounting or budgetary control, you do not need to enter defaults in the Encumbrance region. 
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5JoHag5_HkDic9w3xuzzIN0KSvNzufIPZUs3R0pqujC42L7zYl3Ux9UZFQAy204_Rx9puKXndpqss7Eb8LyF_WHvi2woQsjglMwDI1kFv0-TYco_xgzjeMLOc8l5nyi2rqaI0DQfOiv_s/s640/Fin4.jpg


Tax Tab:

If your enterprise does not need to record a VAT registration number, you don't need to enter defaults in the Tax region.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6B0jfySynWQ-YH0qvx8O12roQgQnB2Oxq1-skZnz8NdeTD_CpfrFn7xY6qQRi2eVE_L5mdCOCuF6Ygj5KB7xpngCX8xDer8FvOhpJLL_wqbk_nHQE0uvRb9CObdt6ZaQJ9hrnZHGDiHzH/s640/Fin5.jpg

Human Resources Tab:
If you do not have Oracle Human Resources installed, you are not required to enter defaults in the Human Resources region.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_MT-H3Emh_EM3Xpg6uX2SiL0rXiLzBPVDzYpsqTh5B0rfkjVxmyK_6gATqfDURjvaV7dB6gtThQh5Nm7R6UJdgtNFVrX7cA2Z7QReUPpYQilcklup7O2DvMnE0kaWLo12ApqE9QNfHYqz/s640/Fin6.jpg

 Save.

 6.Define Expenses Template.
Navigation: Payables --> Setup --> Invoice --> Expenses Report Templates.
Enter operating unit name,template name and enable the enable for internet expenses. 
And finally enter your expenses.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhI-1vASYZWvefbND1oBm0Nnkf5_s2Wz57D5fxbbqwrfZfqswRnm53-Kq8T_ELVNvxhOUQ-W_gwuDPfv06ryYOcMxKhElnDfsgFfPko-KjvErcsKAIeum6Y8R5numxEsVLjg3iIl22zoR6Y/s640/Temp.jpg

Save. 

7.Define Payable Options.  
Navigation: Payables --> Setup --> Options --> Payable Options.

Click on Find. 
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPrmur2bgQV986rMHCDUeSETIRm3VxzKqZfVWFk9BGA6eoKXy1S0SzCcd_vYCqYryrCca7NIVb6bVpuJgJfLNs_3L_e_hdA5nAbC67BNnQ4FEuBWOut518SnrF0TokCPZAAhAElJYf0rlv/s640/Pay1.jpg
  
Click on Expense Report Tab. 
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNN_zq7XPCZj4Idkb3P1-2Gv8BiA0QzPau2uaQIT3Lt-a_tChVHJKfwKc4Arw3vnxpCBGWy5KkCeLuH6vY3HuX-2IAQ0MTZsW9ON0U0Eq1ob4WgsevkdbwZgdbohwFrM3uTic2cKH4-wq-/s640/Pay2.jpg


https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfgOQwSWO0LeG5Wx_OnkDmCSTkWHYvTz92FvQeLNtLo2qRuze3hvcUscXA4xqmg2vuX9ZaKklIQ2PsyjpdY8PmhANxpAKwLSvqv8mIDprNdVQcAJZtGkvXHGp1AuIldLhbtPHnCiH6I2Uq/s640/Pay3.jpg

Default Template. The default expense report template that you want to use in the Payables Expense Reports window. You can override this value in the Expense Reports window. A default expense report template appears in the Expense Reports window only if the expense report template is active.

Apply Advances. Default value for the Apply Advances option in the Expense Reports window in Payables. If you enable this option, Payables applies advances to employee expense reports if the employee has any outstanding, available advances. You can override this default during expense report entry.
If you use Internet Expenses and you enable this option, then Expense Report Export applies all outstanding, available advances, starting with the oldest, up to the amount of the Internet expense report.

Automatically Create Employee as Supplier. If you enable this option, when you import Payables expense reports, Payables automatically creates a supplier for any expense report where an employee does not already exist as a supplier. If the supplier site you are paying (HOME or OFFICE) does not yet exist, Payables adds the supplier site to an existing supplier. Payables creates a HOME or OFFICE supplier site with the appropriate address, depending on where you are paying the expense report. The Home address is from the PER_ADDRESSES table, and the Office address is from the HR_LOCATIONS table. Payables creates suppliers based on the defaults you select in this region and employee information from the Enter Person window. You can review suppliers and adjust any defaults in the Suppliers window.
If you do not enable this option, enter an employee as a supplier in the Suppliers window and link the Employee Name/Number to the supplier before you use Expense Report Export. Payables cannot export expense reports without corresponding suppliers, and lists them on Export Results page.
Payment Terms. Payment terms you want to assign to any suppliers that you create from employees during Expense Report Export.
Suggestion: Define and assign immediate payment terms for your employee suppliers.
Pay Group. Pay Group you want to assign to any suppliers that you create from employees during Expense Report Export. You can define additional values for Pay Group in the Purchasing Lookups window.
Payment Priority. Payment priority you want to assign to any suppliers that you create from employees during Expense Report Export. A number, between 1 (high) and 99 (low), which represents the priority of payment for a supplier.

Hold Unmatched Expense Reports. This option defaults to the Hold Unmatched Invoices option for the supplier and supplier site for any suppliers Payables creates during Expense Report Export.
When Hold Unmatched Invoices for a supplier site is enabled, Payables requires that you match each invoice for the supplier site to either a purchase order or receipt. If you enable this option for a site, then Payables applies a Matching Required hold to an invoice if it has Item type distributions that are not matched to a purchase order or receipt. Payables applies the hold to the invoice during Invoice Validation. You cannot pay the invoice until you release the hold. You can release this hold by matching the invoice to a purchase order or receipt and resubmitting Invoice Validation, or you can manually release the hold in the Holds tab of the Invoice Workbench. Payables will not apply a hold if the sum of the invoice distributions by accounting code combination is zero.
 
Save. 

8.Assign Cost Center Flexfiedl qualifier to Department segment or Costcenter segment. 
Navigation: Payables --> Setup --> Flexfield --> Key --> Segments.

Query your Coa.
Un Freeze Flexfield Definition and click on segments.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaJw3TuR1-eUcbBVZ2UPpqzFJL-2NrreTKpJa5XYRNOhD2RZ2vefH1ip3niTDkXNpNCKNZvTdMdMJXJRds7r7HNoXBSZNE-43aXPuKnCCvI8V2NsAYMqCE_7vPm2rXFILeqpMbgWtWTskM/s640/Flex1.jpg

 select Cost Center segment and then click on the Flexfield Qualifiers.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgizq0mNPs2xfZHnBFL3Co9lm9WuzSmuoIr9F7K2TSRmxsp0UTzphxPznIahj8P8yq2fHekonBOxPAD0mexXsq2hH01U5f7u3fiXWziXHmQ1yRNX2tzSO2xMfVp2uiwKPqUfAH-I_h0vK7z/s640/Flex2.jpg

Enable cost center segment. 

Save.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr-94qq4lPF45CuINck4JlJTRi4GuQbKGewAKh89X8CVhwuzBzQtxzqHIokdFi8Xlfv1kPMsoQkZdX0MtAcUfwxSSL4rMAMwfEbxwKLN0SCVLG3PjUhgUatNWO4jq1DqZyPVsTb9vTLJi-/s640/Flex3.jpg


 9.Define Signing Limits.
Navigation: Payables --> Employees --> Signing Limits.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEin8E1Ru1JmwkydeEHOjoqdKqYiQLUIjXbO9H8mhTe_xhJbIQjYpzMWMUZ_-xyUpPkMVS5Nw1SPlrbPY46MY4BKmDyEQ92L-sUxGhOjUxKfivPnpl8FsRyvslDINNM8YnFgUc38Ptp0JvnD/s320/Sig.jpg

 10.Assign Profile Option to IExpenses Responsibility.
Navigation: System Administrator --> Profile --> Systems.
Please set the following Profile options in Site level as well as Responsibility level.   
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6un3aCOawK1xBgMwZktIdE1Rf19GgXTJlDdhWzF2bJDUUWCe1vYctpz-nUKup439mAc1IhArKVBPrTqfJuIJv00ftaReazjPX3-leN02rAQ7u13oSpZhxJvpdX266ML6gJmQ7PvbwFjDL/s640/Pro.jpg


https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1uj-jbuN6H4arm19JksLUmSF1pnz2eZiI8fADVwWk6FPFvoYSajxHxOlV2XrnFAw4ysc4iB_gdyIQ1lbRdXZaQuj008oR2gWHvFmzgw0z8bvFOhpwjZHGdSPu1Q8zYvaDXQbwTXQK85gy/s640/Pro1.jpg

:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect