P2P Table Descriptions

P2P Tables With Details

1.PO_REQUISITION_HEADERS_ALL

2.PO_REQUISITION_LINES_ALL

When you raise the Requisition these tables effected

3.PO_REQUISITION_HEADER_ID is the join between the tables

4.PO_REQ_DISTRIBUTIONS_ALL

It distribute the Requisition Account information.

5.PO_HEADERS_ALL (PO_HEADER_ID)

6.PO_LINES_ALL

When PO Created PO stores in tables(PO_HEADER_ID) is the join for tables

7.PO_DISTRIBUTIONS_ALL

It will distribute the PO# Account information

8.PO_ACTION_HISTORY

Here you can get Approvals notification Status

9.PO_VENDORS (VENDOR_ID)

10.PO_VENDOR_SITES_ALL (VENDOR_SITE_ID)

11.PO_VENDOR_CONTACTS (VENDOR_CONTACT_ID)

Contacts Vendor ,Vendor site and contact information Vendor_id,Vendor_contact_id, (VENDOR_SITE_ID)

12. RCV_SHIPMENT_HEADERS (SHIPMENT_HEADER_ID)

Common information about the source of your receipts or expected receipts

13. RCV_SHIPMENT_LINES

When you issue the receipt The recipient number , Shipment location stores in the table.

14. RCV_TRANSACTIONS (TRANSACTION_ID)

15. MTL_MATERIAL_TRANSACTIONS (TRANSACTION_ID)

Stores material transaction information (Transaction_id)

16.PO_RELEASES_ALL

To see the which purchase order is released.

17.PO_AGENTS

Contains information about buyers and purchasing managers.

18.PO_NOTIFICATION_CONTROLS

Contains information about the notification control rules for blanket, planned, and contract purchase orders.

19.PO_APPROVAL_LIST_HEADERS

List of approves for the purchasing document used for requisition approvals only

20.PO_APPROVAL_LIST_LINES

Approval list lines for the requisition approval list.

21.PO_POSITION_CONTROLS_ALL

Assignment of control groups to jobs and/or positions

22.PO_DOCUMENT_TYPES_ALL_B

Default, control, and option information you provide to customize

23.PO_CONTROL_GROUPS_ALL

Control groups you use in your business

24.PO_RFQ_VENDORS

Information about the set of suppliers assigned to a request for quotation (RFQ)

25.PO_VENDOR_LIST_HEADERS (VENDOR_LIST_HEADER_ID)

Stores information about supplier quotation lists you create.

26.FINANCIALS_SYSTEM_PARAMS_ALL

This Tables stores common and default information between AP and PO.

Comments

Example of $FLEX$ Syntax Used In Value Set

Example of $FLEX$ Syntax Used In Value Set ($flex$ in oracle apps) Example of using “ :$FLEX$.Value_Set_Name” to set up value sets where one segment depends on a prior segment that itself depends on a prior segment. Suppose you have a three-segment flexfield where the first segment is Country , the second segment is State , and the third segment is District . You could limit your third segment's values to only include Districts that are available for the Address specified in the first two segments. Your three value sets might be defined as follows: Segment Name Country_Segment Value Set Name Country_Value_Set Validation Table Country_Table Value Column Country_NAME Description Column ...

Pending Receiving Transactions (Resolving Period Close Pending Transaction R12 or Inventory Closing Steps in Oracle Apps R12)

Pending Receiving Transactions Pending Receiving Transactions are transactions that have not processed through the RCV_TRANSACTIONS_INTERFACE table. These transactions can be viewed and deleted through the "Transaction Status Summary" form: Purchasing > Receiving > Transactions Status Summary A Find window will appear and to query all of the unprocessed transactions for that period select from the field Source Type 'All', from the Transactions Details tab input the start and completion dates of the period in question and click 'Find': Using the Transaction Statuses window, pending transactions can be viewed and deleted. There are four tabs to select: Transactions, Details, Order Information and Outside Services . The Main Descriptive fields give detailed information on the type of transaction that the cursor is on : Receipt, Receipt number Supplier , Source of the receipt Description , Item description Errors , Error message Order , Order Number Paren...

Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set property for your responsibility

Error: - APP-PER-50022: Oracle Human Resource Could Not Retrieve a Value For The User Type Profile Option. Please ensure it is set the property for your responsibility. Solution-: (1) Go to System administrator > Profile > System (2) Now Search “ HR: User Type ” Profile option at Responsibility level with Respective Responsibility. And Click On FIND Button. Now Select HR: User Type Value “HR with Payroll User” (you can choose another option as well accordingly). And SAVE. Now check your responsibility, error removed. Go ahead with your next step and enjoy Oracle Apps. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.

testoag

Search This Blog