Order-to-Cash flow
Overview
|
CTO – Configure to Order
PTO – Pick to Order
ATO – Assemble to Order
ATP – Available to Promise
|
Order Fulfillment models
|
1. Ship from stock
2. Make to Order
3. Internal Order
4. Configure to Order, ATO, PTO
5. Back to Back Orders
6. Drop Ship to Customer
|
Standard Order to Cash flow
|
Ordering
1. Starts with an Order Creation (Manual Entry or Order Import)
Sales Order Form or Quick Sales Order form or OrderImport process or Process Order API
Order Status:
Order Line Status: Entered or Booked
Check for the Availability and Pricing, Credit Rating
2. Invoke the Pricing Request Engine to get the Selling Price (Advanced Pricing)
3. Schedule the Order Lines
Schedule – Line : Reserves the Demand, Sets the Shipment Schedule Date
Create Supply: Sub flow paths based on the Type of the item shipped
Configurable Items – Must complete the Create Supply activity which
takes an Order Line to build cycle (WIP)
Drop Ship Items - Must complete the Create Supply activity. After the
Purchase order is raised advances to Shipping activity
Standard Shippable Items – Directly advance to Shipping activity
Ship Line: Changes the Order Line Status to Awaiting Shipment
*** Shipping Execution starts at this stage. Order Lines awaiting shipment are called Delivery Lines
4. Pick Release Sales Order Lines (Deliveries)
Delivery Lines must be ‘Ready to Release’
Auto Pack (Shipping Transactions form) or Packing Workbench form –
Release Sales Orders for Picking form or
Shipping Transactions form (Launch Pick Release action) or
Pick Release concurrent program or
Pick Release API
5. Confirm the Shipment
Delivery Lines must be ‘Staged/Pick Confirmed’
Quick Ship form
Changes the Order Line Status to Shipped
Collecting
6. If the Ship Confirm is Successful then System decrements the Inventory and updates the Sales Order Line
7. Invoke the Auto Invoice process to generate the Invoice in the Receivables System
8. Collect the Payments in AR and apply against the Invoices
Accounting
9. Receive the Statement and Reconcile the Bank Statement in Cash Management System
10. Post the Transactions to GL
|
Order Management
Overview
|
Order Creation Methods:
1. Manual through Quick Sales Orders Form or Copy existing Orders
2. Order Import Process through External Systems
3. EDI – Electronic Data Interchange through Oracle e-Commerce Gateway
Ex: Internal Purchase Orders
4. CRM suite (ex iStore, iSupport, Sales Online etc)
Defaulting Rules: Defaulting Rules are used to populate the Sales order with your customer’s preferences such as freight carrier and contacts, payment terms, price list and salesperson etc. You can create a set of Defaulting Rules for each entity on the Sales Orders window.
Setup > Rules > Defaulting
Processing Constraints: Processing constraints is a common security framework in Order Management where you can define and build security rules around sales entities
Setup > Rules > Security -> Processing Constraints
Order Category - ORDER, MIXED or RETURN
Order Transaction Type Code – LINE or ORDER
Transaction Types – Order Category + Transaction Type Code + Order Workflow + Document details + Pricing + Credit Check + Shipping + Auto Invoice defaults
Sales Order Attributes:
Order Types – (nothing but Transaction Types) can be used as a data source for defaulting rules and additionally determines both the order and line workflow processes your orders will flow
Sales Order Line Attributes:
Line Type -
Order Line Statuses-
1. Entered – If few information like Payment Terms, Sales Person, Ship To Location Or Bill To Location is not entered
2. Booked – If all the required information is entered
3. Awaiting Shipping
4. Picked
5. Hold
6. Shipped
7. Invoiced
8. Closed
Invoice Interface Line Status -
|
Open Interfaces
|
Order Import (OEOIMP) - Order Import can import new, changed, and completed sales orders or returns from other applications such as a legacy system (OE_ORDER_IMPORT_MAIN_PVT.ORDER_IMPORT_CONC_PGM)
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_CUSTOMER_INFO_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PRICE_ATTS_IFACE_ALL
OE_CREDITS_IFACE_ALL
OE_RESERVTNS_IFACE_ALL
OE_LOTSERIALS_IFACE_ALL
OE_ACTIONS_IFACE_ALL (Operation Code: BOOK_ORDER, CREATE, etc)
High Volume Order Import (OEHVIMP) – To import the orders in Bulk
OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM
Receivables Interface (OE_INVOICE_WF.INVOICE_INTERFACE) – To collect order and return information and to populate the receivables Auto Invoice interface
OE_INVOICE_PUB.INTERFACE_HEADER/INTERFACE_LINE
Ship Confirm Open Interface – Mentioned in shipping execution
|
Public APIs
|
OE_ORDER_PUB.PROCESS_ORDER -> Process Order
|
Transaction Tables
|
Setup:
OE_ORDER_SOURCES
OE_TRANSACTION_TYPES_VL
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OE_PRICE_ADJUSTMENTS
OE_ORDER_PRICE_ATTRIBS
OE_PRICE_ADJ_ATTRIBS
OE_PRICE_ADJ_ASSOCS
OE_SALES_CREDITS
OE_LOT_SERIAL_NUMBERS
|
Processes
|
Order Import Statistics
Cancel Orders (OEMCEO – Spawned)
Close Orders (OEOCSO – Spawned)
Copy Orders Validation (OEXCPVAL – PL/SQL)
Order Purge (Order Purge – PL/SQL)
OrderImport (OEOBOE – Spawned)
Schedule Orders
|
Forms
|
Setup:
Order Import Sources – Order Import Source, Enabled
Order Types
Order Organizer
Sales Orders
(Uses the Workflow Activity - OE_ORDER_IMPORT_WF)
Quick Order Organizer
Quick Sales Orders
Pricing and Availability
|
Reports
|
Unbooked Orders Report (OEXOEUBK)
|
Advanced Pricing
Overview
|
Price Lists –
Price Agreements –
Price Modifiers – Price Actions that can be used to adjust the list price
Price Qualifiers – Determine Eligibility rules & Determine who receives the price benefits
Price Formulas –
Price Attributes/Product Attributes/Qualifier Attributes –
Freight and Special Charges
|
Interface Tables
|
QP: Bulk Import of Price List Concurrent Program(QPXVBLK)
QP_INTERFACE_LIST_HEADERS - Captures the Price List header data
QP_INTERFACE_LIST_LINES – Captures the Price list line data
QP_INTERFACE_QUALIFIERS: Contains the header qualifiers associated
with the price lists to be imported
QP_INTERFACE_PRICING_ATTRIBS: The product and pricing attributes data
is captured in this table
|
Public APIs
|
Price List Setup API: QP_PRICE_LIST_PUB
PROCESS_PRICE_LIST- API to insert, update and delete price lists and to set up a price list for a given P_PRICE_LIST_REC record structure. Takes two record types and six table types as input parameters
Custom Price API: QP_CUSTOM
GET_CUSTOM_PRICE
Pricing Engine API: QP_PREQ_GRP
|
Transaction Tables
|
Setup:
QP_PRICING_PHASES
QP_EVENT_PHASES
QP_PRICE_REQ_SOURCES
QP_PTE_REQUEST_TYPES_B
QP_PTE_SEGMENTS
QP_PTE_SOURCE_SYSTEMS
Transaction:
QP_PRICING_ATTRIBUTES
QP_LIST_HEADERS
QP_LIST_LINES
QP_PRICE_FORMULAS_B
QP_PRICE_FORMULA_LINES
OE_AGREEMENTS_B
QP_QUALIFIERS
|
Processes
| |
Forms
| |
Reports
| |
Profiles
|
QP: Get Custom Price Customized
QP: Batch Size for Bulk Import
QP: Break UOM Proration Allowed
QP: Pricing Transaction Entity
|
Shipping Execution (WSH)
Overview
|
Two main Shipping Processes
1. Pick Release process
2. Ship Confirm Process
Trips:
Stops:
Deliveries:
Containers:
Ship Method:
|
Interface Tables
|
Delivery–based Ship Confirm Open Interface:
WSH_DELIVERIES_INTERFACE
WSH_PICKING_DETAILS_INTERFACE
WSH_PACKED_CONTAINER_INTERFACE
WSH_FREIGHT_CHARGES_INTERFACE
WSH_DELIVERIES_INTERFACE <-> WSH_DELIVERIES_PUB.DELIVERY_ACTION and WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY
WSH_PICKING_DETAILS_INTERFACE <-> WSH_DELIVERY_DETAILS_PUB.UPDATE_SHIPPING_ATTRIBUTES
WSH_PACKED_CONTAINER_INTERFACE <-> WSH_CONTAINER_PUB.CREATE_CONTAINERS
WSH_FREIGHT_CHARGES_INTERFACE <-> WSH_FREIGHT_COSTS_PUB.CREATE_UPDATE_FREIGHT_COSTS
|
Public APIs
|
Trips API (WSH_TRIPS_PUB)
CREATE_UPDATE_TRIP - Create and update trip records
TRIP_ACTION - Perform actions on trips. Action Codes are PLAN,UNPLAN,DELETE,WT-VOL,PICK-RELEASE
Stops API (WSH_TRIP_STOPS_PUB)
CREATE_UPDATE_STOP - Create and update stop records
STOP_ACTION - Action Codes are PLAN,UNPLAN,ARRIVE,CLOSE,DELETE,PICK-RELEASE
Deliveries API (WSH_DELIVERIES_PUB)
CREATE_UPDATE_DELIVERIES -> Create or Update deliveries(trip stop records)
DELIVERY_ACTION - Perform actions on deliveries (PLAN,UNPLAN,DELETE,WT-VOL,PICKRELEASE,RE-OPEN,CLOSE)
DELIVERY_ACTION - Assign and un assign deliveries to and from trips and stops (ASSIGN-TRIP,UNASSIGNTRIP,AUTOCREATE-TRIP (For ASSIGN-TRIP, provide trip name)
DELIVERY_ACTION - Ship confirm deliveries (CONFIRM - Provide actual ship date)
Delivery Details API (WSH_DELIVERY_DETAILS_PUB)
DETAIL_TO_DELIVERY -> Assign and un assign delivery lines to and from deliveries
SPLIT_LINE -> Split delivery lines
UPDATE_SHIPPING_ATTRIBUTES -> Confirm actual shipped quantities
AUTOCREATE_DELIVERIES -> Auto-create deliveries
AUTOCREATE_DEL_TRIP -> Auto-create deliveries and trips
Container APIs (WSH_CONTAINER_PUB)
CREATE_CONTAINERS - Create containers
UPDATE_CONTAINER -> Update containers
CONTAINER_ACTIONS - Pack and unpack delivery lines into containers (PACK,UNPACK)
CONTAINER_ACTIONS - Assign and un assign containers to deliveries (ASSIGN,UNASSIGN)
AUTO_PACK -> Create containers and auto-pack
Freight Cost APIs (WSH_FREIGHT_COSTS_PUB): Create freight cost records, update freight cost records, validate freight cost types, delete freight cost records
CREATE_UPDATE_FREIGHT_COST
VALIDATE_FREIGHT_COST_TYPE
DELETE_FREIGHT_COSTS
Exceptions API: WSH_EXCEPTIONS_PUB
EXCEPTION_ACTION - procedure enables you to carry out actions on an exception
GET_EXCEPTIONS - gets the exceptions based on the entity name (‘DELIVERY’, ‘TRIP’, ‘STOP’,’CONTAINER’ and ‘DETAIL’)
Pick Release API (WSH_PICKING_BATCHES_PUB)
CREATE_BATCH - Enables you to create a new pick release batch
RELEASE_BATCH - Enables you to release a batch
|
Transaction Tables
|
WSH_TRIPS
WSH_TRIP_STOPS
WSH_NEW_DELIVERIES
WSH_DELIVERY_DETAILS
WSH_FREIGHT_COSTS
WSH_EXCEPTION
WSH_PICKING_BATCHES
WSH_PICKING_RULES
WSH_PICK_SEQUENCE_RULES
WSH_PICK_GROUPING_RULES
|
Processes
|
Process Delivery SRS
Release Sales Orders SRS
Ship Confirm Deliveries SRS
Import Delivery Lines
|
Forms
|
Shipping Transaction Form (Shipping -> Transactions)
Create LPNs (License Plate Numbers)
Packing Workbench form
Release Sequence Rules form (Shipping -> Setup -> Picking -> )
Pick Slip Group Rules form (Shipping -> Setup -> Picking ->)
Define Release Rules form (Shipping -> Setup -> Picking ->)
Release Sales Orders for Picking (Shipping -> Release Sales Orders ->)
Ship Confirm Rules form (Shipping -> Setup -> )
Quick Ship form (Shipping -> Quick ship)
Shipping Parameters form
Global Shipping Parameters form
Define Shipping Exceptions (Shipping -> Setup -> )
View Exceptions (Shipping -> Exceptions)
|
Reports
| |
Account Receivables
Overview
|
Auto Accounting - Specify how you want Receivables to determine the general ledger accounts for transactions that you enter manually or import using Auto Invoice. Revenue, receivable, freight, tax, unearned revenue, unbilled receivable, finance charges, bills receivables accounts, and Auto Invoice clearing (suspense) accounts
Accounting Rules - Accounting rules determine the accounting period(s) in which the revenue distributions for an invoice line are recorded
Invoice Rules – Invoicing rules determine the accounting period in which the receivable amount is recorded
Receipt Class – Creation Method, Remittance Method, Clearance Method, Require Confirmation, Payment Method
Receipt Source – Receipt Source Type, Receipt Class, Batch Numbering
Freight Terms -
Payment Term –
Transaction Class – Invoices, Credit memos, Debit memos, Charge backs, Guarantees, Deposits
AR Transaction Types – Transaction Class, Print Option, Transaction Status, Payment Terms, Accounts
Transaction Sources –
|
Open Interfaces
|
AutoInvoice Import Program (RAXTRX) – To import invoices, credit memos, debit memos and on-account credits
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
AR_INTERFACE_CONTS_ALL
RA_INTERFACE_ERRORS_ALL
Lockbox Interface – For processing bank receipts and conversion of historical data
AR_PAYMENTS_INTERFACE_ALL
Interim Quick Cash tables:
AR_INTERIM_CASH_RECEIPTS_ALL
AR_INTERIM_CASH_RCPT_LINES_ALL
Sales Tax Rates Interface – Load Sales Tax information from feeder systems
Tax Vendor Extension -
|
Public APIs
|
AR System Initialization Packages
DBMS_APPLICATION_INFO.SET_CLIENT_INFO - To set the ORG context
ARP_GLOBAL.INIT_GLOBAL: For setting public variables
ARP_STANDARD.INIT_STANDARD: For setting public variables
AR Adjustment Public API: AR_ADJUST_PUB
CREATE_ADJUSTMENT - To create an adjustment for an invoice
MODIFY_ADJUSTMENT - To modify an adjustment’s status, comments, and reason code
APPROVE_ADJUSTMENT - To approve an adjustment
REVERSE_ADJUSTMENT - To reverse an adjustment
Credit Memo Approval and Creation API: AR_CREDIT_MEMO_API_PUB
CREATE_REQUEST ROUTINE - To initiate the Credit Memo Request workflow process by making a credit memo workflow request
GET_REQUEST_STATUS - To view the status of an existing request
Credit Memo Application API: AR_CM_APPLICATION_PUB
ACTIVITY_APPLICATION - Applies an on-account credit memo to an activity
ACTIVITY_UNAPPLICATION – Un applies an on-account credit memo from an activity
AR Deposit API: AR_DEPOSIT_API_PUB
CREATE_DEPOSIT - Creates a single deposit and completes it
INSERT_NON_REV_SALESCREDIT - Creates non-revenue sales credit for a deposit
AR Invoice Creation Public API: AR_INVOICE_API_PUB
CREATE_INVOICE - Creates multiple invoices in a batch. Populate four global temporary tables for Header, Lines, Distributions and Sales Credits
CREATE_SINGLE_INVOICE: Create a single invoice and return customer_trx_id
AR Prepayments API: AR_PREPAYMENTS_PUB
CREATE_PREPAYMENT - Use this routine to create a prepayment receipt
GET_INSTALLMENT - Use this routine to calculate the amount of all installments of a given payment term
AR Receipt Creation Public API: AR_RECEIPT_API_PUB
CREATE_CASH - Creates a single cash receipt, as in the case of manually created cash receipts
CREATE_MISC - Creates a single miscellaneous receipt
REVERSE - Reverses the specified receipt
APPLY - Applies a cash receipt to a particular installment of a debit item
CREATE_AND_APPLY - Creates a cash receipt and applies it to a specified installment of a debit item in one pass
UNAPPLY – Un applies the application of a particular installment of a debit item against the specified cash receipt
APPLY_ON_ACCOUNT - Creates an on-account application for a cash receipt
UNAPPLY_ON_ACCOUNT – Un applies the on-account application on the specified receipt
ACTIVITY_APPLICATION - Applies to an activity, such as Receipt Write-off
ACTIVITY_UNAPPLICATION – Un applies from an activity, such as a Receipt Write-off
APPLY_OTHER_ACCOUNT - Applies to other account activities, such as Claim Investigation (for Trade Management customers only)
UNAPPLY_OTHER_ACCOUNT – Un applies from other account activities, such as Claim Investigation
APPLY_OPEN_RECEIPT - Creates a receipt-to-receipt application (payment netting)
UNAPPLY_OPEN_RECEIPT – Un applies a receipt-to-receipt application
|
Transaction Tables
|
Setup:
AR_RECEIPT_CLASSES -> Receipt classes
AR_RECEIPT_METHODS -> Receipt methods
AR_BATCH_SOURCES -> Receipt sources
AR_RECEIVABLES_TRX -> Receivables activities
Receipts Tables:
AR_CASH_RECEIPTS_ALL
AR_RECEIVABLES_APPLICATIONS_ALL
AR_CASH_RECEIPT_HISTORY_ALL
AR_PAYMENT_SCHEDULES
AR_DISTRIBUTIONS
Invoice Tables:
RA_BATCHES_ALL
RA_CUSTOMER_TRX _ALL
RA_CUSTOMER_TRX_LINES _ALL
RA_CUST_TRX_LINE_GL_DIST_ALL
RA_CUST_TRX_LINE_SALESREPS_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_RECEIVABLE_APPLICATIONS_ALL
AR_ADJUSTMENTS_ALL
Archive/Purge Tables:
AR_ARCHIVE_HEADER
AR_ARCHIVE_DETAIL
AR_ARCHIVE_PURGE_INTERIM
AR_ARCHIVE_CONTROL
Document Sequences:
FND_DOC_SEQUENCE_USERS
FND_DOCUMENT_SEQUENCES
FND_DOC_SEQUENCE_ASSIGNMENTS
|
Processes
|
Auto Invoice Purge program
Archive and Purge Program
Auto Lockbox Program
Import Step - Import the data from the Bank file to Lockbox Interface table
Validate Step - Transfers receipt data from Lockbox interface table to Quick Cash tables
Post Quick Cash Step - Transfers data from Quick Cash tables to Receivables system tables
|
Forms
|
Transactions Setup:
Payment Terms – Terms of Payment like Discounts (ex: 30 Net)
Transaction Types – Invoice, Credit Memo, Debit Memo etc.
Transaction Sources – Manual or Imported
Transaction Batches – Manual type of Transaction Sources
AutoAccounting – Account Type, Segment, Table Name, Constant
Invoicing and Accounting Rules Form - Type, Active, Period, Number of Periods
AutoInvoice Grouping Rules Form - Line Ordering Rule, Transaction Class, Optional Grouping Characteristics
AutoInvoice Line Ordering Rules - Name, Order by Sequence, Order by Transaction Attribute, Type (asc, desc)
AutoInvoice Interface Exceptions
AutoInvoice Interface Lines
Transactions:
Transactions Summary Form
Transactions Form
Credit Transactions Form
Copy Transactions Form
Receipts Setup:
|
Profiles
|
AR: Transaction Batch Source
AR: Change Customer on Transaction
AR: Allow update on existing Sales Credits
AR: Use Invoice Accounting for Credit Memos
AR: Override Adjustment Activity Account Option
AR: Default Exchange Rate Type
|
Trading Community Architecture (TCA)
Overview
| |
Open Interfaces
|
Import Batch to TCA Registry program:
(Only at Party Level)
Loading Data into the Interface Tables: You can load data through:
SQL/ETL Load: Create scripts or use tools to extract the source information, transform the values to meet the data requirements of the interface tables
D&B Load: Use the standard D&B bulk file that you receive from D&B and run the D&B Import Adapter request set to automatically map and load the D&B
information into the interface tables
File Load: Use Oracle Customers Online (OCO) or Oracle Data Librarian (ODL) to load data from a comma-separated value (CSV) file, or file delimited by
another allowed character, into the interface tables
HZ_IMP_PARTIES_INT
HZ_IMP_CONTACTS_INT
HZ_IMP_ADDRESES_INT
HZ_IMP_ADDRESSUSES_INT
HZ_IMP_CONTACTPTS_INT
HZ_IMP_CONTACTROLES_INT
HZ_IMP_FINREPORTS_INT
HZ_IMP_FINNUMBERS_INT
AR Customer Interface Program – (RACUST: Spawned Process) To Import and validate current and historical customer information
(At Party and Customer Level)
RA_CUSTOMERS_INTERFACE_ALL - Stores customer, address, and business purpose information
RA_CUSTOMER_PROFILES_INTERFACE - Stores customer profile information
RA_CUST_PAY_METHOD_INTERFACE - Stores payment method information for a customer or for a specific Bill-To address
RA_CUSTOMER_BANKS_INTERFACE - Stores bank information for a customer or for a specific Bill-To address
RA_CONTACT_PHONES_INTERFACE
|
APIs
|
Organization Party API:
HZ_PARTY_V2PUB.CREATE_ORGANIZATION / UPDATE_ORGANIZATION
Tables:
HZ_PARTIES (Party type as ORGANIZATION)
HZ_ORGANIZATION_PROFILES
HZ_ORIG_SYS_REFERENCES
Person Party API:
HZ_PARTY_V2PUB.CREATE_PERSON / UPDATE_PERSON
Tables:
HZ_PARTIES (Party type as PERSON)
HZ_PERSON_PROFILES
HZ_ORIG_SYS_REFERENCES
Group Party API:
HZ_PARTY_V2PUB.CREATE_GROUP / UPDATE_GROUP
Tables:
HZ_PARTIES (Party type as GROUP)
HZ_ORIG_SYS_REFERENCES
Party Info (Credit Ratings) API:
HZ_PARTY_INFO_V2PUB.CREATE_CREDIT_RATING
Tables:
HZ_CREDIT_RATINGS
Party Contacts API & Party Contact Roles API:
HZ_PARTY_CONTACT_V2PUB.CREATE_ORG_CONTACT
Tables: HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
HZ_PARTY_CONTACT_V2PUB.CREATE_ORG_CONTACT_ROLE
Table: HZ_ORG_CONTACT_ROLES
Party Site API & Party Site Use API:
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE
Table: HZ_PARTY_SITES
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE
Table: HZ_PARTY_SITE_USES
Locations API
HZ_LOCATION_V2PUB.CREATE_LOCATION / UPDATE_LOCATION
Tables:
HZ_LOCATIONS
Contact Points API
HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT / CREATE_EDI_CONTACT_POINT / CREATE_EMAIL_CONTACT_POINT
Tables:
HZ_CONTACT_POINTS
The supported types of contact points are PHONE, PAGER, EMAIL, TELEX, WEB, EFT, and EDI
Relationship Type, Relationship, and Hierarchy Retrieval APIs
HZ_RELATIONSHIP_TYPE_V2PUB.CREATE_RELATIONSHIP_TYPE
TABLE: HZ_RELATIONSHIP_TYPES
HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP
TABLE: HZ_RELATIONSHIPS
HZ_HIERARCHY_V2PUB.CHECK_PARENT_CHILD
Customer Account API:
HZ_CUST_ACCOUNT_V2PUB
Account Site & Site Use APIs:
HZ_CUST_ACCOUNT_SITE_V2PUB
|
Transaction Tables
|
Customer Interface Tables:
• HZ_PARTIES
• HZ_PARTY_SITES
• HZ_PERSON_PROFILES
HZ_CONTACT_POINTS
• HZ_LOCATIONS
• HZ_ORG_CONTACTS
• HZ_CUST_ACCT_RELATE_ALL
• HZ_CUST_ACCT_ROLES
• HZ_CUST_ACCT_SITES_ALL
• HZ_CUST_ACCOUNTS
• HZ_CUST_PROFILE_AMTS
• RA_CUST_RECEIPT_METHODS
• HZ_CUST_SITE_USES_ALL
• HZ_CUSTOMER_PROFILES
• AP_BANK_ACCOUNT_USES
• AP_BANK_ACCOUNTS
• AP_BANK_BRANCHES
|
General Ledger
Overview
|
General Ledger is the central repository for the accounting information, receiving transaction from all sub ledgers
Primary functions of General Ledger are,
Journal Entries
Budget Creation
Account Balances
Each Numerical Value in GL must fall into one of three categories:
Actuals
Budgets
Encumbrances
Payables post the Transactions of Type:
Payments & Invoices
Receivables post the Transactions of Type:
Receipts, Invoices, Credit Memos, Debit Memos, On-account Credits,
Adjustments, Guarantees, charge backs, deposits etc.
Financial Statement Generator (FSG) - It is a powerful report building tool for Oracle General Ledger. With FSG,
1) Generate financial reports, such as income statements and balance sheets, based upon data in your general ledger
2) Generate presentation quality financial reports with XML Publisher
3) Schedule reports to run automatically
4) General Ledger standard accounting reports and listings include Trial balances, Journals, General ledgers, Account analysis reports, Chart of account listings etc
|
Open Interfaces
|
GL Journal Import Interface
GL_INTERFACE_CONTROL
GL_INTERFACE
GL Daily Rates Interface
GL_DAILY_RATES_INTERFACE – Database triggers are defined on this table to automatically insert the data into setup table, GL_DAILY_RATES
GL Budget Interface
GL_BUDGET_INTERFACE - Budget upload (ex: ADI, SQL Loader)
|
Public APIs
|
-
|
Transaction Tables
|
Setup
GL_JE_CATEGORIES
GL_JE_SOURCES
GL_DAILY_RATES
Set of Books
GL_PERIOD_STATUSES
GL_PERIODS
GL_PERIOD_SETS
FND_CURRENCIES
FND_FLEX_ID_STRUCTURES
GL_CODE_COMBINATIONS
GL_SETS_OF_BOOKS
Journals
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
Budget
GL_BUDGETS
GL_BUDGET_VERSIONS
GL_BUSGET_ENTITIES
GL_BUDGET_ASSIGNMENTS
Balances
GL_BALANCES
|
Processes
|
Journal Import Process
Post Journals Process
|
Forms
|
Install Base
Overview
| |
Interface Tables
| |
Public APIs
|
The APIs provided for the new Install Base are organized into the following packages
CSI_DATASTRUCTURES_PUB: Contains all public data structures exposed to Install Base API users
CSI_ITEM_INSTANCE_PUB: Contains all APIs for item instance management.
Create_Item_Instance / Update_Item_Instance / Expire_Item_Instance
CSI_INSTANCE_RELATIONSHIP_PUB: Contains all APIs to manage instance-to-instance relationships (instance configuration)
Create_Relationship
CSI_SYSTEMS_PUB: Contains APIs for creating, updating and deleting the systems
Create_System
|
Transaction Tables
|
CSI_INSTANCE_INTERFACE
CSI_II_RELATIONSHIPS
CSI_SYSTEMS_B
CSI_I_PRICING_ATTRIBS
CSI_TRANSACTIONS
CSI_ITEM_INSTANCES
|
No comments:
Post a Comment