Skip to main content


Showing posts from February, 2015

List of iExpenses Tables

List of iExpenses Tables  Table Name Description AP_EXPENSE_REPORT_HEADERS_ALL Expense report header information AP_EXPENSE_REPORT_LINES_ALL Expense report lines information AP_EXP_REPORT_DISTS_ALL Expense report distribution information. It contains the accounts against each expense report line. AP_CREDIT_CARD_TRXNS_ALL Table to store the corporate credit card transactions that are sent by the banks. These lines are saved as expense lines when the user creates the expense lines for credit cards AP_NOTES Table to store the comments entered by approvers and auditors     Setup tables   AP_EXPENSE_REPORTS_ALL This table contains the header level information about the expense templates AP_EXPENSE_REPORT_PARAMS_ALL This table contains the detail level information about the expense templates AP_POL_CAT_OPTIONS_ALL Table to store the policy options AP_POL_CONTEXT Table to store the policy context     AP_POL_LOCATIONS_TL Table

Key Tables in Oracle Projects.

Here is a brief description of the key tables in Oracle Projects. Table Description PA_PROJECTS_ALL It stores the highest units of work defined in Oracle Projects. PA_PROJECT_ASSETS_ALL It contains assets information defined for capital projects. PA_PROJECT_ASSIGNMENTS It stores details of all Assignments for a project. PA_PROJECT_CLASSES It contains the class codes of class categories that are used to classify projects. PA_PROJECT_ROLE_TYPES Implementation-defined responsibilities or positions assigned to employees on projects are stored here. PA_PROJECT_STATUSES It stores valid project status codes. PA_PROJECT_TYPES_ALL It stores implementation-defined project classifications that supply default information and drive some project processing. PA_TASKS It contains user-defined subdivisions of project work. PA_TASK_TYPES It stores implementation-defined classifications of task. PA_TRANSACTION_INTERFACE_ALL It is an interface table to impo

Ship-To Location Vs Deliver-To Location

Ship to Location" and "Deliver to Location" are not the same: Functionally: -           Ship to Location is the place where the Supplier is supposed to Ship. So where the goods are delivers. -           Deliver to is internally, after the Supplier has delivered, the final place where the service or the goods are delivered. Technically: Often, "Deliver To" is attached to the Requester of the original Purchase Requisition. During Auto creation of PO from Requisition, if it is not defaulted on the PO Distribution Line from the Purchase Requisition, the deliver to location has to be entered manually by the buyer in Purchase Order. -           In the Receipt Form, the location is defaulted from the PO Shipment Line level -           In the Receiving Transactions Form, the location is defaulted from the PO Distribution Level. Remark:    If the Buyer wants the Deliver to be automatically defaulted to the same v

Restrictions and conditions @ Requisition Change Order Process in iProcurement

The following is the list of the conditions and restrictions: • Buying organizations can specify whether or not the buyer should be involved in the requester change order process. This is regardless of the data (unit price, quantity, amount, need by date, start date and end date) changed by the requester on the requisition or the magnitude of the change. In cases where the buyer is not involved in the change order approval process, the system sends an FYI notification to the buyer when the change request is accepted. • Administrators can setup upper and lower tolerance limits with these attributes. So, for any change to these attributes that lie within its tolerance limits, buyer approval would not be required. • The tolerances can be defined by either % amount or absolute amount. • There is also an option to bypass buyer's approval if the PO was originally auto-created for the requisition. These controls are defined at OU level. • Administrators can defi

Oracle HRMS Employee Cost Account Related Queries

Query to finid employee with a Prticular Company CodeBased on their Cost Account (Especially when there is no Default Expense Account Defined under Purchase Order information Tab in Assignment Screen. SELECT   first_name ,         last_name FROM     per_all_people_f WHERE    person_id   IN   ( SELECT   person_id                       FROM     per_all_assignments_f                       WHERE    assignment_id   IN   ( SELECT   assignment_id                                                FROM     pay_cost_allocations_f                                                WHERE    cost_allocation_keyflex_id                                                       IN                                                       ( SELECT                                                       cost_allocation_keyflex_id                                                       FROM                                                       pay_cost_allocation_keyflex                                   

Oracle Expense Reports Approval Delay Issue when using AME

Recently I found an Issue when testing the iExpenses Approvals using AME (Especially FYI Notifications).  Whenever you create an Export Report Below the Self Approval Limit, It should be Auto Approved and change the Status to 'Pending for Payables' or 'Pending for Payment' depends on Audit Rules Configuration. But Here, Iinstead of these 2 statues, it changes to 'Pending Managerial Approval', even though we are skipping the Manager's approval as the total amount of Expense Report falls under the self approval limit of Expense Report. I Spent a lot of time to analyze this and foudn the below. on further analysis by checking the Expenses Workflow, the WAIT Node is set to 10 minutes by Default in the Standard Oracle Workflow as below - And on further analysis by checking the Expenses Workflow, the WAIT Node is set to 10 minutes by Default in the Standard Oracle Workflow as below - EXPENSES Workflow AME Request Approvals Process