Flow of Order Management
• Entered (OM): Order is saved but not booked.
• Booked (OM): Order is booked.
• Scheduled (OM): You can customize the workflow to show the Scheduled statuswhich indicates that the order line has been successfully scheduled by adding acustomized activity after the Schedule activity. This activity will make a process Shipping
14-31order API call to update the status to Scheduled. When the ship line logic starts, theorder line status changes to Awaiting Shipping.
• Awaiting Shipping (OM): Order is booked and scheduled but lines have not beenpicked. This status is also displayed after the line has been ship confirmed but beforethe Order Management interface has been run.
• Picked (OM): Order is booked and lines are picked.
• Open (OM): This status of a delivery on the Additional Line Information formindicates that none of the delivery lines associated with that delivery have beenship confirmed.Navigating to Shipping Execution, the delivery line status flow is:
• Ready to Release (SE): Order line is booked and passed to Shipping Execution. Itis now a delivery line that is eligible for Pick Release.
• Not Ready to Release (SE): A delivery line might be in this status when it is interfacedmanually into Shipping Execution, is not scheduled, and has no reservations. Whenlines are imported automatically from Order Management this status is not used.
• Backordered (SE): The delivery line is pick released but no allocations were createdor partial allocations occurred. As an example, if a delivery line has a quantity of100, and at pick release only 25 are available for allocation, the original delivery linesplits to create a new line (quantity of 75) for the unallocated portion with a status ofBackordered. The quantity on the original delivery line changes to 25 to reflect theallocated portion with a status of Staged/Pick Confirmed.
• Staged/Pick Confirmed (SE): The delivery line is successfully pick released. It occursafter pick confirm to indicate subinventory transfer from source location to staginglocation is complete. Lines remain staged until they are ship confirmed.
• Released to Warehouse (SE): Pick Release has started but not completed. Either noallocations were created or allocations have not been Pick Confirmed.Note: Both Backordered and Staged/Pick Confirmed statusesprovide the ability to perform opportunistic cross-docking forwarehouse organizations with Oracle Warehouse Management(WMS) installed.
• Shipped (SE): This line status indicates that the delivery associated with the deliverylines is ship confirmed.
• Interfaced (SE): If delivery was sourced from Oracle OM: The delivery line isshipped and the OM Interface and Inventory Interface concurrent processeshave completed. If delivery was sourced from an Oracle Application other thanOM: The delivery line is shipped and the Inventory Interface concurrent processhas completed.
• Canceled (SE): This status indicates that the delivery line was cancelled.Navigate back to Order Management and query the order which results in OM pullingupdated Pick Release information from Shipping Execution:
• Picked (OM): Pick release has completed normally (both allocation and pickconfirm). The delivery associated with the delivery line(s) may have also been ShipConfirmed but the Delivery may not be set in transit and the Trip may not be closed.14-32 Oracle Order Management Implementation Manual
• Picked Partial (OM): This status occurs when a delivery line is not allocated the fullquantity during Pick Release and Ship Confirm has not occurred.The delivery line splits during Ship Confirm and the information passes toOrder Management through the Process Order API. The order line splits toreflect the changes that occurred during the Shipping process. As an example, acustomer orders quantity 50. There are 20 on hand in inventory. The delivery linesplits into two delivery lines and therefore represents two order lines in OrderManagement. The order line with quantity 20 has the status of Picked or Shippeddepending on whether or not the delivery line is Ship Confirmed, the Delivery set intransit, and the Trip closed. The second order line with a quantity of 30 has statusof Awaiting Shipping.Shipping Execution passes the status information to Order Management when ShipConfirm is complete:
• Shipped (OM): The delivery associated with the line is Ship Confirmed. TheDelivery status is set to In transit. This status appears at the line level as well as inthe Additional Line Information at the Pick Status field.
• Awaiting Shipping (OM): Awaiting information from shipping. This status willremain until the Order Management interface is run.
• Awaiting Fulfillment (OM): Not all shippable lines in a fulfillment set or aconfiguration are fulfilled. The current line is waiting for other lines in the fulfillmentset or the configuration to be fulfilled. This is a synchronization step within theworkflow process.
• Fulfilled (OM): All lines in a fulfillment set are fulfilled.Fulfillment Sets are defined as a group of order lines that are fulfilled together. Itemsthat are not shippable can be in fulfillment sets with shippable items, and then willnot be fulfilled (and therefore invoiced) until the shippable items are fulfilled. A linecan belong to either a ship set or an arrival set, but can belong to multiple fulfillmentsets.
• Interfaced to Receivables (OM): Order Management has written information tothe Receivables Interface tables. You should run Auto Invoice (from Receivables)to generate the Invoice.
• Partially Interfaced to Receivables (OM): This status is used in a PTO flow andindicates that the particular PTO item is required for revenue.
• Closed (OM): Closed indicates that the line is closed. It does not necessarily indicatethat the line is interfaced to Accounts Receivable (AR) since you must close lineactivity in a no-bill flow.
• Canceled (OM): Indicates that the line is completely canceled. No further processing will occur for this line.
===
ORDER NO:66424
====ORDER ENTRY IN HEADERS===
SELECT OOHA.ORDER_NUMBER,OOHA.HEADER_ID,OOHA.FLOW_STATUS_CODE
FROM OE_ORDER_HEADERS_ALL OOHA
WHERE OOHA.ORDER_NUMBER='66424'
O/P: OOHA.FLOW_STATUS_CODE=ENTERED
====ORDER ENTERY IN LINES==
SELECT OOHA.ORDER_NUMBER,OOHA.FLOW_STATUS_CODE,OOLA.HEADER_ID,OOLA.LINE_ID,OOHA.HEADER_ID,OOLA.FLOW_STATUS_CODE
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOHA.ORDER_NUMBER='66424'
O/P: OOHA.FLOW_STATUS_CODE=ENTERED,OOLA.FLOW_STATUS_CODE=ENTERED
===========BOOKING THE ORDER====
SELECT OOHA.ORDER_NUMBER,OOHA.FLOW_STATUS_CODE,OOLA.HEADER_ID,OOLA.LINE_ID,OOHA.HEADER_ID,OOLA.FLOW_STATUS_CODE,
WDD.RELEASED_STATUS,WDD.DATE_REQUESTED
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND OOHA.ORDER_NUMBER='66424'
O/P:OOHA.FLOW_STATUS_CODE=BOOKED,OOLA.FLOW_STATUS_CODE=AWAITING_SHIPPING,WDD.RELEASED_STATUS=R
===========PICK RELEASE THE ORDER==
SELECT OOHA.ORDER_NUMBER,OOHA.FLOW_STATUS_CODE,OOLA.HEADER_ID,OOLA.LINE_ID,OOHA.HEADER_ID,OOLA.FLOW_STATUS_CODE,
WDD.RELEASED_STATUS,WDD.DATE_REQUESTED
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_NEW_DELIVERIES WND,
WSH_DELIVERY_ASSIGNMENTS WDA
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID=WND.DELIVERY_ID
AND OOHA.ORDER_NUMBER='66424'
O/P:OOHA.FLOW_STATUS_CODE=BOOKED,OOLA.FLOW_STATUS_CODE=AWAITING_SHIPPING,WDD.RELEASED_STATUS=R
===============SHIP CONFIRM THE ORDER==
SELECT OOHA.ORDER_NUMBER,OOHA.FLOW_STATUS_CODE,OOLA.HEADER_ID,OOLA.LINE_ID,OOHA.HEADER_ID,OOLA.FLOW_STATUS_CODE,
WDD.RELEASED_STATUS,WDD.DATE_REQUESTED,WDA.DELIVERY_ID,WDA.DELIVERY_DETAIL_ID,WND.DELIVERY_ID,WND.STATUS_CODE
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_NEW_DELIVERIES WND,
WSH_DELIVERY_ASSIGNMENTS WDA
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID=WND.DELIVERY_ID
AND OOHA.ORDER_NUMBER='66424'
O/P:OOHA.FLOW_STATUS_CODE=BOOKED,OOLA.FLOW_STATUS_CODE=AWAITING_SHIPPING,WDD.RELEASED_STATUS=Y,WND.STATUS_CODE:OPEN
IN THE BACK END:Pick Slip Report,Shipping Exceptions Report,Auto Pack Report (Auto-pack Report)
WILL RUN IN THE BACKGROUND
======SHIP CONFIRM THE ORDER==
SELECT OOHA.ORDER_NUMBER,OOHA.FLOW_STATUS_CODE,OOLA.HEADER_ID,OOLA.LINE_ID,OOHA.HEADER_ID,OOLA.FLOW_STATUS_CODE,
WDD.RELEASED_STATUS,WDD.DATE_REQUESTED,WDA.DELIVERY_ID,WDA.DELIVERY_DETAIL_ID,WND.DELIVERY_ID,WND.STATUS_CODE
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_NEW_DELIVERIES WND,
WSH_DELIVERY_ASSIGNMENTS WDA
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID=WND.DELIVERY_ID
AND OOHA.ORDER_NUMBER='66423'
O/P:OOHA.FLOW_STATUS_CODE=BOOKED,OOLA.FLOW_STATUS_CODE=SHIPPED,WDD.RELEASED_STATUS=C,WND.STATUS_CODE:CL
BACKGROUND PROCESS:Bill of Lading,Packing Slip Report,Commercial Invoice,
Vehicle Load Sheet Details,Interface Trip Stop WILL RUN IN BACKGROUND
====RUN WORK FLOW BACKGROUND PROCESS TO IMPORT THE DATA INTO INVOICE INTERFACE TABLES ==
HERE IN BACKGROUND :Workflow Background Process,ADS, (Autoinvoice Master Program),
Autoinvoice Import Program,Prepayment Matching Program (Prepayments Matching Program) WILL RUN
HERE COPY THE INVOICE NO:10037642,AMOUNT:8,714.55 FROM ORDER ORGANIZER
==ENTERING THE RECEIPT IN MANUAL METHOD==
GO TO RECEIVALES VISION OPERATIONS->RECEIPTS->RECEIPTS->ENTER THE RECEIPT MANUALLY->APPLY TO ORDER ->SAVE
===CREATE ACCOUNTING==
LEDGER->VISION OPERATIONS(USA),END DATE:SYSDATE,ETC->SUBMIT
HERE IN BACKGROUND:Create Accounting,Accounting Program,Journal Import,Subledger Accounting Balances Update
WILL RUN IN BACKGROUND
COPY THE JOURNAL IMPORT REQUEST ID:5861766
===TRANSFER TO GENRAL LDGGER==
ledger:%5861766%
IN BACKGROUND Posting: Single Ledger WILL RUN
======COMPLETE O2C CYCLE==
====TECHNICAL FLOW OF O2C==
ENTER THE SALES ORDER
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA
OOHA.HEADER_ID=OOLA.HEADER_ID
BOOK THE SALES ORDER
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD
OOHA.HEADER_ID=OOLA.HEADER_ID
OOLA.LINE_ID=WDD.SOURCE_LINE_ID
PICK RELEASE THE SALES ORDER
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_DELIVERY_ASSIGNMENTS WDA,
WSH_NEW_DELIVERIES WND
OOHA.HEADER_ID=OOLA.HEADER_ID
OOLA.LINE_ID=WDD.SOURCE_LINE_ID
WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
WDA.DELIVERY_ID=WND.DELIVERY_ID
=TABLES EFFECTED B/W PICK RELEASE AND SHIP CONFIRM==
WSH_DELIVERY_LEGS WDL,
WSH_TRIPS WT,
WSH_TRIP_STOPS WTS
==SHIP CONFIRM THE ORDER==
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_DELIVERY_ASSIGNMENTS WDA,
WSH_NEW_DELIVERIES WND
OOHA.HEADER_ID=OOLA.HEADER_ID
OOLA.LINE_ID=WDD.SOURCE_LINE_ID
WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
WDA.DELIVERY_ID=WND.DELIVERY_ID
==AUTO INVOICE==
RA_INTERFACE_LINES_ALL RILA,
RA_INTERFACE_DISTRIBUTIONS_ALL RIDA
==TRANSACTIONS==
RA_CUSTOMER_TRX_ALL RCTA,
RA_CUSTOMER_TRX_LINES_ALL RCTLA
RCTA.CUSTOMER_TRX_ID=RCTLA.CUSTOMER_TRX_ID
==CASH RECEIPTS==
AR_PAYMENT_SCHEDULES_ALL APSA,
AR_CASH_RECEIPTS_ALL ACRA
==SUB LEDGER ACCOUNTING==
XLA_AE_HEADERS XAH (XAH.AE_HEADER_ID=XAL.AE_HEADER_ID,XAH.APPLICATION_ID=XAL.APPLICATION_ID)
XLA_AE_LINES XAL, (XAL.APPLICATION_ID=XDL.APPLICATION_ID,XAL.AE_LINE_NUM=XDL.AE_LINE_NUM)
XLA_EVENTS XE, (XAH.APPLICATION_ID=XE.APPLICATION_ID,XAH.EVENT_ID=XE.EVENT_ID)
XLA_TRANSACTION_ENTITIES XTE, (XAH.APPLICATION_ID=XTE.APPLICATION_ID,XAH.ENTITY_ID=XTE.ENTITY_ID)
XLA_DISTRIBUTION_LINKS XDL (XDL.APPLICATION_ID=XAH.APPLICATION_ID,XDL.AE_HEADER_ID=XAH.AE_HEADER_ID)
==GENERAL LEDGER ==
GL_JE_BATCHES GJB, GJB.JE_BATCH_ID=GJH.JE_BATCH_ID
GJ_JE_HEADERS GJH, GJH.JE_HEADER_ID=GJL.JE_HEADER_ID
GL_JE_LINES GJL, GJL.CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID,
(GJL.GL_SL_LINK_ID=XAL.GL_SL_LINK_ID,GJL.GL_SL_LINK_TABLE=XAL.GL_SL_LINK_TABLE)
(GJL.JE_HEADER_ID=GIR.JE_HEADER_ID,GJL.JE_LINE_NUM=GIR.JE_LINE_NUM)
GL_BALANCES GB, GB.CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID,
GL_CODE_COMBINATIONS GCC,(GCC.CODE_COMBINATION_ID=PRDA.
CODE_COMBINATION_ID,GCC.CODE_COMBINATION_ID=PDA.CODE_COMBINATION_ID)
GL_IMPORT_REFERENCES GIR
(GIR.GL_SL_LINK_ID=XAL.GL_SL_LINK_ID,GIR.GL_SL_LINK_TABLE=XAL.GL_SL_LINK_TABLE)
==MOVE ORDER TABLES==
MTL_TXN_REQUEST_HEADERS MTRH
MTL_TXN_REQUEST_LINES MTRL
MTL_MATERIAL_TRANSACTIONS MMT
MTL_DEMAND MD
MTL_SYSTEM_ITEMS_B MSIB
MTL_ONHAND_QUANTITIES MOQ
MTRH.HEADER_ID=MTRL.HEADER_ID
MSIB.ORGANIZATION_ID=MMT.ORGANIZATION_ID
MSIB.INVENTORY_ITEM_ID=MMT.INVENTORY_ITEM_ID
MSIB.ORGANIZATION_ID=MOQ.ORGANIZATION_ID
MSIB.INVENTORY_ITEM_ID=MOQ.INVENTORY_ITEM_ID
======================P2P CYCLE=====================
FIRST REQUISITION
ENTER THE ITEM,QUANTITY,NEED BY DATE->SAVE IT
THEN COPY THE REQUISITION NO:14318
SELECT PRHA.SEGMENT1 "REQ_NO",PRHA.AUTHORIZATION_STATUS
FROM
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA
--PO_REQ_DISTRIBUTIONS_ALL PRD
WHERE PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
--AND PRLA.REQUISITION_LINE_ID=PRD.REQUISITION_LINE_ID
AND PRHA.SEGMENT1='14318'
AT HEADERS LEVEL: O/P IS REQ_NO:14318,PRHA.AUTHORIZATION_STATUS=INCOMPLETE
===APPROVING THE REQUISITION==
SELECT PRHA.SEGMENT1 "REQ_NO",PRHA.AUTHORIZATION_STATUS,PRD.DISTRIBUTION_ID,PRD.DISTRIBUTION_NUM
FROM
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA,
PO_REQ_DISTRIBUTIONS_ALL PRD
WHERE PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND PRLA.REQUISITION_LINE_ID=PRD.REQUISITION_LINE_ID
AND PRHA.SEGMENT1='14318'
O/P:O/P IS REQ_NO:14318,PRHA.AUTHORIZATION_STATUS=APPROVED,PRD.DISTRIBUTION_ID=207077,PRD.DISTRIBUTION_NUM=1
===CREATE PUCHASE ORDER==
GO TO PURCHASE ORDERS->PURCHASE ORDERS->
GIVE THE SUPPLIER:DELL,ITEM,QUANTITY,NEED BY DATE,
GO TO SHIPMENTS->MORE->THER U CAN SEE THE MATCH APPROVE LEVEL(2-WAY(PO,INVOICE),3-WAY(PO,RECEIPT,INVOICE),
4-WAY(PO,RECEIPT,INVOICE,INSPECTION) WITH IN THE TOLLERENCE TIME)
GO TO DISTRIBUTIONS -> IF U WANT TO SHIP THE ITEM TO MORE THAN ONE SHIP TO ADDRESS
SAVE IT
THEN A PURCHASE ORDER NO WILL GENERATE :6040
NEXT APPROVE IT
SELECT PHA.SEGMENT1 "PO_NO",PHA.AUTHORIZATION_STATUS,PLA.LINE_NUM,PHA.PO_HEADER_ID,PLLA.PO_LINE_ID,PLLA.LINE_LOCATION_ID
FROM
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA,
PO_LINE_LOCATIONS_ALL PLLA,
PO_DISTRIBUTIONS_ALL PDA
WHERE PHA.PO_HEADER_ID=PLA.PO_HEADER_ID
AND PLA.PO_LINE_ID=PLLA.PO_LINE_ID
AND PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID
AND PHA.SEGMENT1='6040'
O/P:PO_NO:6040,AUTHORIZATION_STATUS:APPROVED,LINEE_NUM:1,PO_HEADER_ID:110486,PO_LINE_ID:173415,LINE_LOCATION_ID:264561
==RECEIVING->RECEIPTS->SELECT ORGANIZATION==
ENTER THE PURCHASE ORDER NO:6040 ->FIND
CHECK THE LINE,ENTER THE SUB INVENTORY->SAVE->THE CLICK ON HEADER AND SAVE THE RECEIPT NO:8460
SELECT DISTINCT RSH.RECEIPT_NUM,RSL.AMOUNT,RSH.SHIPMENT_HEADER_ID
FROM
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQ_DISTRIBUTIONS_ALL PRDA,
PO_REQUISITION_LINES_ALL PRLA,
PO_HEADERS_ALL PHA,
RCV_SHIPMENT_HEADERS RSH,
RCV_SHIPMENT_LINES RSL,
RCV_TRANSACTIONS RT,
PO_DISTRIBUTIONS_ALL PDA,
PO_LINES_ALL PLA,
PO_LINE_LOCATIONS_ALL PLLA
WHERE RSH.SHIPMENT_HEADER_ID=RSL.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID=RT.SHIPMENT_LINE_ID
AND PHA.PO_HEADER_ID=RT.PO_HEADER_ID
AND PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND PRLA.REQUISITION_LINE_ID=PRDA.REQUISITION_LINE_ID
AND PRDA.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID
AND PHA.PO_HEADER_ID=PDA.PO_HEADER_ID
AND PDA.PO_DISTRIBUTION_ID=RSL.PO_DISTRIBUTION_ID
AND PLA.PO_LINE_ID=PLLA.PO_LINE_ID
AND PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID
AND RSH.RECEIPT_NUM='8460'
--AND PHA.SEGMENT1='6040'
===PAYABLES VISION OPERATIONS==
GO TO INVOICES->INQUIRY->GIVE THE PO NUMBER->FIND->COPY THE INVOICE NO:ERS-8460-163753
THEN GO TO THE INVOICES->ENTRY ->VIEW->QUERY->ENTER THE INVOICE NO:ERS-8460-163753->VIEW->QUERY
THEN YOU MUST CHECK THE ACTIONS->VALIDATE->OK(STATUS WILL BE VALIDATED)
THEN ACTIONS CREATE ACCOUNTING(FINAL)->OK(HERE ACCOUNTING WILL BE CREATED FOR THE PERTICULAR TRANSACTION)
THEN ACTIONS PAY IN FILL->OK->IT WILL GO TO THE NEW WINDOW->THERE GIVE THE PAYMENT DATE->10-APR-2012,BANK ACCOUNT:AP/AR NETTING,
PAYMENT METHOD:AUTOMATICALLY IT WILL POP OUT,PAYMENT PROCESS PROFILE->ISABEL FOREIGN->SAVE IT
===THEN REQUEST FOR THE TRANSFER TO GENERAL LEDGER->
PARAMETERSLEDGER:Vision Operations (USA)
END DATE:10-APR-2012,
POST IN GENERAL LEDGER:NO
OK->SUBMIT->REQUEST->FIND->
IN BACKGROUND:Format Payment Instructions with Text Output,Transfer Journal Entries to GL,Journal Import,
Open Account Balances Data Manager,TB Worker 1 (Open Account Balances Data Manager Worker Process),
WILL RUN IN BACKGROUND
COPY THE JOURNAL IMPORT:5861787
===GO TO GENERAL LEDGER VISION OPERATIONS==
JOURNALS->ENTER->LEDGER:%5861787%->FIND->POST THE JOURNAL LEDGER->REVIEW THE JOURNAL LEDGER->
BOTH DEBIT AND CREDIT MUST MATCH
IN BACKGROUND:Posting: Single Ledger WILL RUN
INVOICE TABLES=
AP_INVOICES_ALL AIA,
AP_INVOICE_DISTRIBUTIONS_ALL AIDA
==ACCOUNTING ENTRIES TABLES==
AP_ACCOUNTING_EVENTS_ALL ACEA,
AP_AE_HEADERS_ALL AAHA,
AP_AE_LINES_ALL AALA
==PAYMENT TABLES==
AP_INVOICE_PAYMENTS_ALL AIPA,
AP_PAYMENT_SCHEDULES_ALL APSA,
AP_CHECKS_ALL ACA,
AP_CHECK_FORMATS ACF,
AP_BANK_ACCOUNTS_ALL ABAA,
AP_BANK_BRANCHES ABB,
AP_TERMS APT
===COMPLETE P2P CYCLE==
=====PROCURE TO PAY QUERY==
WITH OUT RECEIPTS
SELECT REQH.SEGMENT1 "REQ_NUM",REQH.AUTHORIZATION_STATUS "REQ_STATUS",
POH.PO_HEADER_ID,POH.SEGMENT1 "PO_NUM",POH.AUTHORIZATION_STATUS "PO_STATUS",I.INVOICE_NUM,I.INVOICE_ID,
I.INVOICE_AMOUNT,I.AMOUNT_PAID,I.VENDOR_ID,I.VENDOR_CONTACT_ID,I.VENDOR_SITE_ID,P.CHECK_ID,C.CHECK_NUMBER,H.GL_TRANSFER_FLAG,
H.PERIOD_NAME
FROM
AP_INVOICES_ALL I,
AP_INVOICE_DISTRIBUTIONS_ALL INVD,
PO_HEADERS_ALL POH,
PO_LINES_ALL POL,
PO_DISTRIBUTIONS_ALL POD,
AP_SUPPLIERS V,
PO_REQUISITION_HEADERS_ALL REQH,
PO_REQUISITION_LINES_ALL REQL,
PO_REQ_DISTRIBUTIONS_ALL REQD,
AP_INVOICE_PAYMENTS_ALL P,
AP_CHECKS_ALL C,
AP_AE_HEADERS_ALL H,
AP_AE_LINES_ALL L
WHERE 1=1
AND I.VENDOR_ID=V.VENDOR_ID
AND C.CHECK_ID=P.CHECK_ID
AND P.INVOICE_ID=I.INVOICE_ID
AND REQH.REQUISITION_HEADER_ID=REQL.REQUISITION_HEADER_ID
AND REQD.REQUISITION_LINE_ID=REQL.REQUISITION_LINE_ID
AND POD.REQ_DISTRIBUTION_ID=REQD.DISTRIBUTION_ID
AND POD.PO_HEADER_ID=POH.PO_HEADER_ID
AND POD.PO_DISTRIBUTION_ID=INVD.PO_DISTRIBUTION_ID
AND INVD.INVOICE_ID=I.INVOICE_ID
AND I.SOURCE='AP_INVOICES'
AND REQH.SEGMENT1=''
AND POH.SEGMENT1=''
AND I.INVOICE_NUM=''
AND C.CHECK_NUMBER=''
AND I.VENDOR_ID=''
======P2P QUERY WITH RECEIPTS==
SELECT
FROM
AP_INVOICES_ALL AIA,
AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA,
PO_DISTRIBUTIONS_ALL PDA,
PO_VENDORS PV,
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA,
PO_REQ_DISTRIBUTIONS_ALL PRDA,
RCV_TRANSACTIONS RT,
RCV_SHIPMENT_HEADERS RSH,
RCV_SHIPMENT_LINES RSL,
AP_INVOICE_PAYMENTS_ALL AIPA,
AP_CHECKS_ALL ACA,
AP_AE_HEADERS_ALL AAHA,
AP_AE_LINES_ALL AALA
WHERE 1=1
AND AIA.VENDOR_ID=PV.VENDOR_ID
AND ACA.CHECK_ID=AIPA.CHECK_ID
AND AIPA.INVOICE_ID=AIA.INVOICE_ID
AND PHA.PO_HEADER_ID=PLA.PO_HEADER_ID
AND PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND PRLA.REQUISITION_LINE_ID=PRDA.REQUISITION_LINE_ID
AND PRDA.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID
AND PDA.PO_HEADER_ID=PHA.PO_HEADER_ID
AND PHA.PO_HEADER_ID=RT.PO_HEADER_ID
AND RSH.SHIPMENT_HEADER_ID=RT.SHIPMENT_HEADER_ID(+)
AND RSH.SHIPMENT_HEADER_ID=RSL.SHIPMENT_HEADER_ID
AND RT.TRANSACTION_TYPE='RECEIVE'
AND RT.SOURCE_DOCUMENT_CODE='PO'
AND PLA.PO_LINE_ID=RT.PO_LINE_ID
AND PDA.PO_DISTRIBUTION_ID=RT.PO_DISTRIBUTION_ID
AND PDA.PO_DISTRIBUTION_ID=AIDA.PO_DISTRIBUTION_ID
AND AIDA.INVOICE_ID=AIA.INVOICE_ID
AND AAHA.AE_HEADER_ID=AALA.AE_HEADER_ID
AND AALA.SOURCE_TABLE='AP_INVOICES'
AND AALA.SOURCE_ID=AIA.INVOICE_ID
AND PHA.SEGMENT1=''
AND PRHA.SEGMENT1=''
AND AIA.INVOICE_NUM=''
AND ACA.CHECK_NUMBER=
AND RSH.RECEIPT_NUM=
AND PV.VENDOR_ID=
==PURCHASE ORDER TABLES WITH LINKS==
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA,
PO_REQ_DISTRIBUTIONS_ALL PRDA,
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA,
PO_LINE_LOCATIONS_ALL PLLA,
PO_DISTRIBUTIONS_ALL PDA,
PO_VENDORS PV,
PO_VENDOR_SITES_ALL PVS,
PO_VENDOR_CONTACTS PVC,
PER_ALL_PEOPLE_F PAPF
WHERE PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND PRLA.REQUISITION_LINE_ID=PRDA.REQUISITION_LINE_ID
AND PRDA.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID
AND PHA.PO_HEADER_ID=PLA.PO_HEADER_ID
AND PLA.PO_LINE_ID=PLLA.PO_LINE_ID
AND PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID
AND PHA.PO_HEADER_ID=PDA.PO_HEADER_ID
AND PHA.VENDOR_ID=PV.VENDOR_ID
AND PVS.VENDOR_SITE_ID=PHA.VENDOR_CONTACT_ID
AND PVC.VENDOR_CONTACT_ID=PHA.VENDOR_CONTACT_ID
AND PAPF.PERSON_ID=PHA.AGENT_ID
IMPORTANT COLUMNS IN THE TABLES
PO_REQUISITION_HEADERS_ALL PRHA
PRHA.REQUISITION_HEADER_ID
PRHA.PREPARER_ID
PRHA.SEGMENT1 "REQQ_NO"
PO_REQUISITION_LINES_ALL PRLA
PRLA.REQUISITION_LINE_ID
PRLA.REQUISITION_HEADER_ID
PRLA.LINE_NUM
PRLA.UNIT_PRICE
PRLA.QUANTITY
PRLA.QUANTITY_CANCELLED
PRLA.QUANTITY_DELIVERED
PRLA.QUANTITY_RECEIVED
PO_REQ_DISTRIBUTIONS_ALL PRDA
PRDA.DISTRIBUTION_ID
PRDA.REQUISITION_LINE_ID
PRDA.SET_OF_BOOKS_ID
PRDA.REQ_LINE_QUANTITY
PRDA.REQ_LINE_AMOUNT
PO_HEADERS_ALL PHA
PHA.PO_HEADER_ID
PHA.AGENT_ID
PHA.SEGMENT1
PHA.VENDOR_ID
PHA.VENDOR_SITE_ID
PHA.SHIP_TO_LOCATION_ID
PHA.BILL_TO_LOCATION_ID
PO_LINES_ALL PLA
PLA.PO_LINE_ID
PLA.PO_HEADER_ID
PLA.ITEM_DESCRIPTION
PLA.UNIT_PRICE
PLA.QUANTITY
PO_DISTRIBUTIONS_ALL PDA
PDA.PO_DISTRIBUTION_ID
PDA.PO_HEADER_ID
PDA.PO_LINE_ID
PDA.QUANTITY_ORDERED
PDA.REQ_DISTRIBUTION_ID
PO_VENDORS PV
PV.VENDOR_ID
PV.VENDOR_NAME
PV.SEGMENT1
PV.SET_OF_BOOKS_ID
PO_VENDOR_SITES_ALL PVS
PVS.VENDOR_SITE_ID
PVS.VENDOR_ID
PVS.VENDOR_SITE_CODE
PVS.ADDRESS_LINE1
PVS.CITY
PVS.PHONE
PO_VENDOR_CONTACTS PVC
PVC.VENDOR_SITE_ID
PVC.VENDOR_CONTACT_ID
PVC.PHONE
PER_ALL_PEOPLE_F PAPF
PAPF.PERSON_ID
PAPF.BUSINESS_GROUP_ID
PAPF.FULL_NAME
PAPF.EMAIL_ADDRESS
===========================END OF P2P==========================================
ORDER NO:66424
====ORDER ENTRY IN HEADERS===
SELECT OOHA.ORDER_NUMBER,OOHA.HEADER_ID,OOHA.FLOW_STATUS_CODE
FROM OE_ORDER_HEADERS_ALL OOHA
WHERE OOHA.ORDER_NUMBER='66407'
O/P: OOHA.FLOW_STATUS_CODE=ENTERED
====ORDER ENTERY IN LINES==
SELECT OOHA.ORDER_NUMBER,OOHA.FLOW_STATUS_CODE,OOLA.HEADER_ID,OOLA.LINE_ID,OOHA.HEADER_ID,OOLA.FLOW_STATUS_CODE
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOHA.ORDER_NUMBER='66407'
O/P: OOHA.FLOW_STATUS_CODE=ENTERED,OOLA.FLOW_STATUS_CODE=ENTERED
===========BOOKING THE ORDER====
SELECT OOHA.ORDER_NUMBER,OOHA.FLOW_STATUS_CODE,OOLA.HEADER_ID,OOLA.LINE_ID,OOHA.HEADER_ID,OOLA.FLOW_STATUS_CODE,
WDD.RELEASED_STATUS,WDD.DATE_REQUESTED
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND OOHA.ORDER_NUMBER='66407'
O/P:OOHA.FLOW_STATUS_CODE=BOOKED,OOLA.FLOW_STATUS_CODE=AWAITING_SHIPPING,WDD.RELEASED_STATUS=R
===========PICK RELEASE THE ORDER==
SELECT OOHA.ORDER_NUMBER,OOHA.FLOW_STATUS_CODE,OOLA.HEADER_ID,OOLA.LINE_ID,OOHA.HEADER_ID,OOLA.FLOW_STATUS_CODE,
WDD.RELEASED_STATUS,WDD.DATE_REQUESTED
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_NEW_DELIVERIES WND,
WSH_DELIVERY_ASSIGNMENTS WDA
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID=WND.DELIVERY_ID
AND OOHA.ORDER_NUMBER='66407'
5834765
O/P:OOHA.FLOW_STATUS_CODE=BOOKED,OOLA.FLOW_STATUS_CODE=AWAITING_SHIPPING,WDD.RELEASED_STATUS=R
===============SHIP CONFIRM THE ORDER==
SELECT OOHA.ORDER_NUMBER,OOHA.FLOW_STATUS_CODE,OOLA.HEADER_ID,OOLA.LINE_ID,OOHA.HEADER_ID,OOLA.FLOW_STATUS_CODE,
WDD.RELEASED_STATUS,WDD.DATE_REQUESTED,WDA.DELIVERY_ID,WDA.DELIVERY_DETAIL_ID,WND.DELIVERY_ID,WND.STATUS_CODE
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_NEW_DELIVERIES WND,
WSH_DELIVERY_ASSIGNMENTS WDA
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID=WND.DELIVERY_ID
AND OOHA.ORDER_NUMBER='66407'
O/P:OOHA.FLOW_STATUS_CODE=BOOKED,OOLA.FLOW_STATUS_CODE=AWAITING_SHIPPING,WDD.RELEASED_STATUS=Y,WND.STATUS_CODE:OPEN
IN THE BACK END:Pick Slip Report,Shipping Exceptions Report,Auto Pack Report (Auto-pack Report)
WILL RUN IN THE BACKGROUND
======SHIP CONFIRM THE ORDER==
SELECT OOHA.ORDER_NUMBER,OOHA.FLOW_STATUS_CODE,OOLA.HEADER_ID,OOLA.LINE_ID,OOHA.HEADER_ID,OOLA.FLOW_STATUS_CODE,
WDD.RELEASED_STATUS,WDD.DATE_REQUESTED,WDA.DELIVERY_ID,WDA.DELIVERY_DETAIL_ID,WND.DELIVERY_ID,WND.STATUS_CODE
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_NEW_DELIVERIES WND,
WSH_DELIVERY_ASSIGNMENTS WDA
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID=WND.DELIVERY_ID
AND OOHA.ORDER_NUMBER='66407'
O/P:OOHA.FLOW_STATUS_CODE=BOOKED,OOLA.FLOW_STATUS_CODE=SHIPPED,WDD.RELEASED_STATUS=C,WND.STATUS_CODE:CL
BACKGROUND PROCESS:Bill of Lading,Packing Slip Report,Commercial Invoice,
Vehicle Load Sheet Details,Interface Trip Stop WILL RUN IN BACKGROUND
====RUN WORK FLOW BACKGROUND PROCESS TO IMPORT THE DATA INTO INVOICE INTERFACE TABLES ==
HERE IN BACKGROUND :Workflow Background Process,ADS, (Autoinvoice Master Program),
Autoinvoice Import Program,Prepayment Matching Program (Prepayments Matching Program) WILL RUN
HERE COPY THE INVOICE NO:10037642,AMOUNT:8,714.55 FROM ORDER ORGANIZER
==ENTERING THE RECEIPT IN MANUAL METHOD==
GO TO RECEIVALES VISION OPERATIONS->RECEIPTS->RECEIPTS->ENTER THE RECEIPT MANUALLY->APPLY TO ORDER ->SAVE
===CREATE ACCOUNTING==
LEDGER->VISION OPERATIONS(USA),END DATE:SYSDATE,ETC->SUBMIT
HERE IN BACKGROUND:Create Accounting,Accounting Program,Journal Import,Subledger Accounting Balances Update
WILL RUN IN BACKGROUND
COPY THE JOURNAL IMPORT REQUEST ID:5861766
===TRANSFER TO GENRAL LDGGER==
ledger:%5861766%
IN BACKGROUND Posting: Single Ledger WILL RUN
======COMPLETE O2C CYCLE==
====TECHNICAL FLOW OF O2C==
ENTER THE SALES ORDER
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA
OOHA.HEADER_ID=OOLA.HEADER_ID
BOOK THE SALES ORDER
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD
OOHA.HEADER_ID=OOLA.HEADER_ID
OOLA.LINE_ID=WDD.SOURCE_LINE_ID
PICK RELEASE THE SALES ORDER
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_DELIVERY_ASSIGNMENTS WDA,
WSH_NEW_DELIVERIES WND
OOHA.HEADER_ID=OOLA.HEADER_ID
OOLA.LINE_ID=WDD.SOURCE_LINE_ID
WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
WDA.DELIVERY_ID=WND.DELIVERY_ID
=TABLES EFFECTED B/W PICK RELEASE AND SHIP CONFIRM==
WSH_DELIVERY_LEGS WDL,
WSH_TRIPS WT,
WSH_TRIP_STOPS WTS
==SHIP CONFIRM THE ORDER==
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_DELIVERY_ASSIGNMENTS WDA,
WSH_NEW_DELIVERIES WND
OOHA.HEADER_ID=OOLA.HEADER_ID
OOLA.LINE_ID=WDD.SOURCE_LINE_ID
WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
WDA.DELIVERY_ID=WND.DELIVERY_ID
==AUTO INVOICE==
RA_INTERFACE_LINES_ALL RILA,
RA_INTERFACE_DISTRIBUTIONS_ALL RIDA
==TRANSACTIONS==
RA_CUSTOMER_TRX_ALL RCTA,
RA_CUSTOMER_TRX_LINES_ALL RCTLA
RCTA.CUSTOMER_TRX_ID=RCTLA.CUSTOMER_TRX_ID
==CASH RECEIPTS==
AR_PAYMENT_SCHEDULES_ALL APSA,
AR_CASH_RECEIPTS_ALL ACRA
==SUB LEDGER ACCOUNTING==
XLA_AE_HEADERS XAH (XAH.AE_HEADER_ID=XAL.AE_HEADER_ID,XAH.APPLICATION_ID=XAL.APPLICATION_ID)
XLA_AE_LINES XAL, (XAL.APPLICATION_ID=XDL.APPLICATION_ID,XAL.AE_LINE_NUM=XDL.AE_LINE_NUM)
XLA_EVENTS XE, (XAH.APPLICATION_ID=XE.APPLICATION_ID,XAH.EVENT_ID=XE.EVENT_ID)
XLA_TRANSACTION_ENTITIES XTE, (XAH.APPLICATION_ID=XTE.APPLICATION_ID,XAH.ENTITY_ID=XTE.ENTITY_ID)
XLA_DISTRIBUTION_LINKS XDL (XDL.APPLICATION_ID=XAH.APPLICATION_ID,XDL.AE_HEADER_ID=XAH.AE_HEADER_ID)
==GENERAL LEDGER ==
GL_JE_BATCHES GJB, GJB.JE_BATCH_ID=GJH.JE_BATCH_ID
GJ_JE_HEADERS GJH, GJH.JE_HEADER_ID=GJL.JE_HEADER_ID
GL_JE_LINES GJL, GJL.CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID,
(GJL.GL_SL_LINK_ID=XAL.GL_SL_LINK_ID,GJL.GL_SL_LINK_TABLE=XAL.GL_SL_LINK_TABLE)
(GJL.JE_HEADER_ID=GIR.JE_HEADER_ID,GJL.JE_LINE_NUM=GIR.JE_LINE_NUM)
GL_BALANCES GB, GB.CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID,
GL_CODE_COMBINATIONS GCC,(GCC.CODE_COMBINATION_ID=PRDA.
CODE_COMBINATION_ID,GCC.CODE_COMBINATION_ID=PDA.CODE_COMBINATION_ID)
GL_IMPORT_REFERENCES GIR
(GIR.GL_SL_LINK_ID=XAL.GL_SL_LINK_ID,GIR.GL_SL_LINK_TABLE=XAL.GL_SL_LINK_TABLE)
==MOVE ORDER TABLES==
MTL_TXN_REQUEST_HEADERS MTRH
MTL_TXN_REQUEST_LINES MTRL
MTL_MATERIAL_TRANSACTIONS MMT
MTL_DEMAND MD
MTL_SYSTEM_ITEMS_B MSIB
MTL_ONHAND_QUANTITIES MOQ
MTRH.HEADER_ID=MTRL.HEADER_ID
MSIB.ORGANIZATION_ID=MMT.ORGANIZATION_ID
MSIB.INVENTORY_ITEM_ID=MMT.INVENTORY_ITEM_ID
MSIB.ORGANIZATION_ID=MOQ.ORGANIZATION_ID
MSIB.INVENTORY_ITEM_ID=MOQ.INVENTORY_ITEM_ID
======================P2P CYCLE=====================
FIRST REQUISITION
ENTER THE ITEM,QUANTITY,NEED BY DATE->SAVE IT
THEN COPY THE REQUISITION NO:14318
SELECT PRHA.SEGMENT1 "REQ_NO",PRHA.AUTHORIZATION_STATUS
FROM
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA
--PO_REQ_DISTRIBUTIONS_ALL PRD
WHERE PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
--AND PRLA.REQUISITION_LINE_ID=PRD.REQUISITION_LINE_ID
AND PRHA.SEGMENT1='6037'
AT HEADERS LEVEL: O/P IS REQ_NO:14318,PRHA.AUTHORIZATION_STATUS=INCOMPLETE
===APPROVING THE REQUISITION==
SELECT PRHA.SEGMENT1 "REQ_NO",PRHA.AUTHORIZATION_STATUS,PRD.DISTRIBUTION_ID,PRD.DISTRIBUTION_NUM
FROM
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA,
PO_REQ_DISTRIBUTIONS_ALL PRD
WHERE PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND PRLA.REQUISITION_LINE_ID=PRD.REQUISITION_LINE_ID
AND PRHA.SEGMENT1='14318'
O/P:O/P IS REQ_NO:14318,PRHA.AUTHORIZATION_STATUS=APPROVED,PRD.DISTRIBUTION_ID=207077,PRD.DISTRIBUTION_NUM=1
===CREATE PUCHASE ORDER==
GO TO PURCHASE ORDERS->PURCHASE ORDERS->
GIVE THE SUPPLIER:DELL,ITEM,QUANTITY,NEED BY DATE,
GO TO SHIPMENTS->MORE->THER U CAN SEE THE MATCH APPROVE LEVEL(2-WAY(PO,INVOICE),3-WAY(PO,RECEIPT,INVOICE),
4-WAY(PO,RECEIPT,INVOICE,INSPECTION) WITH IN THE TOLLERENCE TIME)
GO TO DISTRIBUTIONS -> IF U WANT TO SHIP THE ITEM TO MORE THAN ONE SHIP TO ADDRESS
SAVE IT
THEN A PURCHASE ORDER NO WILL GENERATE :6040
NEXT APPROVE IT
SELECT PHA.SEGMENT1 "PO_NO",PHA.AUTHORIZATION_STATUS,PLA.LINE_NUM,PHA.PO_HEADER_ID,PLLA.PO_LINE_ID,PLLA.LINE_LOCATION_ID
FROM
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA,
PO_LINE_LOCATIONS_ALL PLLA,
PO_DISTRIBUTIONS_ALL PDA
WHERE PHA.PO_HEADER_ID=PLA.PO_HEADER_ID
AND PLA.PO_LINE_ID=PLLA.PO_LINE_ID
AND PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID
AND PHA.SEGMENT1='6037'
8460,ERS-8460-163693,5834774
Transfer Journal Entries to GL,Journal Import,Open Account Balances Data Manager,TB Worker 1 (Open Account Balances Data Manager Worker Process)
O/P:PO_NO:6040,AUTHORIZATION_STATUS:APPROVED,LINEE_NUM:1,PO_HEADER_ID:110486,PO_LINE_ID:173415,LINE_LOCATION_ID:264561
==RECEIVING->RECEIPTS->SELECT ORGANIZATION==
ENTER THE PURCHASE ORDER NO:6040 ->FIND
CHECK THE LINE,ENTER THE SUB INVENTORY->SAVE->THE CLICK ON HEADER AND SAVE THE RECEIPT NO:8460
SELECT DISTINCT RSH.RECEIPT_NUM,RSL.AMOUNT,RSH.SHIPMENT_HEADER_ID
FROM
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQ_DISTRIBUTIONS_ALL PRDA,
PO_REQUISITION_LINES_ALL PRLA,
PO_HEADERS_ALL PHA,
RCV_SHIPMENT_HEADERS RSH,
RCV_SHIPMENT_LINES RSL,
RCV_TRANSACTIONS RT,
PO_DISTRIBUTIONS_ALL PDA,
PO_LINES_ALL PLA,
PO_LINE_LOCATIONS_ALL PLLA
WHERE RSH.SHIPMENT_HEADER_ID=RSL.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID=RT.SHIPMENT_LINE_ID
AND PHA.PO_HEADER_ID=RT.PO_HEADER_ID
AND PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND PRLA.REQUISITION_LINE_ID=PRDA.REQUISITION_LINE_ID
AND PRDA.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID
AND PHA.PO_HEADER_ID=PDA.PO_HEADER_ID
AND PDA.PO_DISTRIBUTION_ID=RSL.PO_DISTRIBUTION_ID
AND PLA.PO_LINE_ID=PLLA.PO_LINE_ID
AND PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID
AND RSH.RECEIPT_NUM='8460'
--AND PHA.SEGMENT1='6040'
===PAYABLES VISION OPERATIONS==
GO TO INVOICES->INQUIRY->GIVE THE PO NUMBER->FIND->COPY THE INVOICE NO:ERS-8460-163753
THEN GO TO THE INVOICES->ENTRY ->VIEW->QUERY->ENTER THE INVOICE NO:ERS-8460-163753->VIEW->QUERY
THEN YOU MUST CHECK THE ACTIONS->VALIDATE->OK(STATUS WILL BE VALIDATED)
THEN ACTIONS CREATE ACCOUNTING(FINAL)->OK(HERE ACCOUNTING WILL BE CREATED FOR THE PERTICULAR TRANSACTION)
THEN ACTIONS PAY IN FILL->OK->IT WILL GO TO THE NEW WINDOW->THERE GIVE THE PAYMENT DATE->10-APR-2012,BANK ACCOUNT:AP/AR NETTING,
PAYMENT METHOD:AUTOMATICALLY IT WILL POP OUT,PAYMENT PROCESS PROFILE->ISABEL FOREIGN->SAVE IT
===THEN REQUEST FOR THE TRANSFER TO GENERAL LEDGER->
PARAMETERSLEDGER:Vision Operations (USA)
END DATE:10-APR-2012,
POST IN GENERAL LEDGER:NO
OK->SUBMIT->REQUEST->FIND->
IN BACKGROUND:Format Payment Instructions with Text Output,Transfer Journal Entries to GL,Journal Import,
Open Account Balances Data Manager,TB Worker 1 (Open Account Balances Data Manager Worker Process),
WILL RUN IN BACKGROUND
COPY THE JOURNAL IMPORT:5861787
===GO TO GENERAL LEDGER VISION OPERATIONS==
JOURNALS->ENTER->LEDGER:%5861787%->FIND->POST THE JOURNAL LEDGER->REVIEW THE JOURNAL LEDGER->
BOTH DEBIT AND CREDIT MUST MATCH
IN BACKGROUND:Posting: Single Ledger WILL RUN
INVOICE TABLES=
AP_INVOICES_ALL AIA,
AP_INVOICE_DISTRIBUTIONS_ALL AIDA
==ACCOUNTING ENTRIES TABLES==
AP_ACCOUNTING_EVENTS_ALL ACEA,
AP_AE_HEADERS_ALL AAHA,
AP_AE_LINES_ALL AALA
==PAYMENT TABLES==
AP_INVOICE_PAYMENTS_ALL AIPA,
AP_PAYMENT_SCHEDULES_ALL APSA,
AP_CHECKS_ALL ACA,
AP_CHECK_FORMATS ACF,
AP_BANK_ACCOUNTS_ALL ABAA,
AP_BANK_BRANCHES ABB,
AP_TERMS APT
===COMPLETE P2P CYCLE==
=====PROCURE TO PAY QUERY==
WITH OUT RECEIPTS
SELECT REQH.SEGMENT1 "REQ_NUM",REQH.AUTHORIZATION_STATUS "REQ_STATUS",
POH.PO_HEADER_ID,POH.SEGMENT1 "PO_NUM",POH.AUTHORIZATION_STATUS "PO_STATUS",I.INVOICE_NUM,I.INVOICE_ID,
I.INVOICE_AMOUNT,I.AMOUNT_PAID,I.VENDOR_ID,I.VENDOR_CONTACT_ID,I.VENDOR_SITE_ID,P.CHECK_ID,C.CHECK_NUMBER,H.GL_TRANSFER_FLAG,
H.PERIOD_NAME
FROM
AP_INVOICES_ALL I,
AP_INVOICE_DISTRIBUTIONS_ALL INVD,
PO_HEADERS_ALL POH,
PO_LINES_ALL POL,
PO_DISTRIBUTIONS_ALL POD,
AP_SUPPLIERS V,
PO_REQUISITION_HEADERS_ALL REQH,
PO_REQUISITION_LINES_ALL REQL,
PO_REQ_DISTRIBUTIONS_ALL REQD,
AP_INVOICE_PAYMENTS_ALL P,
AP_CHECKS_ALL C,
AP_AE_HEADERS_ALL H,
AP_AE_LINES_ALL L
WHERE 1=1
AND I.VENDOR_ID=V.VENDOR_ID
AND C.CHECK_ID=P.CHECK_ID
AND P.INVOICE_ID=I.INVOICE_ID
AND REQH.REQUISITION_HEADER_ID=REQL.REQUISITION_HEADER_ID
AND REQD.REQUISITION_LINE_ID=REQL.REQUISITION_LINE_ID
AND POD.REQ_DISTRIBUTION_ID=REQD.DISTRIBUTION_ID
AND POD.PO_HEADER_ID=POH.PO_HEADER_ID
AND POD.PO_DISTRIBUTION_ID=INVD.PO_DISTRIBUTION_ID
AND INVD.INVOICE_ID=I.INVOICE_ID
AND I.SOURCE='AP_INVOICES'
AND REQH.SEGMENT1=''
AND POH.SEGMENT1=''
AND I.INVOICE_NUM=''
AND C.CHECK_NUMBER=''
AND I.VENDOR_ID=''
======P2P QUERY WITH RECEIPTS==
SELECT
FROM
AP_INVOICES_ALL AIA,
AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA,
PO_DISTRIBUTIONS_ALL PDA,
PO_VENDORS PV,
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA,
PO_REQ_DISTRIBUTIONS_ALL PRDA,
RCV_TRANSACTIONS RT,
RCV_SHIPMENT_HEADERS RSH,
RCV_SHIPMENT_LINES RSL,
AP_INVOICE_PAYMENTS_ALL AIPA,
AP_CHECKS_ALL ACA,
AP_AE_HEADERS_ALL AAHA,
AP_AE_LINES_ALL AALA
WHERE 1=1
AND AIA.VENDOR_ID=PV.VENDOR_ID
AND ACA.CHECK_ID=AIPA.CHECK_ID
AND AIPA.INVOICE_ID=AIA.INVOICE_ID
AND PHA.PO_HEADER_ID=PLA.PO_HEADER_ID
AND PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND PRLA.REQUISITION_LINE_ID=PRDA.REQUISITION_LINE_ID
AND PRDA.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID
AND PDA.PO_HEADER_ID=PHA.PO_HEADER_ID
AND PHA.PO_HEADER_ID=RT.PO_HEADER_ID
AND RSH.SHIPMENT_HEADER_ID=RT.SHIPMENT_HEADER_ID(+)
AND RSH.SHIPMENT_HEADER_ID=RSL.SHIPMENT_HEADER_ID
AND RT.TRANSACTION_TYPE='RECEIVE'
AND RT.SOURCE_DOCUMENT_CODE='PO'
AND PLA.PO_LINE_ID=RT.PO_LINE_ID
AND PDA.PO_DISTRIBUTION_ID=RT.PO_DISTRIBUTION_ID
AND PDA.PO_DISTRIBUTION_ID=AIDA.PO_DISTRIBUTION_ID
AND AIDA.INVOICE_ID=AIA.INVOICE_ID
AND AAHA.AE_HEADER_ID=AALA.AE_HEADER_ID
AND AALA.SOURCE_TABLE='AP_INVOICES'
AND AALA.SOURCE_ID=AIA.INVOICE_ID
AND PHA.SEGMENT1=''
AND PRHA.SEGMENT1=''
AND AIA.INVOICE_NUM=''
AND ACA.CHECK_NUMBER=
AND RSH.RECEIPT_NUM=
AND PV.VENDOR_ID=
==PURCHASE ORDER TABLES WITH LINKS==
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA,
PO_REQ_DISTRIBUTIONS_ALL PRDA,
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA,
PO_LINE_LOCATIONS_ALL PLLA,
PO_DISTRIBUTIONS_ALL PDA,
PO_VENDORS PV,
PO_VENDOR_SITES_ALL PVS,
PO_VENDOR_CONTACTS PVC,
PER_ALL_PEOPLE_F PAPF
WHERE PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND PRLA.REQUISITION_LINE_ID=PRDA.REQUISITION_LINE_ID
AND PRDA.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID
AND PHA.PO_HEADER_ID=PLA.PO_HEADER_ID
AND PLA.PO_LINE_ID=PLLA.PO_LINE_ID
AND PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID
AND PHA.PO_HEADER_ID=PDA.PO_HEADER_ID
AND PHA.VENDOR_ID=PV.VENDOR_ID
AND PVS.VENDOR_SITE_ID=PHA.VENDOR_CONTACT_ID
AND PVC.VENDOR_CONTACT_ID=PHA.VENDOR_CONTACT_ID
AND PAPF.PERSON_ID=PHA.AGENT_ID
IMPORTANT COLUMNS IN THE TABLES
PO_REQUISITION_HEADERS_ALL PRHA
PRHA.REQUISITION_HEADER_ID
PRHA.PREPARER_ID
PRHA.SEGMENT1 "REQQ_NO"
PO_REQUISITION_LINES_ALL PRLA
PRLA.REQUISITION_LINE_ID
PRLA.REQUISITION_HEADER_ID
PRLA.LINE_NUM
PRLA.UNIT_PRICE
PRLA.QUANTITY
PRLA.QUANTITY_CANCELLED
PRLA.QUANTITY_DELIVERED
PRLA.QUANTITY_RECEIVED
PO_REQ_DISTRIBUTIONS_ALL PRDA
PRDA.DISTRIBUTION_ID
PRDA.REQUISITION_LINE_ID
PRDA.SET_OF_BOOKS_ID
PRDA.REQ_LINE_QUANTITY
PRDA.REQ_LINE_AMOUNT
PO_HEADERS_ALL PHA
PHA.PO_HEADER_ID
PHA.AGENT_ID
PHA.SEGMENT1
PHA.VENDOR_ID
PHA.VENDOR_SITE_ID
PHA.SHIP_TO_LOCATION_ID
PHA.BILL_TO_LOCATION_ID
PO_LINES_ALL PLA
PLA.PO_LINE_ID
PLA.PO_HEADER_ID
PLA.ITEM_DESCRIPTION
PLA.UNIT_PRICE
PLA.QUANTITY
PO_DISTRIBUTIONS_ALL PDA
PDA.PO_DISTRIBUTION_ID
PDA.PO_HEADER_ID
PDA.PO_LINE_ID
PDA.QUANTITY_ORDERED
PDA.REQ_DISTRIBUTION_ID
PO_VENDORS PV
PV.VENDOR_ID
PV.VENDOR_NAME
PV.SEGMENT1
PV.SET_OF_BOOKS_ID
PO_VENDOR_SITES_ALL PVS
PVS.VENDOR_SITE_ID
PVS.VENDOR_ID
PVS.VENDOR_SITE_CODE
PVS.ADDRESS_LINE1
PVS.CITY
PVS.PHONE
PO_VENDOR_CONTACTS PVC
PVC.VENDOR_SITE_ID
PVC.VENDOR_CONTACT_ID
PVC.PHONE
PER_ALL_PEOPLE_F PAPF
PAPF.PERSON_ID
PAPF.BUSINESS_GROUP_ID
PAPF.FULL_NAME
PAPF.EMAIL_ADDRESS
===========================END OF P2P==========================================
10037522,13,847.34
No comments:
Post a Comment