CLEAN_REQREQ_UP not updating the status of all confirmations.

[Former Member]

Hello All

We have scheduled the cleaner report as a job running every 2 minutes.

This job changes the status of the confirmations from 'Approved' to 'Transmit to backend system'.

However the job doesn't process a few confirmations randomly.

In such confirmations, the status remains as ' Approved'.

There is no issue for replication for such confirmations in the backend.

This happens on 30 % of all confirmations.

All these confirmations are coming from an interface and the following sequence occurs

1) MFG Batch user creates Confirmation in SRM

2) WF Batch user sets the status as Approved

3) Job Batch user( CLEAN_REQREQ_UP) updates the status to 'Transmit to Backend system'

I am trying to find out why the job wont process these confirmations.

Regards

Kedar

[former_member183819]

HI

for eg,

when we do confirmations in SRM

message type MBGMCR and RFC takes GOODS CONFIRMATION / SERVICES data to .ECC

and BBP_GET_STATUS_2 job bring the informations of ECC GR status and update in SRM.

bbp_docuemnt_tab get entries of srm confirmation data and clears clen req up table (po+confirmation number).

clean job must clean this PO+confirmation line in the bbp_docuemnt_tab table.

check your PO number in BBP_DOCUMENT_TAB TABLE.

i need to check it up.

br

muthu