Backup Order to cash Cycle

CREATE A ITEM IN THE INVENTORY AND CHECK THE BACKEND TABLE
==========================================================
SELECT * FROM MTL_SYSTEM_ITEMS_B WHERE SEGMENT1 LIKE 'R2R%'

INCREASE THE QUANTITY OF THE ITEM
=================================
SELECT * FROM  MTL_ONHAND_QUANTITIES WHERE INVENTORY_ITEM_ID='248207'

NOW THE ITEM IS CREATED
=======================


NOW GOT TO ORDER MANAGEMENT CREATE THE SALES ORDER
==================================================

SELECT * FROM OE_ORDER_HEADERS_ALL WHERE ORDER_NUMBER='69380' -- FLOW_STATUS_CODE SHOWS THE ITEM IS 'ENTERED'THAT MEANS THAT ORDER HAS BEEN  CREADTED
SELECT * FROM OE_ORDER_LINES_ALL WHERE HEADER_ID='367828'-- THIS TABLE TELLS HOW MUCH QUANTITY THE ORDERS ARE CREATED



NOW THE SALES ORDERS ARE CREATED NOW WE HAVE TO BOOK THE SALES ORDERS
NOW WE HAVE  TO BOOK THE SALES ORDERS THAT ARE CREATED AND CONFIRM THE ORDERS THAT ARE RECIEVED BY THE CUSTOMERS
=================================================================================================================

SELECT * FROM OE_ORDER_HEADERS_ALL WHERE ORDER_NUMBER='69380' -- FLOW_STATUS_CODE SHOWS THE ITEM IS 'BOOKED' THAT MEANS THAT THE ORDER IS BOOKED
SELECT * FROM OE_ORDER_LINES_ALL WHERE HEADER_ID='367828'

NOW THE ORDERS ARE BOOKED NOW WE HAVE TO RELEASE THE SALES ORDERS WE CAN CHECK THE STATUS OF THE ORDERS IN THE ORDER ORGANISER, SEE BELOW NAVIGATION
NOW WHEN YOU GO TO ORDER RETURNS AND ORDER ORGANIZER==>ADDITIONAL INFORMATION==>DELIVERIES==>PICK STATUS==> READY TO RELEASE
=============================================================================================================================
SELECT * FROM WSH_DELIVERY_DETAILS WHERE INVENTORY_ITEM_ID=248207-- RELEASED STATUS -'R'==> READY TO RELEASE
SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_DETAIL_ID=6228053


TO RELASE THE SALES ORDERS WE GO TO SHIPPING ==>RELEASE SALES ORDERS==> SALES ORDERS GIVE THE ORDER NUMBER AND RUN THE CONCURRENT PROGRAM THEN THE FOLLOWING JOBS KICK OFF
===========================================================================================================================================================================
THEN THE EFFECTED BACKEND TABLES ARE                             --RELEASES STATUS-'s' ==>PICK RELEASE
SELECT * FROM WSH_DELIVERY_DETAILS WHERE INVENTORY_ITEM_ID=248207-- RELEASED STATUS -'Y'==> PICK CONFIRM
SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_DETAIL_ID=6228053
SELECT * FROM MTL_RESERVATIONS  WHERE INVENTORY_ITEM_ID=248207-- THIS TABLE TELLS THE INFORMATION THE INFORMATIONS HOW MUCH QUANTITY IS RESERVED  AT THE STAGING AREA AND THE DATA IN IT GETS FREEZED ONCE THE SALES ORDERS AEE SHIPPED
SELECT * FROM MTL_TXN_REQUEST_HEADERS WHERE REQUEST_NUMBER='6397347'-- THIS TABLE GIVES THE INFORMATION ABOUT THE QUANTITY OF THE SALES ORDER THAT ARE TRANSFERED FROM INVENTORY TO STAGING AREA
SELECT * FROM MTL_TXN_REQUEST_LINES WHERE HEADER_ID= '6397348'--EVEN THIS TABLE GIVES THE INFORMATION ABOUT THE ORDERS THAT ARE MOVED FROM INVENTORY TO STAGING AREA


NOW THE ABOVE SALES ORDERS ARE RELEASED NOW WE HAVE TO SHIP THE SALES ORDERS
============================================================================

FOR THIS WE HAVE TO GO TO SHIPPING==>TRANSACTIONS==>GIVE THE ORDER NUMBER AND CONFIRM THE SHIP
===============================================================================================
ONCE YOU CONFIRM THE SHIP IT KICKS OFF THE STANDRDS JOBS


