Tuesday 30 January 2018

Oracle Apps R12 Receiving Module Complete Details of the Tables and its Details

Oracle Apps R12 Receiving Module Complete Details of the Tables and its Details

Oracle Apps R12 Receiving Module Complete Details of the Tables and its Details


RCV_VRC_TXS_V


RCH_SHIPMENT_HEADERS  (important coloumns SHIPMENT_HEADER_ID,VENDOR_ID,RECEIPT_NUM,EMPLOYEE_ID,org_id)
 
shipment_header_id relates this table to RCV_TRANSACTIONS table )

RCV_SHIPMENT_LINES  

(this table describes the whole receiving like   line1  we receive that line2 we receive that by this table using po_header_id,po_line_id we join with AP_INVOICE_DISTRIBUTIONS_ALL table)
 (important cloumns are SHIPMENT_LINE_ID,SHIPMENT_HEADER_ID,LINE_NUM,QUANTITY_SHIPPED,QUANTITY_RECEIVED,ITEM_DESCRIPTION,ITEM_ID,SHIPMENT_LINE_STATUS_CODE(full or half rec),PO_HEADER_ID,PO_LINE_ID,TO_ORGANIZATION_ID)


RCV_TRANSACTIONS

---(this table joins with rcv_shipment_headers,rcv_shipment_lines THIS SHOWS ALL THE STATUS OF ONE RECEVING OR RECEIPT NO  LIKE NOW THEY R RECEIVE ,NOW THER ARE DELIVER,CORECT,INVENTORY_ITEM_ID  links with MTL_SYSTEM_ITEMS_B invetory_item_id)
('RECEIVE','CORRECT','RETURN TO VENDOR','RETURN TO RECEIVING') THESE ARE THE TYPES COMMON

(transaction_id,SHIPMENT_HEADER_ID,UNIT_OF_MEASURE,QUANTITY,TRANSACTION_DATE,PO_HEADER_ID,PO_LINE_ID,PO_LINE_LOCATION_ID,PO_DISTRIBUTION_ID,DESTINATION_TYPE_CODE(EXP,RCV,INV)


RCV_RECEIVING_SUB_LEDGER

  (THIS TABLE SHOWS THE ACCOUNTING OF EACH TRANSACTION ID LIKE WHEN ITEM RECEIVED THEN WHICH ACCOUNT CR AND DR)
 (IMPORTANT COLOUMNS -  RCV_TRANSACTION_ID(IT LINKS RCV_TRANSACTIONS TABLE TO THIS TABLE),SET_OF_BOOKS_ID,CODE_COMBINATION_ID,ACCOUNTING_DATE,ACCOUNTED_DR,CR,PERIOD_NAME,RCV_SUB_LEDGER_ID)

BUT THE LIMITATION OF ABOVE TABLE IS THAT IT SHOWS THE ACCOUNTING OF THOSE TRANSACTION WHICH ARE EXPENSE IF THEY ARE INVENTORY THEN IT SHOWS THE ACCOUNTING OF ONLY RECEVING TRANSACTION NOT SHOWING THE TRANSACTION OF DELIVER TYPE TRANSACTION )

FOR SHOWING THE ACCOUNTING OF DELVER TRANSACTION IN INVENTORY WE HAVE TO USE THIS BELOW TABLE

MTL_TRANSACTION_ACCOUNTS(REFRENCE ACCOUNT,BASE_TRANSACTION_VALUE)


THIS TABLE STORE THE INFORMATION OF ACCOUNTING OF INVENTORI ITEM DELIVER.
LIKE TWO LINES FOR 1 TRANSCTION DELIVER

MTL_TRANSACTION_ACCOUNTS  WE REACH TO THIS TABLE BY MTL_MATERIAL_TRANSACTIONS(TRANSACTION_ID)  AND WE REACH TO THIS TABLE BY RCV_TRANSACTIONS(RCV_TRANSACTION_ID)

MTL_TRANSACTION_ACCOUNTS HAS COLOUMN REFRENCE ACCOUNT WHICH ARE ACCOUNTING CODE,BASE_TRANSACTION_VALUE  AMOUNT


EXAMPLE (WHEN WE RECEIVE THE MATERIAL RECEIVING ACCOUNT DEBIT AND ACCRUAL ACCOUNT CREDIT 

WHEN WE DELIVER THE MATERIAL  RECEIVING ACCOUNT CREDIT AND DESTINATION ACCOUNT TO WHICH ITEM BELONG DEBIT 

AND WEN WE PASS THE BILL OF THIS MATERIAL IT DEBITS THE ACRUAL ACCOUNT)

if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.

JAI_RCV_JOURNAL_ENTRIES(TRANSACTION_ID)


  THIS IS USED FOR SHOWING THE TAX ACCOUNTING OF PARTICULAR ONE MRN NO




12 comments:

arif said...

Thanks and Regards. Oracle Apps R12 & Fusion Training Videos at affordable cost.
please check oracleappstechnical.com for details.

Anonymous said...

Nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
Oracle Fusion HCM Online Training

Anonymous said...

Nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
Oracle Fusion HCM Online Training

Anonymous said...

Good Blog Thanks For Sharing this informative airtrl/
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad

Rifath said...

Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
¬Oracle Fusion HCM Online Training

Anonymous said...

Brilliant blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly and sensible. The substance of information is helpful.
Oracle Fusion Financials Online Training

Anonymous said...

Brilliant blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly and sensible. The substance of information is helpful.
Oracle Fusion Financials Online Training

Anonymous said...

Brilliant blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly and sensible. The substance of information is helpful.
Oracle Fusion Financials Online Training

shaik shah said...

Thanks for sharing this informative article ,It would be helpful to all
Oracle Fusion HCM Online Training

Rainbow Training Institute said...

Very interesting blog I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

Big Data and Hadoop Online Training
Big Data Hadoop Training
Hyderabad

Rainbow Training Institute said...

Thank you for sharing such a nice and interesting blog.

Spark and Scala Online Training
Spark Scala Training
Hyderabad

Lakshmi Satya said...
This comment has been removed by the author.

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *