Current Position:Home > Count difference b/w forecast interface table(success rec)  and base table

Count difference b/w forecast interface table(success rec)  and base table

Update:11-30Source: network consolidation
Advertisement
Hi all
We did forecast conversion.
We got wrong count while comparing count of successful loaded records of interface table(based on process_flag=5) and records inserted in base table .
I used below querys
1) to count the records successfully loaded into base table based on MRP_FORECAST_INTERFACE
select count (* ) from MRP_FORECAST_INTERFACE where TO_CHAR( last_update_date,'DD-MON-YYYY HH24:MI:SS') between
'20-MAR-2012 06:08:05' AND '20-MAR-2012 14:06:33'
and process_status=5 -- shows 859022
2) records hitted the base table at the same time
SELECT count (* ) FROM MRP_FORECAST_DATES where last_update_date >sysdate-2 --851451
I refer this document http://docs.oracle.com/cd/A85683_01/acrobat/mrptrm.pdf
In that it written like this If records process_status =5 in MRP_FORECAST_INTERFACE table then the planning manager successfully loaded into base table..
But why this count is different? Can any one help me on this...

The Best Answer

Advertisement
Hi all
We did forecast conversion.
We got wrong count while comparing count of successful loaded records of interface table(based on process_flag=5) and records inserted in base table .
I used below querys
1) to count the records successfully loaded into base table based on MRP_FORECAST_INTERFACE
select count (* ) from MRP_FORECAST_INTERFACE where TO_CHAR( last_update_date,'DD-MON-YYYY HH24:MI:SS') between
'20-MAR-2012 06:08:05' AND '20-MAR-2012 14:06:33'
and process_status=5 -- shows 859022
2) records hitted the base table at the same time
SELECT count (* ) FROM MRP_FORECAST_DATES where last_update_date >sysdate-2 --851451
I refer this document http://docs.oracle.com/cd/A85683_01/acrobat/mrptrm.pdf
In that it written like this If records process_status =5 in MRP_FORECAST_INTERFACE table then the planning manager successfully loaded into base table..
But why this count is different? Can any one help me on this...
  • Count difference b/w forecast interface table(success rec)  and base table Update:11-30

    Hi all We did forecast conversion. We got wrong count while comparing count of successful loaded records of interface table(based on process_flag=5) and records inserted in base table . I used below querys 1) to count the records successfully loaded

  • Planning Manager is not Loading data into Forecast Interface table Update:11-30

    Hi I have created a forecast set with name 'ABCD-IA' and I am inserting a row into the mrp_ofrefcast_interface table.The rows are not processed by the Planing Manager and it is pendign with the status of 2.The planning manager is up and running. Here

  • Is any difference in oracle 11i and oracle 12 interfaces tables Update:11-30

    Dear All, Can someone tells me .. Is any difference in oracle 11i and oracle R12 interface tables?? My company want to upgrade Oracle 11i to EBS R12 PS Edited by: PS on Jul 13, 2012 3:07 PMPlease also see: Identifying Data Model Changes Between EBS 1

  • How to purge Item/Categories open interface tables Update:10-11

    Hi, We are importing items into oracle inventory using oracle open interface tables. There is some existing data in the standard interface tables mtl_system_items_interface and mtl_revision_interface that we need to remove. What is the best way to do

  • AP Invoice BPEL Process is not populating into Line Interface tables Update:10-11

    Hi We are in the process of Creating BPEL Process for AP Invoice. Before we map Supplier incoming XSD, we have created our own XML and XSD and mapped with Standard APInvoice XML Gateway XSD. Transformation is able to populate header information into

  • Custom PL/SQL API that inserts the data into a custom interface table. Update:10-11

    We are developing a custom Web ADI integrator for importing suppliers into Oracle. The Web ADI interface is a custom PL/SQL API that inserts the data into a custom interface table. We have defined the content, uploader and an importer. The importer i

  • Problem in runing the sql in apps of interface tables Update:10-11

    hai friends, hai friends, i am new in apps ,Plz let me know the problem in detail. This is to import the Newcustomer details in to interface tables in AR. actualy i have created a staging table in AR and then created a PRIVELIGES to APPS. The owner o

  • Problem while reversing Oracle EBiz interface tables Update:11-30

    Hi, I need to reverse the interface tables of EGO, GL, AP, AR modules. I have created the Data Server with "APPS" as username and pwd. I have selected the Schema and Work Schema as "APPS". When i am reversing the model using Customized

  • Account error: value does not exist in BB Company is displayed when Uploading a Journal to Oracle ADI Interface Table Update:11-30

    Environment: Oracle ADI version: version Oracle ADI 7.2.12.04.25 and patch number 9493800 Microsoft Office version: 2003 How to recreate incident: 1. Create a budget worksheet for a company 2. View the budget information 3. Upload budget information

  • What is the basic use of Interface Tables Update:11-30

    Hi there, We are trying to connect and send data to the EBS Oracle System. We are facing different scenarios and I don't know which one to use in which scenario? So if I add a vendor for instance, should I use the Interface tables or call a stored pr