Posts

Oracle EBS R12 Outbound Interface Example

 CREATE OR REPLACE PROCEDURE XX_INV_ITEMS_OUT (Errbuf       OUT varchar2,                                          Retcode      OUT varchar2,                                          p_id      IN     number) AS    CURSOR c1    IS       SELECT   msi.segment1 item,                msi.inventory_item_id Itemid,                msi.description itemdesc,                msi.primary_uom_code Uom,                ood.organization_name name,                ood.organization_id id, ...
Post a Comment
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...
Post a Comment
Read more

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_ITE...
Post a Comment
Read more

Oracle R12 Project Costing

Oracle R12 Project Costing involves capturing, processing, and accounting for costs associated with projects. Here's a breakdown of the key steps involved in Project Costing along with the important tables used in each step: 1.     Setup ( Prerequisites )           Before you start costing, ensure the project and related setups are completed:   Project creation ( PA_PROJECTS_ALL )   Task creation ( PA_TASKS )   Expenditure types ( PA_EXPENDITURE_TYPES   ) & categories ( PA_EXPENDITURE_CATEGORIES   )   Organization and employee assignments 2.      Transaction Sources Setup           Define transaction sources (like Payroll, Payables, Inventory, etc.) to allow data import into Projects. Transaction sources ( PA_TRANSACTION_SOURCES) 3.  Cost Collection (Data Entry or Integration)           Enter time and expense charges via Expenditure ...
Post a Comment
Read more

Oracle R12 Project

Image
 Introduction:      Oracle Project Costing and Billing provides an integrated cost management solution for all projects and activities within an enterprise. With Project Costing you can manage costs across currency and organizational boundaries Where as using Oracle Project Billing provides you with the ability to simplify your client invoicing, improve your cash flow, and measure the performance and profitability of your contract projects. Overview: Create Contract Project type, project template Create Agreement against the customer Define Bill rate schedule Enter time and expenses against the project Generate Revenue and Invoices Transfer to Receivables Transfer to General Ledger Integration of Oracle Projects with other Oracle Modules: Key Concepts: Project: ( PA_PROJECTS_ALL)      A unit of work that requires resources to produce measurable results. A project can be broken down         into one or m...
Post a Comment
Read more

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 ...
Post a Comment
Read more