Wednesday, May 21, 2014

Oracle Order to Cash tables: O2C tables

Order entry
Table Name
Processing  Details
OE_ORDER_HEADERS_ALL
1 record created in header table
OE_ORDER_LINES_ALL 
Lines for particular records
OE_PRICE_ADJUSTMENTS
When discount gets applied
OE_ORDER_PRICE_ATTRIBS 
If line has price attributes then populated
OE_ORDER_HOLDS_ALL 
If any hold applied for order like credit check etc
Order Booked
OE_ORDER_HEADERS_ALL 
Booked_Flag=Y, Order booked.
WSH_DELIVERY_DETAILS 
Status Opened
WSH_DELIVERY_ASSIGNMENTS 
WSH_DELIVERY_ASSIGNMENTS.delivery_id will be NULL as still pick release operation is not performed as final delivery is not yet created.
MTL_DEMAND.
‘Demand interface program’ is triggered in the background and demand of the item with specified quantity is created 
Order Scheduled/Reserved
This step is required for doing reservations SCHEDULE ORDER PROGRAM runs in the background(if scheduled) and quantities are reserved. 
OE_ORDER_LINES_ALL 
Awaiting Shipping
MTL_RESERVATIONS
This is only soft reservations. No physical movement of stock
WSH_DELIVERY_DETAILS 
R: Ready to Release: Line is ready to be released
Pick Released
Pick Release is the process of putting reservation on on-hand quantity available in the inventory and pick them for particular sales order.
OE_ORDER_LINES_ALL 
WSH_DELIVERY_DETAILS 
S: Released to Warehouse
WSH_NEW_DELIVERIES 
A new record is created in WSH_NEW_DELIVERIES with status_code = ‘OP’ (Open). WSH_NEW_DELIVERIES has the delivery records.
WSH_DELIVERY_ASSIGNMENTS 
Deliveries get assigned
WSH_PICKING_BATCHES 
After batch is created for pick release
MTL_TXN_REQUEST_HEADERS
A move order is created in Pick Release process which is used to pick and move the goods to staging area (here move order is just created but not transacted). MTL_TXN_REQUEST_HEADERS, MTL_TXN_REQUEST_LINES  are move order tables
MTL_TXN_REQUEST_LINES
move order line
Pick Confirm
Pick Confirm is to transact the move order created in Pick Release process
OE_ORDER_LINES_ALL
flow_status_code =’PICKED’
MTL_MATERIAL_TRANSACTIONS_TEMP
 (Record gets deleted from here and gets posted to MTL_MATERIAL_TRANSACTIONS)
MTL_MATERIAL_TRANSACTIONS
MTL_MATERIAL_TRANSACTIONS is updated with Sales Order Pick Transaciton
MTL_TRANSACTION_ACCOUNTS
updated with accounting information for mtl_material Transactions
WSH_DELIVERY_DETAILS 
Y: Staged- Line has been picked and staged by Inventory
MTL_ONHAND_QUANTITIES
Ship Confirmed
The goods are picked from staging area and given to shipping. “Interface Trip Stop” program runs in the backend.
OE_ORDER_LINES_ALL
.flow_status_code =‘SHIPPED’ Shipped_Quantity get populated
WSH_DELIVERY_DETAILS 
Released_Status=C ;Shipped ;Delivery Note get printed Delivery assigned to trip stop quantity will be decreased 
MTL_TRANSACTIONS_INTERFACE
Data from MTL_TRANSACTIONS_INTERFACE is moved to MTL_MATERIAL_TRANACTIONS
MTL_MATERIAL_TRANSACTIONS
updated with Sales Order Issue transaction
WSH_NEW_DELIVERIES 
If Defer Interface is checked then OM & inventory not updated. If Defer Interface is not checked: Shipped
OE_ORDER_LINES_ALL 
WSH_DELIVERY_LEGS 
1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.
OE_ORDER_HEADERS_ALL 
If all the lines get shipped then only flag N
WSH_NEW_DELIVERIES
Data Deleted
MTL_RESERVATIONS
Data Deleted
MTL_DEMAND
Data Deleted
MTL_ONHAND_QUANTITIES
Item deducted from MTL_ONHAND_QUANTITIES
MTL_TRANSACTION_ACCOUNTS 
updated with accounting information.
WSH_TRIPS
WSH_TRIP_STOPS
Auto Invoice
After shipping the order the order lines gets eligible to get transfered to RA_INTERFACE_LINES_ALL. Workflow background engine picks those records and post it to RA_INTERFACE_LINES_ALL. 
OE_ORDER_LINES_ALL
invoice_interface_status_code = ‘YES’
WSH_DELIVERY_DETAILS 
Released_Status=I 
RA_INTERFACE_LINES_ALL 
Data will be populated after work flow process.
RA_CUSTOMER_TRX_ALL 
After running Auto Invoice Master Program for
RA_CUSTOMER_TRX_LINES_ALL 
Specific batch transaction tables get populated
Close Order
Last step of the process is to close the order which happens automatically once the goods are shipped
OE_ORDER_LINES_ALL
flow_status_code =’CLOSED’ and open_flag = ‘N’

What are Oracle API's and How to find APIs of Oracle Modules?

Generally developers will be in need of APIs to add/modify data on existing tables but its a bit difficult task to find out APIs
What is an API?
An application programming interface (API) is a source code based specification intended to be used as an interface by software components to communicate with each other. Even ever a data is entered on an Oracle Form, the data will be picked up by the corresponding APIs, validated and inserted into respective predefined tables by taking processing constraints into consideration.
Types of Oracle APIs
§  Private APIs: Private APIs are for internal, development use only. Details are not provided to anyone outside of the immediate development environment, nor are they intended for use by anyone outside of the e-Business Suite development environment.
§  Public APIs: Public APIs are designed for customers and Oracle consultants to integrate non-Oracle systems into Oracle e-Business Suite or to extend the functionality of the base products. Oracle does not support public APIs unless they are published in a reference manual such as this one. The user accepts all risk and responsibility for working with non-published public APIs.
§  Public, published APIs: Public Published APIs are guaranteed by Oracle to remain valid from release to release and that patches will not alter the API behavior. Public, published APIs are supported by Oracle to the same extent as released software. For non-published APIs, Oracle expressly does not provide any guarantees regarding consistency of naming, usage, or behavior of any API (public or private) between releases. It is also possible that a patch could alter any characteristic of any non-published e-Business Suite API. As such, those who choose to use these APIs do so at their own risk. However, Oracle does attempt to minimize all changes to public APIs, even if not published.



For more Information refer to 


How to find APIs?

Its difficult for a developer to find out APIs from DBA_OBJECTS table, so Oracle Corp. has come up with a web portal named Oracle Integration Repository (iRep) to access all public APIs.

Oracle® Integration Repository

Oracle Integration Repository is a compilation of information about the numerous interface endpoints exposed by Oracle applications. The full list of public APIs and the purpose of each API is available in the integration repository. It provides a complete catalog of Oracle E-Business Suite’s business interfaces, and a comprehensive view of the interface mechanisms available. You can use this tool to easily discover and deploy the appropriate business interface from the catalog for integration with any system, application, or business partner.

elease 12 Integration Repository

In Oracle EBS R12, Integration Repository is bundled as a part of EBS suite as a responsibility “Integrated SOA Gateway”.

Where are these APIs Stored?
Each API is placed in a file with extension as ‘pls’(pl/sql source code file). These pls files are stored in Unix box in the following path
$APPLICATION_TOP/patch/115/sql/
Query to find APIs
You can use the below query to find out the APIs to some extent

SELECT SUBSTR(a.OWNER,1,20) ,
  SUBSTR(a.NAME,1,30)        ,
  SUBSTR(a.TYPE,1,20)        ,
  SUBSTR(u.STATUS,1,10) Stat ,
  u.last_ddl_time            ,
  SUBSTR(text,1,80) Description
   FROM dba_source a,
  dba_objects u
  WHERE 2         =2
AND u.object_name = a.name
AND a.text LIKE '%Header%'
AND a.TYPE = u.object_type
AND a.name LIKE 'PA_%API%'
ORDER BY a.owner,
  a.name;



How to find error message comming in oracle API's
After the calling of API give the following

IF (fnd_msg_pub.count_msg > 0)THEN
FOR i IN 1..fnd_msg_pub.count_msg
LOOP

fnd_msg_pub.get
( p_msg_index => i,
p_encoded => 'F',
p_data => x_msg_data,
p_msg_index_out => X_msg_count
);

DBMS_OUTPUT.PUT_LINE('API ERROR: ' || x_msg_data);
END LOOP;
dbms_output.put_line(x_jtf_note_id ||'--'|| x_return_status ||'--'|| X_msg_count ||'--'|| x_msg_data);
ELSE
DBMS_OUTPUT.PUT_LINE('Updated sr : ' || to_char(ChildIncId));
End if;

