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

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.

Error "You have exceeded the transaction quantity". Precision Restriction for Quantity Field Up To 6 Decimal Places Performing Lot Receipts (Doc ID 464983.1)

Error "You have exceeded the transaction quantity". Applies to: Information in this document applies to any platform. FORM:RCVRCERC.FMB - Enter Receipts GUI FORM:RCVTXERT.FMB - Enter Receiving Transactions GUI FORM:RCVTXERE.FMB - Enter Returns GUI FORM:RCVTXECO.FMB - Enter Corrections GUI "You have exceeded the transaction quantity" Symptoms: "You have exceeded the transaction quantity" Note: Internal error message may indicate this message: INV_QUANTITY_TOO_BIG Steps: Go to Receiving Screen Enter the qty like 7200.00000489 (6 digits restriction makes it 7200.000005) Go to Lot/Serial form Enter lot number and qty as 7200.00001 (which was rounded to 5 digits) The message "you have exceeded the transaction quantity " Cause Can Be-: a) Restriction of precision support up to 6 decimal places was added for the quantity field b) Comparing the transaction qty entered in receiving forms and the lot quantity entered in lot-entry form after rounding to...

Script to insert on hand quantity in to MTL_TRANSACTIONS_INTERFACE

Script to insert on hand quantity into MTL_TRANSACTIONS_INTERFACE To insert on hand quantity into MTL_TRANSACTIONS_INTERFACE INSERT INTO MTL_TRANSACTIONS_INTERFACE ( TRANSACTION_INTERFACE_ID, SOURCE_CODE, SOURCE_LINE_ID, SOURCE_HEADER_ID, PROCESS_FLAG, VALIDATION_REQUIRED, TRANSACTI...

testoag

Search This Blog