Retail Merchandising System (MOSC)

MOSC Banner

[ReSA] Don't export TOTALs if any errors exists

Hello,

could you please tell if it's possible not export all totals to GL if any transaction with error is exists. Audit_status='H'(HQ errors).

I've inserted all errors into sa_error_impact with system_code='GL', but solution is not working.

The sa_system_options.unit_of_work='T'(transaction) and cannot be changed.

Thank you in advance!

SA_SYSTEM_OPTION.UNIT_OF_WORK is the flag that controls whether a whole store or individual transactions are exported  i.e. "Either transaction or store – if set to store and there is an error, it will export nothing for the whole store – set to Transaction will extract everything except the transaction in error.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center