Here PA is application short name of Project Accounting application


Also refer to article on Oracle application API's  published in the month of OCT 2013 in this blog


API  Internal Name
API Usage
AHL_DI_DOC_INDEX_PUB
Document
AHL_DI_DOC_REVISION_PUB
Document Revision
AHL_DI_SUBSCRIPTION_PUB
Document Subscription
AHL_FMP_MR_PUB
Maintenance Requirement
AHL_MC_ITEM_COMP_PUB
Master Configuration
AHL_MC_ITEMGROUP_PUB
Item Group Association
AHL_MC_MASTERCONFIG_PUB
Master Configuration
AHL_MC_NODE_PUB
Master Configuration
AHL_OSP_ORDERS_PUB
Process OSP Order
AHL_OSP_SHIPMENT_PUB
Process OSP Shipment
AHL_PC_ASSOCIATION_PUB
Units/Parts Association
AHL_PC_HEADER_PUB
Product Classification Header
AHL_PC_NODE_PUB
Product Classification Nodes
AHL_RM_OPERATION_PUB
Operation
AHL_RM_ROUTE_PUB
Route
AHL_UA_FLIGHT_SCHEDULES_PUB
Unit Flight Schedules
AHL_UC_INSTANCE_PUB
Unit Configuration Node
AHL_UC_UNITCONFIG_PUB
Unit Configuration Header
AHL_UC_UTILIZATION_PUB
Unit Configuration Utilization
AHL_UC_VALIDATION_PUB
Unit Configuration Validation
AHL_UMP_UF_PUB
Utilization Forecast
AHL_UMP_UNITMAINT_PUB
Maintain Unit Maintenance Plan Schedule
AME_API
Approval Process
AME_API2
Parallel Approval Process
AME_API3
Ancillary Parallel Approvers Process
AME_API4
Approval Process Groups
AML_SALES_LEADS_V2_PUB
Oracle Leads Management Public Wrapper API
AMS_ACTMETRIC_PUB
Oracle Marketing Activity Metrics Public API
AMS_CAMP_SCHEDULE_PUB
Oracle Marketing Campaign Schedules Public API
AMS_CAMPAIGN_PUB
Oracle Marketing Campaigns Public API
AMS_METRIC_PUB
Oracle Marketing Metrics Definition Public API
AP_PO_VENDORS_APIS_PKG
Suppliers Package
AR_ADJUST_PUB
Adjustment
AR_BR_CANCEL_UNPAID_API_PUB
Unpaid Bill
AR_BR_REMIT_IMPORT_API_PUB
Remittance Import
AR_CMGT_CREDIT_REQUEST_API
Credit Request Creation
AR_CREDIT_MEMO_API_PUB
Credit Memo Approval and Creation
AR_DEPOSIT_API_PUB
Deposit
AR_INVOICE_API_PUB
Invoice Creation
AR_PREPAYMENTS_PUB
Prepayment
AR_RECEIPT_API_PUB
Receipt
AR_REVENUEADJUST_PUB
Revenue Adjustment
AS_SALES_LEADS_PUB
Oracle Leads Management Public API
BEN_CWB_AUDIT_API
Compensation Workbench Audit Log
BEN_CWB_PERSON_GROUPS_API
Compensation Workbench Budget Detail
BEN_CWB_PERSON_INFO_API
Compensation Workbench Person Information
BEN_CWB_PERSON_RATES_API
Compensation Workbench Person Award
BEN_CWB_PERSON_TASKS_API
Compensation Workbench Person Task
BEN_CWB_PL_DSGN_API
Compensation Workbench Plan Design
BEN_CWB_STOCK_OPTN_DTLS_API
Compensation Workbench Stock Option
BOM_IMPORT_PUB
Structure Import
BOM_INVOKE_BO
Invoke Business Object
BOM_OE_EXPLODER_PKG
Order Entry Exploder
BOM_SECURITY_PUB
BOM Security Policy Package
BOMCUMYD
Cumulative Yield calculation for Flow and Network Routing
BOMPCCLT
Lead Time Rollup calculation
BOMPEXPL
Structure Exploder
BOMPIMPL
Implode BOM Package
BOMPXINQ
Structure Export
CDR_PUB_API_INITIALIZATION
LSH API Initialization
CDR_PUB_ATK_ADAPTER
LSH ATK ADAPTER
CDR_PUB_CLA_HIERARCHY_VALS
LSH CLA HIER Values
CDR_PUB_CLA_OBJ_CLASSIFICATION
LSH Obj Classification
CDR_PUB_CLA_SUBTYPES
Subtype Classification
CDR_PUB_DEF_CONSTANTS
LSH Definition Constants
CDR_PUB_DEF_FACTORY_SUPPORT
LSH Factory Support
CDR_PUB_DEF_FACTORY_UTILS
LSH Factory Utility
CDR_PUB_DEF_FACTORY_VALIDATE
LSH Factory Validate
CDR_PUB_DF_APPLICATIONAREA
LSH Application Areas
CDR_PUB_DF_BUSINESSAREA
Business Area
CDR_PUB_DF_BUSINESSAREA_HIER
Business Area Hierarchies
CDR_PUB_DF_BUSINESSAREA_JOIN
Business Area Join
CDR_PUB_DF_DATAMART
Data Marts
CDR_PUB_DF_DOMAIN
LSH Domain
CDR_PUB_DF_EXECUTIONSETUP
LSH Execution Setup
CDR_PUB_DF_LOADSET
Load Sets
CDR_PUB_DF_MAPPING
LSH Mapping
CDR_PUB_DF_NAMING
LSH Namings
CDR_PUB_DF_NAMING_UTIL
LSH Naming
CDR_PUB_DF_NOTIFICATIONS
LSH Notifications
CDR_PUB_DF_OWNERSHIP
LSH OwnerShip
CDR_PUB_DF_PARAM_RELATION
LSH Parameter Relations
CDR_PUB_DF_PARAMETER
LSH Parameters
CDR_PUB_DF_PARAMETER_SET
LSH Parameter Sets
CDR_PUB_DF_PLANNED_OUTPUT
LSH Planned Output
CDR_PUB_DF_PROGRAM
LSH Program
CDR_PUB_DF_SOURCECODE
LSH Source Code
CDR_PUB_DF_TABLE
LSH Table Creation
CDR_PUB_DF_VARIABLE
LSH Variable
CDR_PUB_DF_WORKAREA
Work Areas/Check In Work Area
CDR_PUB_DF_WORKFLOW
LSH Workflow
CDR_PUB_EXE_EXTERNAL
LSH External
CDR_PUB_EXE_MSG_API
LSH Msg Submission
CDR_PUB_EXE_RUNTIME
LSH Runtime
CDR_PUB_EXE_SUBMISSION
LSH Submission
CDR_PUB_EXE_USER_UTILS
LSH User Utils
CDR_PUB_MSG_PUB
LSH Read Message
CDR_PUB_PRINT_OUTPUT
LSH Print Output
CDR_PUB_RS_OTD_FILE
LSH OTD Files
CDR_PUB_RS_OVERLAY_TEMPLATE
LSH Report Set Overlay Template
CDR_PUB_RS_REPORT_SET
LSH Report Sets
CDR_PUB_RS_REPORT_SET_ENTRY
LSH Report Set Entry
CDR_PUB_SECURITY_PKG
LSH Security
CDR_PUB_VL_VALIDATION
LSH Validation
CN_CALC_SUBMISSION_PUB
Create/Update Calculation Submission Batch
CN_COMMISSION_CALC_PUB
Calculate Projected Compensation Public Application Program Interface
CN_COMP_PLAN_PUB
Create Compensation Plan
CN_GET_TX_DATA_PUB
Mass Adjustments
CN_MULTI_RATE_SCHEDULES_PUB
Rate Tables Public Application Program Interface
CN_PAYGROUP_PUB
Pay Group
CN_PLAN_ELEMENT_PUB
Plan Element
CN_PMTPLAN_PUB
Payment Plan
CN_PMTSUB_PUB
Submit Payrun Concurrent Programs
CN_POST_COLLECTION_TAE_PUB
OIC Integration With TA Engine Public Application Program Interface
CN_PRD_QUOTA_PUB
Period Quotas distribution
CN_PROCESS_TAE_TRX_PUB
Populate TAE Data in OIC Public Application Program Interface
CN_ROLE_PLANS_PUB
Role to Compensation Plan Assignment
CN_SCA_CREDITS_BATCH_PUB
Get Sales Credits Public Application Program Interface
CN_SCA_CREDITS_ONLINE_PUB
Get Sales Credits Public Application Program Interface(Online)
CN_SCA_WF_CUST_PKG
Workflow Process custom Revenue Distribution
CN_SCA_WF_PKG
Workflow processes for Revenue Distribution and Transaction Transfer
CN_SRP_CUSTOMIZE_PUB
Salesperson Customization
CN_SRP_PAYGROUP_PUB
Assign Pay Groups
CN_SRP_PMT_PLANS_PUB
Assign Payment Plans
CN_SRP_PRD_QUOTA_PUB
Salesperson Period Quotas Distribution
CS_CHARGE_CREATE_ORDER_PUB
Charges
CS_CHARGE_DETAILS_PUB
Service Charges
CS_INCIDENTLINKS_PUB
Service Request Link
CS_MULTIORG_PUB
Service Charges
CS_SERVICEREQUEST_PUB
Service Request
CSD_REPAIRS_PUB
Depot Repair APIs
CSF_DEBRIEF_PUB
Debrief
CSI_II_RELATIONSHIPS_PUB
Manage Instance-to-Instance Relationships
CSI_ITEM_INSTANCE_PUB
Manage Item Instances
CSI_SYSTEMS_PUB
Manage Systems
CST_COST_API
Item Cost API
CZ_CF_API
Configuration API
CZ_MODELOPERATIONS_PUB
Model Operations API
EAM_ACTIVITYSUPN_PUB
Activity Suppression
EAM_ASSET_AREAS_PUB
Asset Areas
EAM_ASSET_ROUTES_PUB
Asset Routes
EAM_ASSETATTR_GRP_PUB
Asset Group and Attributes Group Association
EAM_ASSETATTR_VALUE_PUB
Asset Attributes Values
EAM_ASSETNUMBER_PUB
Asset Number
EAM_COMPLETION
Maintenance Work Completion
EAM_DEPT_APPROVERS_PUB
Department Approvers
EAM_ITEM_ACTIVITIES_PUB
Asset Activity
EAM_METER_PUB
EAM Meters
EAM_METERASSOC_PUB
Asset Meter
EAM_METERREADING_PUB
Meter Reading package
EAM_PARAMETERS_PUB
Eam Parameters
EAM_PMDEF_PUB
Preventive Maintenance Schedule
EAM_PROCESS_WO_PUB
Asset Maintenance Work Order Creation
EAM_SETNAME_PUB
Preventive Maintenance Set Name
EC_POAO_EXT
Purchase Order Acknowledgments Extension Columns API
EC_POCAO_EXT
Purchase Order Change Acknowledgments Extension Columns API
EDR_ERES_EVENT_PUB
E-records Evidence Store APIs
EDR_EVENT_RELATIONSHIP_PUB
E-records Evidence Store APIs
EDR_EVIDENCESTORE_PUB
E-records Evidence Store APIs
EDR_FILES_PUB
Upload and request approval for a file
EDR_STANDARD_PUB
Oracle E-Records Utility
EDR_TRANS_ACKN_PUB
E-records Evidence Store APIs
EGO_ITEM_PUB
Catalog Item Maintenance
EGO_USER_ATTRS_DATA_PUB
User-Defined Attributes
ENG_ECO_PUB
Create or Update Change
ERROR_HANDLER
Error Handler
FA_ADDITION_PUB
Asset Addition API
FA_ADJUSTMENT_PUB
Adjustments API
FA_ASSET_DESC_PUB
Update Asset Description API
FA_CIP_PUB
Capitalize/Reverse Capitalize API
FA_DELETION_PUB
Delete Asset API
FA_INV_XFR_PUB
Invoice Transfer API
FA_RECLASS_PUB
Reclassify Asset API
FA_RESERVE_TRANSFER_PUB
Reserve Transfer API
FA_RETIREMENT_ADJUSTMENT_PUB
Group Retirement Adjustment API
FA_RETIREMENT_PUB
Retirement/Reinstatement API
FA_REVALUATION_PUB
Revaluation API
FA_TRANSFER_PUB
Asset Transfer API
FA_UNIT_ADJ_PUB
Unit Adjustments API
FA_UNPLANNED_PUB
Unplanned Depreciation API
FND_CONC_GLOBAL
Concurrent Global package
FND_CONCURRENT
Request Set
FND_FILE
FND File
FND_FLEX_EXT
Key Flexfield Validation Public
FND_FORM_FUNCTIONS_PKG
Form Function
FND_FORM_PKG
Form
FND_GLOBAL
Application Context APIs
FND_MENU_ENTRIES_PKG
Menu Entry
FND_MENUS_PKG
Menu
FND_MESSAGE
Message Dictionary
FND_OBJECT_TABLESPACES_PUB
Customize Object Classification
FND_PROFILE
Profile Management APIs
FND_PROFILE_OPTIONS_PKG
Profile Table Handler
FND_PROGRAM
Concurrent Program Loaders
FND_REQUEST
Concurrent Request
FND_REQUEST_INFO
Request Information
FND_RESP_FUNCTIONS_PKG
Responsibility Function
FND_RESPONSIBILITY_PKG
Responsibility
FND_SECURITY_GROUPS_PKG
Security Group
FND_SET
Request Set
FND_SSO_MANAGER
SSO Manager
FND_SUBMIT
Request Set Submission
FND_TABLESPACES_PUB
Customize Tablespace Model
FND_USER_PKG
User
FND_USER_RESP_GROUPS_API
User Responsibility Group
GHR_AGENCY_APPEALS_API
Agency Appeal
GHR_ASSIGNMENT_API
Assignment
GHR_COMPLAINANT_APPEALS_API
Complainant Appeal
GHR_COMPLAINT_ADRS_API
Complaint Tracking Alternate Dispute Resolution
GHR_COMPLAINT_API
Complaint
GHR_COMPLAINT_BASES_API
Complaint Base
GHR_COMPLAINT_CLAIMS_API
Complaint Claim
GHR_COMPLAINT_INCIDENTS_API
Complaint Incident
GHR_COMPLAINT_PEOPLE_API
Complaint People
GHR_COMPLAINTS_CA_DETAILS_API
Complaint Corrective Action Detail
GHR_COMPLAINTS_CA_HEADERS_API
Complaint Corrective Action Header
GHR_DUTY_STATION_API
Duty Station
GHR_ELEMENT_API
Request for Personnel Action Element
GHR_NOAC_LAS_API
Nature of Action / Legal Authority Code Combination
GHR_NOAC_REMARKS_API
Nature of Action Code /Remark combination
GHR_PA_REMARKS_API
Request for Personnel Action Remark
GHR_PAR_EXTRA_INFO_API
Request for Personnel Action Extra Information
GHR_PDC_API
Position Description Classification
GHR_PDI_API
Position Description
GHR_PERSON_ADDRESS_API
Person Address
GHR_POSNDT_API
Position DateTrack
GHR_SF52_API
Request for Personnel Action
GL_JOURNAL_IMPORT_PKG
Journal Import Functions
GMD_ACTIVITIES_PUB
Activities API
GMD_FETCH_VALIDITY_RULES
Validity Rules Fetch package
GMD_FORMULA_DETAIL_PUB
Formula Details API
GMD_FORMULA_PUB
Formula Header API
GMD_OPERATION_ACTIVITIES_PUB
Operation Activities API
GMD_OPERATION_RESOURCES_PUB
Operation Resources API
GMD_OPERATIONS_PUB
Operation Header API
GMD_OUTBOUND_APIS_PUB
Public level outbound GMD Quality API package
GMD_QC_TESTS_PUB
Quality Tests package
GMD_RECIPE_DETAIL
Recipe Details API
GMD_RECIPE_FETCH_PUB
OUTBOUND:Recipe API
GMD_RECIPE_HEADER
Recipe Header API
GMD_RESULTS_PUB
GMD Results Package
GMD_ROUTING_STEPS_PUB
Routing Steps API
GMD_ROUTINGS_PUB
Routings Header API
GMD_SAMPLES_PUB
GMD Samples Package
GMD_SPEC_PUB
Quality Specifications package
GMD_SPEC_VRS_PUB
QC Spec Validity Rules package
GMD_STATUS_PUB
GMD-NPD Change Status API
GME_API_PUB
Process Execution Public API's
GMF_ALLOCATIONDEFINITION_PUB
GMF Allocation Definitions API
GMF_BURDENDETAILS_PUB
GMF Burden Details API
GMF_ITEMCOST_PUB
GMF Item Cost API
GMF_RESOURCECOST_PUB
GMF Resource Cost API
GMI_OM_ALLOC_API_PUB
GMI Allocate OPM Orders API
GMI_PICK_CONFIRM_PUB
GMI Pick Confirm OPM Orders API
GMIPAPI
GMI Inventory API
GMP_CALENDAR_API
GMP_CALENDAR_API
GMP_RESOURCE_DTL_PUB
GMP_RESOURCE_DTL_PUB
GMP_RESOURCES_PUB
GMP_RESOURCES_PUB
GMP_RSRC_AVL_PKG
GMP_RSRC_AVL_PKG
HR_ABSENCE_TYPE_API
Absence Attendance Type
HR_ACCRUAL_PLAN_API
Accrual Plan
HR_API_HOOK_CALL_API
API Hook Call
HR_APPLICANT_API
Applicant
HR_APPLICATION_API
Application
HR_APPRAISAL_TEMPLATES_API
Appraisal Template
HR_APPRAISALS_API
Appraisal
HR_ASG_BUDGET_VALUE_API
Assignment Budget Value
HR_ASSESSMENT_GROUPS_API
Assessment Group
HR_ASSESSMENT_TYPES_API
Assessment Type
HR_ASSESSMENTS_API
Assessment
HR_ASSIGNMENT_API
Assignment
HR_ASSIGNMENT_EXTRA_INFO_API
Assignment Extra Information
HR_AU_APPLICANT_API
Applicant for Australia
HR_AU_ASSIGNMENT_API
Assignment for Australia
HR_AU_EMPLOYEE_API
Employee for Australia
HR_AU_PERSON_API
Person for Australia
HR_AU_PERSONAL_PAY_METHOD_API
Personal Payment Method for Australia
HR_AU_SUPER_API
Superannuation Contribution for Australia
HR_AU_TAX_API
Tax for Australia
HR_AUTHORIA_MAPPING_API
Authoria Mapping
HR_BATCH_MESSAGE_LINE_API
Batch Message Line
HR_BE_CONTRACT_API
Employment Contract for Belgium
HR_BE_EMPLOYEE_API
Employee for Belgium
HR_CA_APPLICANT_API
Applicant for Canada
HR_CA_ASSIGNMENT_API
Assignment for Canada
HR_CA_EMPLOYEE_API
Employee for Canada
HR_CAGR_ENT_ITEM_API
Collective Agreement Entitlement Item
HR_CAGR_ENT_LINES_API
Collective Agreement Entitlement Line
HR_CAGR_ENTITLEMENT_API
Collective Agreement Entitlement
HR_CAGR_GRADE_STRUCTURES_API
Collective Agreement Grade Structure
HR_CAGR_GRADES_API
Collective Agreement Grade
HR_CAGR_PARAMETER_API
Collective Agreement Parameter
HR_CANCEL_HIRE_API
Cancel Hire
HR_CANCEL_PLACEMENT_API
Cancel Placement
HR_CHANGE_START_DATE_API
Change Start Date
HR_CN_APPLICANT_API
Applicant for China
HR_CN_ASSIGNMENT_API
Assignment for China
HR_CN_CONTACT_API
Personal Contact for China
HR_CN_EMPLOYEE_API
Employee for China
HR_CN_PERSON_ADDRESS_API
Person Address for China
HR_CN_PERSON_API
Person for China
HR_CN_PERSONAL_PAY_METHOD_API
Personal Payment Method for China
HR_COLLECTIVE_AGREEMENT_API
Collective Agreement
HR_COMP_ELEMENT_OUTCOME_API
Competence Element Outcome
HR_COMPETENCE_ELEMENT_API
Competence Element
HR_COMPETENCE_OUTCOME_API
Competence Outcome
HR_COMPETENCES_API
Competence
HR_CONTACT_API
Personal Contact
HR_CONTACT_EXTRA_INFO_API
Contact Extra Information
HR_CONTACT_REL_API
Contact Relationship
HR_CONTINGENT_WORKER_API
Contingent Worker
HR_CONTRACT_API
Employment Contract
HR_DE_ASSIGNMENT_API
Assignment for Germany
HR_DE_EMPLOYEE_API
Employee for Germany
HR_DE_LIABILITY_PREMIUMS_API
Liability Premium for Germany
HR_DE_ORGANIZATION_LINKS_API
Organization Link for Germany
HR_DE_SOC_INS_CLE_API
Social Insurance Contribution
HR_DELIVERY_METHODS_API
Delivery Method
HR_DEPLOYMENT_FACTOR_API
Deployment Factor
HR_DK_APPLICANT_API
Applicant for Denmark
HR_DK_ASSIGNMENT_API
Assignment for Denmark
HR_DK_CONTACT_API
Contact for Denmark
HR_DK_CONTINGENT_WORKER_API
Contingent Worker for Denmark
HR_DK_EMPLOYEE_API
Employee For Denmark
HR_DK_PERSON_API
Person for Denmark
HR_ELC_CANDIDATE_API
Election Candidate
HR_ELC_CONSTITUENCYS_API
Election constituency
HR_ELC_RESULT_API
Election Result
HR_ELECTIONS_API
Election
HR_EMPLOYEE_API
Employee
HR_EMPLOYEE_APPLICANT_API
Employee Applicant
HR_ES_APPLICANT_API
Applicant for Spain
HR_ES_CONTACT_API
Personal Contact for Spain
HR_ES_CONTINGENT_WORKER_API
Contingent Worker for Spain
HR_ES_EMPLOYEE_API
Employee for Spain
HR_ES_PERSON_API
Update Person for Spain
HR_EX_EMPLOYEE_API
Ex-Employee
HR_FI_APPLICANT_API
Applicant for Finland
HR_FI_ASSIGNMENT_API
Assignment for Finland
HR_FI_CONTACT_API
Contact for Finland
HR_FI_CONTINGENT_WORKER_API
Contingent Worker for Finland
HR_FI_EMPLOYEE_API
Employee for Finland
HR_FI_PERSON_API
Person for Finland
HR_FI_PREVIOUS_EMPLOYMENT_API
Previous Employment for Finland
HR_FI_QUALIFICATION_API
Qualification for Finland
HR_FR_APPLICANT_API
Applicant for France
HR_FR_ASSIGNMENT_API
Assignment for France
HR_FR_CONTRACT_API
Employment Contract for France
HR_FR_EMPLOYEE_API
Employee for France
HR_FR_JOB_API
Job for France
HR_FR_PERIODS_OF_SERVICE_API
Periods of Service for France
HR_FR_PERS_PAY_METHOD_API
Personal Payment Method for France
HR_FR_PERSON_ADDRESS_API
Person Address for France
HR_FR_PERSON_API
Person for France
HR_FR_PQH_EMPLOYEE_API
Employee for Public Sector France
HR_GRADE_API
Grade
HR_GRADE_RATE_VALUE_API
Grade Rate Value
HR_GRADE_SCALE_API
Grade Scale
HR_GRADE_STEP_API
Grade Step
HR_HIERARCHY_ELEMENT_API
Organization Hierarchy Element
HR_HK_APPLICANT_API
Applicant for Hong Kong
HR_HK_ASSIGNMENT_API
Assignment for Hong Kong
HR_HK_EMPLOYEE_API
Employee for Hong Kong
HR_HK_PERSON_ADDRESS_API
Person Address for Hong Kong
HR_HK_PERSON_API
Person for Hong Kong
HR_HK_PERSONAL_PAY_METHOD_API
Personal Payment Method for Hong Kong
HR_HU_APPLICANT_API
Applicant for Hungary
HR_HU_CONTACT_API
Personal Contact for Hungary
HR_HU_CONTINGENT_WORKER_API
Contingent Worker for Hungary
HR_HU_EMPLOYEE_API
Employee for Hungary
HR_HU_PERSON_API
Update Person for Hungary
HR_IN_ASSIGNMENT_API
Assignment for India
HR_IN_CONTACT_EXTRA_INFO_API
Contact Extra Information for India
HR_IN_CONTACT_REL_API
Contact Relationship for India
HR_IN_CONTINGENT_WORKER_API
Contingent Worker for India
HR_IN_EMPLOYEE_API
Employee for India
HR_IN_LOCATION_API
Location for India
HR_IN_PERSON_ADDRESS_API
Person Address for India
HR_IN_PERSON_API
Person for India
HR_IN_PERSON_EXTRA_INFO_API
Person Extra Information for India
HR_IN_PERSONAL_PAY_METHOD_API
Personal Payment Method for India
HR_IT_EMPLOYEE_API
Employee for Italy
HR_JOB_API
Job
HR_JOB_REQUIREMENT_API
Job Requirement
HR_JP_PERSON_API
Person for Japan
HR_JPBP_API
Business Process for Japan
HR_KI_HIERARCHIES_API
Knowledge Integration Hierarchy
HR_KI_INTEGRATIONS_API
Knowledge Integration
HR_KI_OPTION_TYPES_API
Knowledge Integration Option Type
HR_KI_OPTIONS_API
Knowledge Integration Option
HR_KI_TOPIC_INTEGRATIONS_API
Knowledge Integration – Topic Integration
HR_KI_TOPICS_API
Knowledge Integration -Topic
HR_KI_USER_INTERFACES_API
Knowledge Integration User Interface
HR_KW_APPLICANT_API
Applicant for Kuwait
HR_KW_CONTACT_API
Contact for Kuwait
HR_KW_CONTINGENT_WORKER_API
Contingent Worker for Kuwait
HR_KW_CONTRACT_API
Contract for Kuwait
HR_KW_EMPLOYEE_API
Employee for Kuwait
HR_KW_PERSON_API
Person for Kuwait
HR_KW_PREVIOUS_EMPLOYMENT_API
Previous Employment for Kuwait
HR_LOCATION_API
Location
HR_LOCATION_EXTRA_INFO_API
Location Extra Information
HR_MAINTAIN_PROPOSAL_API
Maintain Proposal
HR_MX_APPLICANT_API
Applicant for Mexico
HR_MX_ASSIGNMENT_API
Assignment for Mexico
HR_MX_CONTACT_API
Personal Contact for Mexico
HR_MX_CONTACT_REL_API
Contact Relationship for Mexico
HR_MX_CONTINGENT_WORKER_API
Contingent Worker for Mexico
HR_MX_EMPLOYEE_API
Employee for Mexico
HR_MX_EMPLOYEE_APPLICANT_API
Employee Applicant for Mexico
HR_MX_EX_EMPLOYEE_API
Ex-Employee for Mexico
HR_MX_PERSON_ABSENCE_API
Person Absence for Mexico
HR_MX_PERSON_API
Person for Mexico
HR_MX_PERSONAL_PAY_METHOD_API
Personal Payment Method for Mexico
HR_NL_ABSENCE_ACTION_API
Absence Action for Netherlands
HR_NL_ASSIGNMENT_API
Assignment for Netherlands
HR_NL_EMPLOYEE_API
Employee for Netherlands
HR_NO_APPLICANT_API
Applicant for Norway
HR_NO_ASSIGNMENT_API
Assignment for Norway
HR_NO_CONTACT_API
Contact for Norway
HR_NO_CONTINGENT_WORKER_API
Contingent Worker for Norway
HR_NO_CONTRACT_API
Contract for Norway
HR_NO_EMPLOYEE_API
Employee for Norway
HR_NO_JOB_API
Create Job for Norway
HR_NO_PERSON_API
Person APIs for Norway
HR_NO_QUALIFICATION_API
Qualification APIs for Norway.
HR_NO_QUALIFICATION_TYPE_API
Qualification Type for Norway
HR_NZ_APPLICANT_API
Applicant for New Zealand
HR_NZ_ASSIGNMENT_API
Assignment for New Zealand
HR_NZ_EMPLOYEE_API
Employee for New Zealand
HR_NZ_PERSON_ADDRESS_API
Person Address for New Zealand
HR_NZ_PERSON_API
Person for New Zealand
HR_NZ_PERSONAL_PAY_METHOD_API
Personal Payment Method for New Zealand
HR_NZ_TAX_API
Tax for New Zealand
HR_OBJECTIVES_API
Objective
HR_ORGANIZATION_API
Organization
HR_PARTICIPANTS_API
Participant
HR_PAY_SCALE_API
Scale
HR_PAY_SCALE_VALUE_API
Scale Rate Value
HR_PERF_REVIEW_API
Performance Review
HR_PERFORMANCE_RATINGS_API
Performance Rating
HR_PERIODS_OF_PLACEMENT_API
Period of Placement
HR_PERIODS_OF_SERVICE_API
Periods of Service
HR_PERSON_ABSENCE_API
Person Absence
HR_PERSON_ADDRESS_API
Person Address
HR_PERSON_API
Person
HR_PERSON_EXTRA_INFO_API
Person Extra Information
HR_PERSON_TYPE_USAGE_API
Person Type Usage
HR_PERSONAL_PAY_METHOD_API
Personal Payment Method
HR_PHONE_API
Phone
HR_PL_APPLICANT_API
Applicant for Poland
HR_PL_ASSIGNMENT_API
Assignment for Poland
HR_PL_CONTACT_API
Contact for Poland
HR_PL_CONTACT_REL_API
Contact Relationship for Poland
HR_PL_CONTINGENT_WORKER_API
Contingent Worker for Poland
HR_PL_EMPLOYEE_API
Employee for Poland
HR_PL_PERSON_ADDRESS_API
Personal Address for Poland
HR_PL_PERSON_API
Person for Poland
HR_PL_PERSONAL_PAY_METHOD_API
Personal Payment Method for Poland
HR_PL_PREVIOUS_EMPLOYMENT_API
Previous Employment for Poland
HR_POS_HIERARCHY_ELE_API
Position Hierarchy Element
HR_POSITION_API
Position
HR_POSITION_EXTRA_INFO_API
Position Extra Information
HR_POSITION_REQUIREMENT_API
Position Requirement
HR_PREVIOUS_EMPLOYMENT_API
Previous Employment
HR_PROGRESSION_POINT_API
Scale Point
HR_QUALIFICATION_TYPE_API
Qualification Type
HR_RATE_API
Rate
HR_RATE_VALUES_API
Rate Value
HR_RATING_LEVELS_API
Rating Level
HR_RATING_SCALES_API
Rating Scale
HR_RETAINED_RIGHTS_API
Retained Rights
HR_RU_APPLICANT_API
Applicant for Russia
HR_RU_CONTACT_API
HR contact APIs for Russia
HR_RU_CONTINGENT_WORKER_API
Contingent Worker for Russia
HR_RU_EMPLOYEE_API
Employee for Russia
HR_RU_PERSON_API
Update Person for Russia
HR_SA_APPLICANT_API
Applicant for Saudi Arabia
HR_SA_ASSIGNMENT_API
Assignment for Saudi Arabia
HR_SA_CONTACT_API
Personal Contact for Saudi Arabia
HR_SA_CONTINGENT_WORKER_API
Contingent Worker for Saudi Arabia
HR_SA_CONTRACT_API
Employment Contract for Saudi Arabia
HR_SA_EMPLOYEE_API
Employee for Saudi Arabia
HR_SA_PERIODS_OF_SERVICE_API
Period of Service for Saudi Arabia
HR_SA_PERSON_API
Person for Saudi Arabia
HR_SA_PREVIOUS_EMPLOYMENT_API
Previous Employment for Saudi Arabia
HR_SALARY_BASIS_API
Salary Basis
HR_SALARY_SURVEY_API
Salary Survey
HR_SALARY_SURVEY_LINE_API
Salary Survey Line
HR_SALARY_SURVEY_MAPPING_API
Salary Survey Mapping
HR_SG_APPLICANT_API
Applicant for Singapore
HR_SG_ASSIGNMENT_API
Assignment for Singapore
HR_SG_EMPLOYEE_API
Employee for Singapore
HR_SG_PERSON_API
Person for Singapore
HR_SG_PERSONAL_PAY_METHOD_API
Personal Payment Method for Singapore
HR_SIT_API
Special Information Type
HR_SP_PLACEMENT_API
Grade Step Placement
HR_STD_HOL_ABS_API
Standard Holiday Absence
HR_UPLOAD_PROPOSAL_API
Upload Proposal API
HR_VALID_GRADE_API
Valid Grade
HXC_RECURRING_PERIODS_API
Recurring Period
HXC_TIME_RECIPIENT_API
Time Recipient
HXC_TIME_SOURCE_API
Time Source
HXC_TIMESTORE_DEPOSIT
TimeStore Deposit
HZ_CLASSIFICATION_V2PUB
Classification
HZ_CONTACT_POINT_V2PUB
Contact Point
HZ_CONTACT_PREFERENCE_V2PUB
Contact Preference
HZ_CUST_ACCOUNT_ROLE_V2PUB
Customer Account Role
HZ_CUST_ACCOUNT_SITE_V2PUB
Customer Account Site
HZ_CUST_ACCOUNT_V2PUB
Customer Account
HZ_CUSTOMER_PROFILE_V2PUB
Customer Profile
HZ_FORMAT_PHONE_V2PUB
Format Phone
HZ_FORMAT_PUB
Name and Address Formatting
HZ_HIERARCHY_V2PUB
Hierarchy Retrieval
HZ_LOCATION_SERVICES_PUB
Location Service
HZ_LOCATION_V2PUB
Location
HZ_ORGANIZATION_INFO_V2PUB
Organization Information
HZ_ORIG_SYSTEM_REF_PUB
Source System Management
HZ_PARTY_CONTACT_V2PUB
Party Contact
HZ_PARTY_INFO_V2PUB
Credit Request Creation
HZ_PARTY_SITE_V2PUB
Party Site
HZ_PARTY_V2PUB
Party
HZ_PERSON_INFO_V2PUB
Person Information
HZ_RELATIONSHIP_TYPE_V2PUB
Relationship Type
HZ_RELATIONSHIP_V2PUB
Party Relationship
IBY_INSTRREG_PUB
Payment Instrument Registration
IBY_PAYMENT_ADAPTER_PUB
Credit Card Payment Processing
IEX_CASE_UTL_PUB
Create Update Collections Case
IEX_DISPUTE_PUB
Create Dispute
IEX_PROMISES_PUB
IEX Promises API
IEX_SCORE_PUB
Scoring API
IEX_STRATEGY_PUB
Create/Close Collections Strategy
IGC_CC_OPN_UPD_GET_LNK_PUB
Contract Commitment Operations API
IGF_SE_PAYMENT_PUB
Create payment
IGF_SP_ASSIGN_PUB
Import Sponsorship Relationships
IGS_ADMAPPLICATION_PUB
Admission Application
IGS_AS_SUAO_LGCY_PUB
Import Legacy Unit Outcome
IGS_AS_SUARC_LGCY_PUB
Import Legacy Student Unit Attempt Reference Codes
IGS_AS_TRNCMT_LGCY_PUB
Import Legacy Transcript Comment
IGS_AV_LVL_LGCY_PUB
Import Legacy Level Advanced Standing
IGS_AV_UNT_LGCY_PUB
Import Legacy Unit Advanced Standing
IGS_EN_SPA_LGCY_PUB
Import Legacy Student Program Attempt
IGS_EN_SPAT_LGCY_PUB
Import Legacy Student Term Record
IGS_EN_SPI_LGCY_PUB
Import Legacy Intermission
IGS_EN_SPAA_LGCY_PUB
Import Legacy Award Aim
IGS_EN_SUA_LGCY_PUB
Import Legacy Student Unit Attempt
IGS_EN_SUSA_LGCY_PUB
Import Legacy Student Unit Set Attempt
IGS_FI_CREDITS_API_PUB
Import Credits
IGS_FI_WAIVERS_API_PUB
Import Manual Waivers
IGS_GR_GRD_LGCY_PUB
Import Legacy Graduand
IGS_HE_SPA_LGCY_PUB
Import Legacy Student Program Attempt HESA Detail
IGS_HE_SUSA_LGCY_PUB
Import Legacy Student Unit Set Attempt HESA Detail
IGS_PR_CLSRNK_LGCY_PUB
Import Legacy Class Rank
IGS_PR_PROUT_LGCY_PUB
Import Legacy Progression Outcome
IGS_PRECREATE_APPL_PUB
Pre-Create Admission Application
IGS_PS_GENERIC_PUB
Program Structure and Planning Import
IGS_PS_SCH_INT_API_PUB
Import Schedule
IGS_RATINGS_PUB
Assign Review Groups and Evaluators
IGS_RE_SPRVSR_LGCY_PUB
Import Legacy Research Supervisor
IGS_RE_THE_LGCY_PUB
Import Legacy Research Thesis
INV_ITEM_CATEGORY_PUB
Category Maintainence
INV_KANBAN_PUB
Kanban Replenishment
INV_LABEL
Label Printing request for WMS/MSCA
INV_LOC_WMS_PUB
Locator Maintenance API
INV_LOT_API_PUB
Lot Number API
INV_MGD_MVT_STATS_PUB
Movement Statistics
INV_MOVE_ORDER_PUB
Move Order API
INV_PICK_RELEASE_PUB
Inter-company transaction flow
INV_QUANTITY_TREE_PUB
Quantity Tree
INV_RESERVATION_PUB
Material Reservation
INV_RESERVATIONS_INTERFACE
Material Reservation Interface
INV_SALESORDER
Inventory Sales Orders
INV_SERIAL_NUMBER_PUB
Inventory Serial Number
INV_TRANSACTION_FLOW_PUB
Inter-company transaction flow
INV_TXN_MANAGER_PUB
Material Transaction
IRC_AGENCY_VACANCIES_API
Agency Vacancy
IRC_ASG_STATUS_API
Assignment Status History
IRC_DEFAULT_POSTING_API
Default Posting
IRC_DOCUMENT_API
Document
IRC_JOB_BASKET_ITEMS_API
Job Basket
IRC_NOTIFICATION_PREFS_API
Notification Preferences
IRC_PARTY_API
Party
IRC_POSTING_CONTENT_API
Posting Content
IRC_REC_TEAM_MEMBERS_API
Recruiting Team Member
IRC_RECRUITING_SITES_API
Recruiting Site
IRC_SEARCH_CRITERIA_API
Search Criteria
IRC_VACANCY_CONSIDERATIONS_API
Vacancy Consideration
IRC_VARIABLE_COMP_ELEMENT_API
Variable Compensation Element
JTF_IH_PUB
Customer Interaction Management
JTF_NOTES_PUB
Notes
JTF_RS_GROUPS_PUB
Groups API
JTF_RS_RESOURCE_PUB
Resource API
JTF_RS_SALESREPS_PUB
Salespersons API
JTF_TASK_ASSIGNMENTS_PUB
Task Assignment
JTF_TASK_REFERENCES_PUB
Task Reference
JTF_TASKS_PUB
Task Manager
JTF_TERR_ASSIGN_PUB
Get Winning Territory-Resources
JTF_TERRITORY_PUB
Create Territory and Assign Resources
JTF_TTY_GEOSOURCE_PUB
Create Geography Data
MTL_CCEOI_ACTION_PUB
Cycle Count Interface API
MYPACKAGENAME
Billing Extensions
OE_INBOUND_INT
Sales Order Services
OE_ORDER_PUB
Process Order API
OKE_IMPORT_CONTRACT_PUB
Create Project Contract
OKL_ACCOUNT_GENERATOR_PUB
Account Generator API
OKL_ACCOUNTING_PROCESS_PUB
Accounting Process API
OKL_AM_AMORTIZE_PUB
Amortize API
OKL_AM_CREATE_QUOTE_PUB
Create Termination Quote API
OKL_AM_INTEGRATION_PUB
Termination API
OKL_AM_LEASE_LOAN_TRMNT_PUB
Termination API
OKL_AM_TERMNT_QUOTE_PUB
Termination Quote API
OKL_CASH_APPL_RULES_PUB
Cash Application
OKL_CONTRACT_BOOK_PUB
Contract Booking API
OKL_CONTRACT_STATUS_PUB
Get Contract Status API
OKL_CREATE_ADJST_PUB
Lease Adjustments
OKL_CREDIT_MEMO_PUB
Credit Memo
OKL_CREDIT_PUB
Credit API
OKL_EXECUTE_FORMULA_PUB
Execute Formula API
OKL_INS_POLICIES_PUB
Insurance Policy API
OKL_INS_QUOTE_PUB
Insurance Quote
OKL_INTEREST_CALC_PUB
Interest Calculation
OKL_LTE_PLCY_WRAP_PUB
Late Policies API
OKL_MASTER_LEASE_AGREEMENT_PUB
Master Lease Agreement API
OKL_RULE_APIS_PUB
Get Contract Rules API
OKL_RULE_EXTRACT_PUB
Contract Rules API
OKL_SETUPDQUALITYS_PUB
Create Quality Association API
OKL_SETUPPDTTEMPLATES_PUB
Setup Product Templates API
OKL_SETUPPQUALITYS_PUB
Setup Product Qualities API
OKL_SETUPPQVALUES_PUB
Setup Product Quality Values API
OKL_SETUPPQYVALUES_PUB
Setup Quality Values API
OKL_SETUPPRODUCTS_PUB
Create Product API
OKL_STREAM_BILLING_PUB
Stream Billing API
OKL_VENDOR_AGREEMENT_PUB
Vendor Agreement API
OKS_CON_COVERAGE_PUB
Coverage utility procedures
OKS_ENTITLEMENTS_PUB
OKS Entitlements
OKS_OMINT_PUB
Order Integration utility procedures
OTA_ACTIVITY_CATEGORY_API
Course Category
OTA_ACTIVITY_VERSION_API
Course
OTA_ANNOUNCEMENT_API
Announcement
OTA_CATEGORY_USAGE_API
Category Usage
OTA_EVENT_API
Class
OTA_LEARNING_PATH_API
Learning Path
OTA_LP_CATEGORY_API
Learning Path Category Inclusion
OTA_LP_ENROLLMENT_API
Learning Path Enrollment
OTA_LP_MEMBER_API
Learning Path Component
OTA_LP_MEMBER_ENROLLMENT_API
Learning Path Component Enrollment
OTA_LP_SECTION_API
Learning Path Section
OTA_NHS_API
External Learning
OTA_OFFERING_API
Offering
OTA_RESOURCE_BOOKING_API
Resource Booking
OTA_RESOURCE_USAGE_API
Resource Usage
OTA_SKILL_PROVISION_API
Course Other Information
OTA_TCC_API
Cross Charge
OTA_TDB_API_INS2
Enrollment
OTA_TDB_API_UPD2
Enrollment
OTA_THG_API
General Ledger Flexfield
OTA_TMT_API
Measurement Type
OTA_TPC_API
Training Plan Cost
OTA_TPM_API
Training Plan Component
OTA_TPS_API
Training Plan
OZF_CHARGEBACK_ATTRMAP_PUB
Chargeback Attribute Mapping API
OZF_CLAIM_PUB
Claim Public API
OZF_FUNDS_PUB
Budget Public API
OZF_OFFER_PUB
Offer Public API
OZF_RESALE_PUB
Indirect Sales Data Processing Public API
PA_AGREEMENT_PUB
Create Agreement
PA_BUDGET_PUB
Create Budget
PA_CALC_OVERTIME
Overtime Calculation.
PA_CC_AP_INV_CLIENT_EXTN
internal Payables invoice Attributes Override Extension.
PA_CC_CA
Cost Accrual Identification
PA_CC_IDENT_CLIENT_EXTN
Cross Charge Processing Method Override
PA_CC_TP_CLIENT_EXTN
Transfer Price Override.
PA_CI_NUMBER_CLIENT_EXTN
Control Item Document Numbering Extension
PA_CLIENT_EXTEN_CIP_GROUPING
CIP Grouping
PA_CLIENT_EXTN_ALLOC
Create Client Extension Allocation
PA_CLIENT_EXTN_ASGMT_APPRVL
Assignment Approval Changes Extension
PA_CLIENT_EXTN_ASSET_ALLOC
Asset Allocation Basis Extension
PA_CLIENT_EXTN_ASSET_CREATION
Asset Lines Processing Extension
PA_CLIENT_EXTN_BILL_CYCLE
Client Extension Billing Cycle
PA_CLIENT_EXTN_BILLING
Labor Billing.
PA_CLIENT_EXTN_BUDGET
Budget Calculation
PA_CLIENT_EXTN_BUDGET_WF
Budget Workflow
PA_CLIENT_EXTN_BURDEN
Burden Costing
PA_CLIENT_EXTN_CAP_INT
Capitalized Interest Extension
PA_CLIENT_EXTN_CHECK_CMT
Commitment Changes
PA_CLIENT_EXTN_CIP_ACCT_OVR
CIP Account Override Extension
PA_CLIENT_EXTN_COSTING
Labor Costing.
PA_CLIENT_EXTN_DEPRN_EXP_OVR
Depreciation Account Override Extension
PA_CLIENT_EXTN_DFFTRANS
Client Extension Descriptive Flexfield Transfer
PA_CLIENT_EXTN_FUNDING_REVAL
Funding Revaluation Factor.
PA_CLIENT_EXTN_GEN_ASSET_LINES
Asset Assignment
PA_CLIENT_EXTN_INV_ACTIONS
Automatic Invoice Approve/Release
PA_CLIENT_EXTN_INV_TRANSFER
AR Transcation Type Extension
PA_CLIENT_EXTN_OUTPUT_TAX
Output Tax
PA_CLIENT_EXTN_PRE_CAP_EVENT
Capital Event Processing Extension
PA_CLIENT_EXTN_PROJ_STATUS
Project Verification.
PA_CLIENT_EXTN_PROJECT_WF
Project Workflow.
PA_CLIENT_EXTN_PTE
AutoApproval
PA_CLIENT_EXTN_RETENTION
Retention Billing.
PA_CLIENT_EXTN_STATUS
Project Status inquiry(PSI)
PA_CLIENT_EXTN_TXN
Labor Transaction.
PA_CONTROL_ITEMS_WF_CLIENT
issue and Change Workflow.
PA_COST_PLUS
Cost Plus Applications Programming Interface (API)
PA_EVENT_PUB
Project Billing Events
PA_ORG_CLIENT_EXTN
Verify Organization Change.
PA_OVERRIDE_AR_INST
Receivables installation Override.
PA_PROJECT_PUB
Project Pub
PA_PURGE_EXTN
Archive Custom Tables
PA_PURGE_EXTN_VALIDATE
Archive Project Validation
PA_REPORT_WORKFLOW_CLIENT
Project Status Report Workflow.
PA_RESOURCE_PUB
Create Resources
PA_REV_CA
Cost Accrual[Billing]
PA_SECURITY_EXTN
Project Security.
PA_TRX_IMPORT
Post-import{Transaction import}.
PA_WORKPLAN_WORKFLOW_CLIENT
Workplan Workflow.
PATCX
Transaction Control.
PAY_ACTION_INFORMATION_API
Action Information
PAY_AU_MODULE_PARAMETERS_API
Module Parameters for Australia
PAY_AU_MODULE_TYPES_API
Module Types for Australia
PAY_AU_MODULES_API
Modules for Australia
PAY_AU_PROCESS_MODULES_API
Process Modules for Australia
PAY_AU_PROCESS_PARAMETERS_API
Process Parameters for Australia
PAY_AU_PROCESSES_API
Processes for Australia
PAY_BAL_ATTRIB_DEFINITION_API
Balance Attribute Definition
PAY_BAL_ATTRIBUTE_DEFAULT_API
Balance Attribute Default
PAY_BALANCE_ADJUSTMENT_API
Balance Adjustment
PAY_BALANCE_ATTRIBUTE_API
Balance Attribute
PAY_BALANCE_CATEGORY_API
Balance Category
PAY_BALANCE_TYPES_API
Balance Type
PAY_BATCH_ELEMENT_ENTRY_API
Batch Element Entry
PAY_CA_EMP_FEDTAX_INF_API
Employee Federal Tax Information for Canada
PAY_CA_EMP_PRVTAX_INF_API
Employee Provincial Tax Information for Canada
PAY_CITY_TAX_RULE_API
City Tax Rule
PAY_CNU_API
Contribution Usage
PAY_COST_ALLOCATION_API
Cost Allocation
PAY_COUNTY_TAX_RULE_API
County Tax Rule
PAY_DATETRACKED_EVENTS_API
DateTrack Events
PAY_ELEMENT_ENTRY_API
Element Entry
PAY_ELEMENT_EXTRA_INFO_API
Element Extra Information
PAY_ELEMENT_LINK_API
Element Link
PAY_ELEMENT_TYPE_USAGE_API
Element Type Usage
PAY_ELEMENT_TYPES_API
Element Type
PAY_EVENT_GROUPS_API
Event Groups
PAY_EVENT_PROCEDURES_API
Event Procedure
PAY_EVENT_QUALIFIERS_API
Event Qualifiers
PAY_EVENT_UPDATES_API
Event Update
PAY_EVENT_VALUE_CHANGES_API
Event Value Change
PAY_FEDERAL_TAX_RULE_API
Federal Tax Rule
PAY_FORMULA_RESULT_RULE_API
Formula Result Rule
PAY_IE_PAYE_API
PAYE Detail for Ireland
PAY_IE_PRSI_API
PRSI Detail for Ireland
PAY_IN_ORG_PAYMENT_METHOD_API
Organization Payment Method for India
PAY_INPUT_VALUE_API
Input Value
PAY_ITERATIVE_RULES_API
Iterative Rule
PAY_LINK_INPUT_VALUES_API
Link Input Value
PAY_NCR_API
Net Calculation Rule
PAY_ORG_PAYMENT_METHOD_API
Organization Payment Method
PAY_PAYROLL_API
Payroll
PAY_PMED_ACCOUNTS_API
Provincial Medical Account
PAY_RUN_TYPE_API
Run Type
PAY_RUN_TYPE_ORG_METHOD_API
Run Type Organization Method
PAY_RUN_TYPE_USAGE_API
Run Type Usage
PAY_STATE_TAX_RULE_API
State Tax Rule
PAY_STATUS_PROCESSING_RULE_API
Status Processing Rule
PAY_US_TAX_API
Tax for United States
PAY_US_TAX_BALS_ADJ_API
Tax Balance Adjustment for United States
PAY_USER_COLUMN_API
User Column
PAY_USER_COLUMN_INSTANCE_API
User Column Instance
PAY_USER_ROW_API
User Row
PAY_USER_TABLE_API
User Table
PAY_WCI_ACCOUNTS_API
Worker Compensation Account for Canada
PAY_WCI_OCCUPATIONS_API
Workers Compensation Occupation
PAY_WCI_RATES_API
Worker Compensation Rate
PER_BF_BALANCE_AMOUNTS_API
Backfeed Balance Amount
PER_BF_BALANCE_TYPES_API
Backfeed Balance Type
PER_BF_PAYMENT_DETAILS_API
Backfeed Payment Detail
PER_BF_PAYROLL_RUNS_API
Backfeed Payroll Run
PER_BF_PROC_ASSIGNMENT_API
Backfeed Processed Assignment
PER_CA_PERSON_ADDRESS_API
Person Address for Canada
PER_CANCEL_APPLICATION_API
Cancel Application
PER_CHECKLIST_ITEMS_API
Checklist Item
PER_DISABILITY_API
Disability
PER_DK_WORK_INCIDENT_API
Work Incident for Denmark
PER_ESTAB_ATTENDANCES_API
Establishment Attendance
PER_EVENTS_API
Event
PER_HIERARCHY_API
Generic Hierarchy
PER_HIERARCHY_NODES_API
Generic Hierarchy Node
PER_HIERARCHY_VERSIONS_API
Generic Hierarchy Version
PER_JOB_EXTRA_INFO_API
Job Extra Information
PER_JOB_GROUP_API
Job Group
PER_KW_DISABILITY_API
Kuwait Disability APIs
PER_KW_WORK_INCIDENT_API
Work Incidents for Kuwait
PER_MEDICAL_ASSESSMENT_API
Medical Assessment
PER_MX_DISABILITY_API
Disability for Mexico
PER_MX_WORK_INCIDENT_API
Work Incident for Mexico
PER_NO_WORK_INCIDENT_API
Work Incident for Norway.
PER_ORG_STRUCTURE_VERSION_API
Organization Hierarchy Version
PER_ORGANIZATION_STRUCTURE_API
Organization Hierarchy
PER_POS_STRUCTURE_VERSION_API
Position Hierarchy Version
PER_POSITION_STRUCTURE_API
Position Hierarchy
PER_QUALIFICATIONS_API
Qualification
PER_REC_ACTIVITY_FOR_API
Recruitment Activity For
PER_RECRUITMENT_ACTIVITY_API
Recruitment Activity
PER_REQUISITIONS_API
Requisition
PER_SA_DISABILITY_API
Disability for Saudi Arabia
PER_SA_WORK_INCIDENT_API
Work Incident for Saudi Arabia
PER_SUPPLEMENTARY_ROLE_API
Supplementary Role
PER_VACANCY_API
Vacancy
PER_WORK_INCIDENT_API
Work Incident
PO_CHANGE_API1_S
Purchase Order Change APIs
PO_CUSTOM_PRICE_PUB
Purchase Order Custom Pricing APIs
PO_DOCUMENT_CONTROL_PUB
Purchase Order Document Control APIs
PQH_ACCOMMODATIONS_API
Accommodation for France
PQH_ASSIGN_ACCOMMODATIONS_API
Assign Accommodation for France
PQH_ATTRIBUTE_RANGES_API
Attribute Range
PQH_BDGT_CMMTMNT_ELMNTS_API
Budget Commitment Element
PQH_BDGT_POOL_REALLOCTIONS_API
Budget Pool Reallocation
PQH_BUDGET_DETAILS_API
Budget Detail
PQH_BUDGET_ELEMENTS_API
Budget Element
PQH_BUDGET_FUND_SRCS_API
Budget Fund Source
PQH_BUDGET_GL_FLEX_MAPS_API
Budget General Ledger Flexfield Mapping
PQH_BUDGET_PERIODS_API
Budget Periods
PQH_BUDGET_POOLS_API
Budget Pool
PQH_BUDGET_SETS_API
Budget Set
PQH_BUDGET_VERSIONS_API
Budget Version
PQH_BUDGETS_API
Budget
PQH_CORPS_DEFINITIONS_API
CORPS Definition for France
PQH_CORPS_EXTRA_INFO_API
CORPS Extra Information for France
PQH_DFLT_BUDGET_ELEMENTS_API
Default Budget Element
PQH_DFLT_BUDGET_SETS_API
Default Budget Set
PQH_DFLT_FUND_SRCS_API
Default Funding Source
PQH_FR_GLOBAL_PAYSCALE_API
Global Payscale for France
PQH_FR_STAT_SIT_RULES_API
Statutory Situation Rule for France
PQH_FR_STAT_SITUATIONS_API
Statutory Situation for France
PQH_FR_VALIDATION_EVENTS_API
Validation Event for France
PQH_FR_VALIDATION_PERIODS_API
Service Validation Period for France
PQH_FR_VALIDATIONS_API
Service Validation for France
PQH_REF_TEMPLATES_API
Reference Templates
PQH_ROLE_EXTRA_INFO_API
Role Extra Information
PQH_ROLE_TEMPLATES_API
Role Template
PQH_ROLES_API
Role
PQH_ROUTING_CATEGORIES_API
Routing Category
PQH_ROUTING_LIST_MEMBERS_API
Routing List Member
PQH_ROUTING_LISTS_API
Routing List
PQH_RULE_ATTRIBUTES_API
Rule Attribute
PQH_RULE_SETS_API
Rule Set
PQH_SITUATIONS_API
Situation for France
PQH_TEMPLATE_ATTRIBUTES_API
Template Attribute
PQH_TEMPLATES_API
Transaction Template
PQH_TRAN_CATEGORY_API
Transaction Category
PQH_TXN_CAT_ATTRIBUTES_API
Transaction Category Attribute
PQP_PCV_API
Configuration Value
PQP_SHP_API
Employment Service History
PQP_VEH_ALLOC_EXTRA_INFO_API
Vehicle Allocation Extra Information
PQP_VEH_REPOS_EXTRA_INFO_API
Vehicle Repository Extra Information
PQP_VEHICLE_ALLOCATIONS_API
Vehicle Allocation
PQP_VEHICLE_REPOSITORY_API
Vehicle Repository
PQP_AAT_API
Assignment Attribute
PSA_FUNDS_CHECKER_PKG
PSA Funds Checker
PSP_EFF_REPORT_DETAILS_API
Effort Report Detail
PY_ELEMENT_ENTRY_API
Element Entry
QA_PLANS_PUB
Collection Plan Setup
QA_SPECS_PUB
Specifications Definition
QP_CURRENCY_PUB
Multi-Currency Conversion Setup
QP_CUSTOM
Custom Pricing
QP_MODIFIERS_PUB
Modifier Setup
QP_PREQ_PUB
Price Request
QP_PRICE_FORMULA_PUB
Formula Setup
QP_PRICE_LIST_PUB
Price List Setup
QP_QUALIFIER_RULES_PUB
Qualifier Setup
QP_SECURITY
Object Security
UMX_PUB
User Management Public Interface
USER_PKG_LOT
User Defined Lot Generation API
USER_PKG_SERIAL
User Defined Serial Generation API
WF_AGENT_GROUPS_PKG
Workflow Agent Group Member
WF_AGENTS_PKG
Workflow Agent
WF_BES_CLEANUP
Workflow Control Queue Cleanup
WF_CORE
Workflow Core
WF_DIRECTORY
Workflow Directory Services
WF_ENGINE
Workflow Engine
WF_ERROR_QH
Workflow Error Queue Handler
WF_EVENT
Workflow Business Event System
WF_EVENT_FUNCTIONS_PKG
Workflow Event Functions
WF_EVENT_GROUPS_PKG
Workflow Event Group Member
WF_EVENT_OJMSTEXT_QH
Workflow JMS Text Queue Handler
WF_EVENT_QH
Workflow Event Queue Handler
WF_EVENT_SUBSCRIPTIONS_PKG
Workflow Event Subscription
WF_EVENTS_PKG
Workflow Event
WF_MAIL
Workflow Message Subsystem
WF_MAIL_UTIL
Workflow Notification Mailer Utility
WF_MONITOR
Workflow Monitor
WF_NOTIFICATION
Workflow Notification System
WF_PREF
Workflow Preference
WF_PURGE
Workflow Purge
WF_QUEUE
Workflow Queues
WF_RULE
Workflow Event Subscription Rule Function
WF_SYSTEMS_PKG
Workflow System
WF_XML
Workflow XML Message Processing Subsystem
WIP_EAM_WORKREQUEST_PUB
Work Request Import
WMS_CONTAINER_PUB
License Plate Number APIs for WMS
WMS_DEVICE_INTEGRATION_PUB
User defined Device Interfacing API for WMS
WMS_INSTALL
WMS Install
WMS_RFID_DEVICE_PUB
RFID/barcode read processing APIs for WMS
WMS_SHIPPING_TRANSACTION_PUB
Integraion object between Shipping and WMS
WSH_CONTAINER_PUB
Container
WSH_DELIVERIES_PUB
Delivery
WSH_DELIVERY_DETAILS_PUB
Delivery Line
WSH_EXCEPTIONS_PUB
Exceptions
WSH_FREIGHT_COSTS_PUB
Freight Cost
WSH_PICKING_BATCHES_PUB
Picking Batch
WSH_TRIP_STOPS_PUB
Trip Stop
WSH_TRIPS_PUB
Trip
XDP_INTERFACES_PUB
Service Fulfillment Order Processing
XNB_BILL_SUMMARIES_PKG
Create Bill Summary