Application Gyan

 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, ...

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...

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...

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 ...