THEN THE FOLLOWING TABNLES ARE EFFECTED IN THE BACKEND
=======================================================
SELECT * FROM WSH_DELIVERY_DETAILS WHERE INVENTORY_ITEM_ID=248207-- RELEASED STATUS -'C'==> SHIP CONFIRMED
SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_DETAIL_ID=6228053
SELECT * FROM MTL_RESERVATIONS  WHERE INVENTORY_ITEM_ID=248207-- AT THIS STAGE WE DONT HAVE ANY DATA ONCE THE SALES ORDERS ARE SHIPPED
SELECT * FROM MTL_TXN_REQUEST_HEADERS WHERE REQUEST_NUMBER='6397347'-- THIS TABLE GIVES THE INFORMATION ABOUT THE QUANTITY OF THE SALES ORDER THAT ARE TRANSFERED FROM INVENTORY TO STAGING AREA
SELECT * FROM MTL_TXN_REQUEST_LINES WHERE HEADER_ID= '6397348'--EVEN THIS TABLE GIVES THE INFORMATION ABOUT THE ORDERS THAT ARE MOVED FROM INVENTORY TO STAGING AREA

NOW ONCE THE SALES ORDERS ARE SHIPPED THEN WE CAN CHECK THE STATUS OF THE ORDERS FROM ORDER ORGANIZER ==>ADDITIONAL INFORMATION==>DELIVERIERS==>VIEW DELIVERY DETAILS
PICK STATUS==>SHIPPED

IF YOU SEE THYE DELIVERY LINE DETAILS WE SEE IT HAS INTERFACED IT MEANS THAT THE DATA OF THE SALES ORDERS ARE INTERFACD TO AR INTERFACE TABLES.


SELECT * FROM FND_TABLES WHERE TABLE_NAME LIKE 'RA%INTERFACE%'


SELECT * FROM RA_INTERFACE_LINES_ALL WHERE INTERFACE_LINE_ATTRIBUTE1='69380'--ORDER NUMBER AND INTERFACE_LINE_ATTRIBUTE3='6248833'--DELIVERY NUMBER

NOW WE HAVE TO RUN THE WORKFLOWBACKGROUND PROCESS THROUGH SRS WINDOW IN ORDER TO TRANSFER THE ORDERS FROM ORDER MANAGEMENT MODULE TO ACCOUNT RECIEVABLES MODULE
===============================================================================================================================================================


NOW IN THE FRONT END GIVE THE REFERENCE COLUMN WITH THE ORDER NUMBER AND CTR+F11
SELECT * FROM RA_CUSTOMER_TRX_ALL WHERE TRX_NUMBER='10068382'-- THIS TABLE CONTAINS THE INFORMATION OF THE SALES ORDER.WITH SALES ORDER NUMBER IN INTERFACE_HEADER_ATTRIBUTE1 COLUMN
SELECT * FROM RA_CUSTOMER_TRX_LINES_ALL WHERE CUSTOMER_TRX_ID='1254197'--THIS TABLE HAS THE INFORMATION OF THE SALES ORDERS INCLUDING THE TAXES OF THE ORDER
SELECT * FROM RA_CUST_TRX_LINE_GL_DIST_ALL WHERE CUSTOMER_TRX_LINE_ID='2007389'--THIS TABLE HAS THE 'EVENT_ID' THIS TABLE HAS THE INFORMATION OF THE GL_CODE_COMBINBATION TO THE WHICH THE AMOUNT HAS TO BE TRANSFERRED
SELECT SEGMENT1||SEGMENT2||SEGMENT3||SEGMENT4||SEGMENT5 FROM GL_CODE_COMBINATIONS WHERE CODE_COMBINATION_ID=12875


NOW ONCE THE DATA IS IN RECIEVABLES WE NEED TO CREATE ACCOUNTING FOR THE ABOVE SALES ORDERS
===========================================================================================
NAVIGATION==>TOOLS==>CREATING ACCOUNTING==>ACCOUNTING TO GL==>OK THE THE FOLLOWING PROGRAMS RUN IN THE BACKGROUND
SELECT * FROM XLA_EVENTS WHERE EVENT_ID='6229567'--PROCESS_STATUS_CODE='P' THAT MEANS THAT THE ABOVE SALES ORDERS ARE POSTED TO GL
SELECT * FROM XLA_AE_HEADERS WHERE EVENT_ID='6229567'--THIS TABLE HAS THE GL_TRANSFER_STATUS_CODE AS 'Y' THAT MEANS THEY ARE TRANSFERED TO GL
SELECT * FROM XLA_AE_LINES WHERE AE_HEADER_ID='8115566'--THIS CONTAINS THE LINES DETAILS WITH TAX INFORMATIOM



NOW CHECK THE GL TABLES
=======================
SELECT * FROM GL_JE_BATCHES WHERE NAME LIKE '%Receivables A 3829422 7539160%'-- THIS TABLE HAS THE BATCHE NAME WHICH WE CAN GET FROM THE JOURNAL IMPORT PROGRAM
SELECT * FROM GL_JE_HEADERS WHERE JE_BATCH_ID='5362730'-- THIS TABLE HAS THE JE_BATCH_ID WHICH GIVES THE COMPLETE INFORMATION OF THE RECIEVABLES WJ=ITH JE_SOURCE
SELECT * FROM GL_JE_LINES WHERE JE_HEADER_ID='7116873'--THIS TABLE HAS THE LINES INFORMATION OF THE ABOVE TRANSACTIONS FROM AR


