Oracle Apps Concurrent Program Return Code

OTCOrder004.png' alt='Oracle Apps Concurrent Program Return Code' title='Oracle Apps Concurrent Program Return Code' />Oracle iexpenses process flow Approval Hierarchy Administrative features in iExpense Workflow Notifications Error Handling. When doing an upgrade from Oracle Applications 11i to R12, we often have to mitigate custom code to be compliant with R12. In this process you often come across code. Program Short name of the concurrent program not the executable for which the request should be submitted. VCYt1icJnXA/UcrKOjEMsVI/AAAAAAAAG4U/NVyE5wBgmSI/s1600/5.png' alt='Oracle Apps Concurrent Program Return Code' title='Oracle Apps Concurrent Program Return Code' />Using Oracle i. Expenses, employees can enter and submit expense reports. There is a Workflow process that is initiated behind when an expense report is submitted which automatically routes expense reports for approval. Oracle Internet Expenses integrates with Oracle Payables to provide quick processing of expense reports for payment. This article includes these topics Process Overview. Approval Hierarchy. Administrative features in i. Expense. Workflow Notifications Error Handling. Process Overview The employees would be issued Corporate credit cards which could be used for organizations business expenses. The bank would send in all the credit card transaction files on a daily basis or the agreed time interval. Oracle Apps Concurrent Program Return Code' title='Oracle Apps Concurrent Program Return Code' />I am trying to insert into Oracle database which has two columns ID Primary Key varchar2 4000 ACCOUNT varchar2 4000 I wrote a. Urgent Required IT MNC Oracle Apps SCM ProfessionalsBangalore,Pune,Chennai,Hyderabad. We at Manpower Services, New Delhi have an excellent permanent opportunity. These credit card transactions have to be loaded into APCREDITCARDTRXNSALL table using credit card transaction loader programs. After loading credit card transactions data into the APCREDITCARDTRXNSALL table, the Credit Card Transactions Validation program should be run to validate the loaded data. Once validated, employees can enter these credit card transactions on expense reports to get re imbursement from the company. Once the employee vouchers the expenses through i. Expense responsibility or Expense report screen in Account Payables responsibility and submits it, the workflow with the internal name APEXP is initiated which would validate the data entered, determine the Approver, sends notifications to the approver. The Approver has to then Approve or Reject the notification accordingly. Once the workflow activities are complete, use the concurrent program Expense Report Import to create Payables invoices from expense reports you enter in Payables or Oracle Internet Expenses. You can then use Payables to validate and pay these invoices and create accounting entries for them. Approval Hierarchy in i. Expense If the profile option AME Installed is set to Yes, then the routing rules for approvals setup in Oracle Approvals Management are used, If set to No then the EmployeeSupervisor Approval Process is used. EmployeeSupervisor Approval Process In the EmployeeSupervisor Approval Process, the supervisor of the Expense reports owner would become the APPROVER. Every Employee should be assigned a Supervisor within Human Resources Responsibility New Hire Assignments. An employee must be set up as a supplier prior to entering the expense report. Managers can approve an expense report only if the total amount of the expense report does not exceed their signing limit. The Manager Spending Approval Process in the Expense Reporting workflow uses the signing limits you defineNavigation Account Payables responsibility Employees Signing Limits to determine which manager has authority to approve expense reports. If the amount on the expense report exceeds the signing limit of the approver, the expense report is automatically forwarded to the manager of the approver. This goes up the management hierarchy until an Approver is found who could approve the Expense report. This process does not look at the purchasing Approval Hierarchy. Administrative features in i. Expense Delegating the authorization to enter the expenses on ones behalf You can authorize an employee to enter expense reports for another employee. An employee who is assigned the responsibility to enter expense reports for another employee is an authorized delegate. There are 2 ways this could be done Go to System Administrator Security Users. Query for the Users record. Under Securing Attributes tab, add the below details Attribute ICXHRPERSONIDApplication Self Service Web Applications. Value Employee Id or the Personid to whom the access to enter the expense reports has to be given. Go to the i. Expense responsibility Expense Preferences Authorization Preferences. Under Expenses Entry Delegations, click on the Add another row and enter the nameto whom the access to enter the expense reports on your behalf has to be given. Re direct or Auto respond to the notifications If the approver is on leave, the notification could be delegated or forwarded to the desired approver using Create Vacation Rule. Steps to create Vacation rule 1. Expense Responsibility Expenses Home. Select the Vacation Rule link. Select the Create New Rule link. For Item Type select Expenses for all Notifications or select the desired Notification Type from List of Values. Select the Next link to proceed to the next setup page for the rule. Enter both a a valid Start and End Date for the new rule. Ensure the Reassign radio button is selected. Keep All Employees and Users in the menu box. Select the Delegate radio button AssignReassign action is prohibited for Purchasing Notifications. Select the Flashlight icon next to the blank menu box for selecting a user. A new sub screen should pop up to perform the user search. For Search By select Username DO NOT search by Name1. Perform the needed wildcard search at the top of the page to locate the desired username. Click the radio button next to the desired name of the user to have the notifications sent to. Press the Select button followed by the Apply button. Continue on with the saving of the Vacation Rule for latter use. Minecraft Long Adventure Maps. Assigning the Card to another person to voucher the expenses on someones behalf. This could be done if a person has to access the outstanding credit card charges of another person to voucher them temporarily. The disadvantage with this would be, the charges will be vouchered under the assignees name and would go to the assignees manager for Approval. Workflow Notifications Error Handling In this section we will mainly focus on the notifications that are sent to the APPROVER for the approval as it is very important to see that such notifications reach the APPROVER on time so that there is no delay in the processing of the expense report to avoid late fee enforced by the Credit Card company. These notifications will have the messagename as OIEREQEXPENSEREPORTAPPRVL in wfnotifications table. The mail status of the notification can be SENT, CANCELED, MAIL, UNAVAIL, ERROR, NULL. Let us see in detail about these and the actions required to get the notification to SENT status. The below is the script to check the notification status select wn. TOCHARwn. begindate,DD MON YYYY hh mi ss begindate. WR. emailaddress. IN OPEN, CANCELED. OIEREQEXPENSEREPORTAPPRVL. IN PENDMGR, RESOLUTN. WN. recipientrole WR. SENT The notification has been successfully sent to the APPROVER. CANCELED The system is setup to send the notifications n times n can be set in the workflow attributes with a timeout after 5 days. If the Approver does not approve or reject within the time frame, the workflow will cancel the notification automatically and then the notification will end up in the status CANCELED. Action In such cases, RETRY would not work instead ask the preparer to withdraw and re submit the expense report. MAIL If the notification is not SENT to the approver, the status would be MAIL. Action Ask the DBA to bounce the workflow. This would solve the problem most times. But if it doesnt i. MAIL, then RETRY the activity Request Approval from APPROVER using the Workflow Administrator responsibility demo below. If yet not sent, check the Attributes like Approvers email etc. BLANK Sometimes the value of the status would be NULL.