R12 - Overview of Payables Processes

We use Oracle Payables for five major business functions:

•         Supplier entry

•         Invoice import/entry

•         Invoice validation

•         Invoice payment

•         Invoice and payment accounting

To enter and pay invoices, first enter suppliers and supplier sites.  Payables processes many different invoice types including standard invoices, credit memos, debit memos and expense reports.  After invoices are entered and validated, they can be paid. 

After invoices are validated or paid, subledger accounting entries are generated in Subledger Accounting and those entries are transferred to General Ledger.

Oracle Procure to Pay Process

Oracle Procure to Pay Process

Demand

The procurement process generates and manages requests for the purchase of goods.  The demand for purchase items may be a one-time event or may recur in either predictable or random time intervals.

Source

The procurement sourcing process covers the business activities related to the search, qualification, and selection of suitable suppliers for requested goods and services.

Order

The procurement ordering process includes purchase order placement by the buying organization and purchase order execution by the supplying organization.

Receive

The receipt process acknowledges that a purchase order has been duly executed.  For orders of physical goods, it will typically include the receipt, inspection and delivery of the goods to inventory or to another designated location.  For orders of services, it will typically consist of a notification from the requester or the approving person that the service has been performed as agreed.

Invoice

The invoice process includes entering supplier and employee invoices.

Pay

The payment process consists of those activities involved in the payment for ordered goods and services.

LDT Files Generation Scripts

Hi,

Use the below commands to generat ldt files.

Concurrent Program:
-------------------------
$FND_TOP/bin/FNDLOAD apps/A4zRF5pg O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXHRPEN_PROG.ldt PROGRAM APPLICATION_SHORT_NAME="XXHR" CONCURRENT_PROGRAM_NAME="XXHRTOPEN"

$FND_TOP/bin/FNDLOAD apps/A4zRF5pg O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXBBHRPEN_PROG.ldt 
 

Tips For SQL Query Tunning

Use below tips to increase sql query performance.
1. The sql query becomes faster if you use the actual columns names in SELECT statement instead of than '*'.
EX: select * from table;
    select col1,col2,.... from table;  -- faster when compared to previous once
   
2. Try to avoid  HAVING clause to filter the records..
3. EXISTS is efficient when most of the filter criteria is in the main query.
4. IN is efficient when most of the filter criteria is in the sub-query.
5. Separate all words with a single space.
6. Use any harcoded values in last of the where clause. Because sql engine execute the statements from last.
EX: select a.*  from emp a, dept b
      where a.deptno = b.deptono
      and b.deptno = 40;