NOW WE NEED TO POST THE BALANCES TO GL
======================================

SHIFT THE RESPONSIBILITY TO GENERAL LEDGER, IFRS REPORTING VISION OPS
THEN OPEN THE PERIODS IF THEY ARE NOT OPEN BY GOING TO OPEN/CLOSE PERIODS AND THEN POST THE JOURNALS
====================================================================================================
SELECT * FROM GL_BALANCES WHERE PERIOD_NAME LIKE 'Oct-17%' AND CODE_COMBINATION_ID='12875' ORDER BY LAST_UPDATE_DATE DESC


NOW THE INVOICES HAVE BEEN POSTED NEXT WE NEED TO CREATE THE RECIEPTS FOR THE ABOVE INVOICES
============================================================================================
CASH RECIEPTS
=============
SWITCH TO AR RESPONSIBILITY

THEN GO TO RECIEPT AND CREATE IT
GIVE THE RECIEPT NUMBER AS ORDER NUMBER AND TRANS NUMBER IS THE NUMBER THAT WE  GET FROM RA_CUSTOMER_TRX_ALL THAT ARE CREAT5ED WHEN WE RUN THE WORKFLOW BACKGROUND PROCESS  'SELECT * FROM RA_CUSTOMER_TRX_ALL WHERE TRX_NUMBER='10068382'' AND PRESS APPLY BUTTON AND SAVE IT
========================================================================================================================================================================================================================================
SELECT * FROM AR_CASH_RECEIPTS_ALL WHERE RECEIPT_NUMBER='69380'--THIS TABLE GIVES THE INFORMATION OF COMPLETE AMOUNT FOR THR TRANSACTION
SELECT * FROM AR_CASH_RECEIPT_HISTORY_ALL WHERE  CASH_RECEIPT_ID='211296'--THIS TABLE SHOWS THE  COMPLETE INFORMATION OF THE RECIEPT AND IT ALSO HOLDS THE 'EVENT_ID'
SELECT * FROM AR_RECEIVABLE_APPLICATIONS_ALL WHERE CASH_RECEIPT_ID='211296'--THIS TABLE HAS THE COLUMN 'APPLICATION_TYPE' THAT TELLS  TYPE OF PAYMENT MADE.
SELECT * FROM AR_PAYMENT_SCHEDULES_ALL WHERE CASH_RECEIPT_ID='211296'--THIS TABLE TELLS THE THAT HAS BEEN PAID AND TELLS IF WE HAVE ANY REMAINING OR FORWARD BALANCE THAT WE HAVE TO PAY.


NOW AGAIN CREATE THE ACCOUNTING FOR THE ABOVE RECIEPTS CREATED
==============================================================



SELECT * FROM XLA_EVENTS WHERE EVENT_ID='6229568'--PROCESS_STATUS_CODE='P' THAT MEANS THAT THE ABOVE SALES ORDERS ARE POSTED TO GL
SELECT * FROM XLA_AE_HEADERS WHERE EVENT_ID='6229568'-- THIHS TABLE TELLS THE EVENT_TYPE_CODE
SELECT * FROM XLA_AE_LINES WHERE AE_HEADER_ID='8115567'--THIS CONTAINS THE LINES DETAILS


NOW THE DATA HAS ALSO BEEN TRANSFERED TO GL
===========================================

SELECT * FROM GL_JE_BATCHES WHERE NAME LIKE 'Receivables A 3829423 7539176%'-- THIS TABLE HAS THE BATCHE NAME WHICH WE CAN GET FROM THE JOURNAL IMPORT PROGRAM
SELECT * FROM GL_JE_HEADERS WHERE JE_BATCH_ID=5362733---THIS TABLE HAS THE JE_BATCH_ID WHICH GIVES THE COMPLETE INFORMATION OF THE RECIEVABLES WJ=ITH JE_SOURCE
SELECT * FROM GL_JE_LINES WHERE JE_HEADER_ID=7116876--THIS TABLE HAS THE LINES INFORMATION OF THE ABOVE TRANSACTIONS FROM AR

NOW WE HAVE TO POST THE BALANCES TO GL
======================================

NOW SHIFT THE RESPONSIBILITY TO  GENERAL LEDGER, IFRS REPORTING VISION OPS
THEN OPEN THE PERIODS IF THEY ARE NOT OPEN BY GOING TO OPEN/CLOSE PERIODS AND THEN POST THE JOURNALS
====================================================================================================

SELECT * FROM GL_BALANCES   WHERE PERIOD_NAME LIKE 'Oct-17%' AND CODE_COMBINATION_ID='12875'