Oracle R12 Project Billing

Here’s a clear breakdown of the Oracle R12 Project Billing Cycle, covering all major steps along with relevant table names and what each step does.

1.    Project, Agreement  and Billing Events Setup

        Before billing, you must define:

    • Projects  (PA_PROJECTS_ALL)
    • Billing Events (PA_EVENTS)
    • Customer agreements (funding) (PA_AGREEMENTS_ALL)
        PA_PROJECT_CUSTOMERS – Link project to customer
        PA_PROJECT_FUNDINGS – Funding assignments

2.    Generate Revenue
        
        Revenue is generated based on:
    • Time and materials
    • Milestones
    • Percent complete
    • Event-based billing
        Run Process: PRC: Generate Draft Revenue for a Single Project
    • PA_DRAFT_REVENUES_ALL – Draft revenue headers
    • PA_DRAFT_REVENUE_ITEMS_ALL – Revenue lines
3.    Generate Invoices

        Invoices are generated after or along with revenue (depending on contract terms). 
        Can be event-based, time-based, or milestone-based.

        Run Process: PRC: Generate Draft Invoices for a Single Project    
    • PA_DRAFT_INVOICES_ALL – Draft invoice headers
    • PA_DRAFT_INVOICE_ITEMS_ALL – Line items
    • PA_EVENTS – Billing events
4.    Review and Approve Drafts
        
       Users can review, adjust, and approve draft invoices and revenue before releasing to
        AR (Receivables). status changes when approved

5.    Interface to Receivables (AR)
        
       Once invoices are approved, they're interfaced to Oracle AR for customer billing.

       Run Process: PRC: Interface Invoices to Receivables
    • RA_INTERFACE_LINES_ALL – AR interface table
    • RA_CUSTOMER_TRX_ALL – Final invoice in AR
    • RA_CUSTOMER_TRX_LINES_ALL – Invoice lines in AR 
6.    Create Accounting

        Accounting entries for revenue are generated.
    • XLA_AE_HEADERS
    • XLA_AE_LINES
    • XLA_EVENTS
    • XLA_DISTRIBUTION_LINKS
7. Reporting & Reconciliation

        Use views and reports to review billed amounts, outstanding invoices, revenue, and funding.
    • PA_PROJECTS_V
    • PA_DRAFT_INVOICE_ITEMS_V
    • PA_AGREEMENTS_V
    • PA_BILLING_EVENTS_V



Comments

Post a Comment

Popular posts from this blog

Oracle APPS Creating Buy One Get One Free Modifier

Image
1.    Via Oracle Pricing Manager Responsibility 2.    Navigate > Price List > Price List Setup     Verify items (buy item and get item) are on the price list.     3.    Navigate > Modifiers > Modifiers Setup    At the header level create a Modifier Type of Promotion   4.    Modifier line info should be setup as follows:   Level   - Line Modifier Type   - Promotional Goods Automatic   - Checked Pricing Phase   - List Line Adjustment   Product Attribute - Item Number   Product Attribute value   - the item that the customer orders   Volume type   - Item Quantity                       Break type   - Recurring     Operator   - Between UOM   - select the appropriate unit of measure Value from ...
Read more

Oracle R12 Project Interface & APIs

Image
In Oracle Projects (PA) R12 , there are multiple ways to interface project-related data from external systems (like legacy systems, third-party tools, or spreadsheets). The method you choose depends on the type of data , volume , and level of control you need. 1.      Open Interface Tables (Standard Way)            Oracle provides interface tables for different types of project-related data. You insert data into                   these tables, then run Oracle’s concurrent programs to import the data.           Common Interface Tables:                      Best for: Medium to large data loads           Requires: Validation of setup values (status, types, orgs) 2.      Public APIs (PL/SQL-based)           Oracle provi...
Read more

SQL query to find pending PO for approval in Oracle EBS R12

SELECT   fu.user_name po_created_by,pha.org_id ,          (SELECT NAME || ' ( ' || short_code || ' )'             FROM hr_operating_units            WHERE organization_id = pha.org_id) ou_name,          pha.segment1 po_num, pha.revision_num, SUM(pla.quantity) po_qty, SUM(pla.unit_price) po_price,          pha.authorization_status, pha.creation_date po_creation_date,          wn.to_user, wn.subject, wn.original_recipient, wn.begin_date,          TRUNC (SYSDATE - wn.begin_date) no_days_pending,d.name Approval_path          ,wn.from_role forrwad_by,wn.notification_id,pha.po_header_id     FROM wf_notifications wn,          po_headers_all pha,          fnd_user fu,          po_lines_all pla, ...
Read more