Entries by Oracle ERP Apps Guide

, , ,

Few Important AP Tables

AP_SUPPLIERS: This table replaces the old PO_VENDORS table. It stores information about your supplier level attributes. Each row includes the purchasing, receiving, invoice, tax, classification, and general information. Oracle Purchasing uses this information to determine active suppliers. The supplier name, legal identifiers of the supplier will be stored in TCA and a reference to the […]

/by
, ,

Script to get all the Concurrent Program Request details

Below is the script to get the Concurrent Program Request details by Various Users in a Particular Day. select request_id, parent_request_id, fcpt.user_concurrent_program_name Request_Name, fcpt.user_concurrent_program_name program_name, DECODE(fcr.phase_code, ‘C’,’Completed’, ‘I’,’Incactive’, ‘P’,’Pending’, ‘R’,’Running’) phase, DECODE(fcr.status_code, ‘D’,’Cancelled’, ‘U’,’Disabled’, ‘E’,’Error’, ‘M’,’No Manager’, ‘R’,’Normal’, ‘I’,’Normal’, ‘C’,’Normal’, ‘H’,’On Hold’, ‘W’,’Paused’, ‘B’,’Resuming’, ‘P’,’Scheduled’, ‘Q’,’Standby’, ‘S’,’Suspended’, ‘X’,’Terminated’, ‘T’,’Terminating’, ‘A’,’Waiting’, ‘Z’,’Waiting’, ‘G’,’Warning’,’N/A’) status, round((fcr.actual_completion_date – […]

/by
, , ,

ABOUT INTERFACES

In Oracle Apps Interfaces are generally tables, which act as a medium to transfer the data from one module to another module or to transfer the data from legacy system into Oracle Applications. There are 352 tables provided by the Oracle Package. Each module has its own Interface Tables.A typical path to transfer the data […]

/by
, , ,

AP invoice interface

This interface helps us to import vendor invoices into Oracle applications from external systems into Oracle Applications. Interface tables:  1] AP_INVOICES_INTERFACEThis is the open interface table for importing AP Invoices from external sources and stores header information about invoices. Invoice data comes from sources including: EDI invoices from suppliers that are loaded through Oracle e-Commerce […]

/by
,

Trading Community Architecture (TCA) in Oracle Apps

Before TCA: There are multiple customer definitions across the enterprise. It was very difficult to track current and historical information about the customers. There was a lack of support for mixed business. It was quite tough to understand relationships between customers and others (suppliers, partners, competitors). Customers: More important than anything else! In any business, […]

/by