US-20260127683-A1 - GAP CHECKS

US20260127683A1US 20260127683 A1US20260127683 A1US 20260127683A1US-20260127683-A1

Abstract

Systems, methods, and articles of manufacture, including computer program products, are provided including receiving one or more records; storing the received one or more records in a store further including a plurality of records; retrieving at least a first record; checking the first record for a unique identifier, wherein the unique identifier comprises a previous identifier associated with a previous record and a current identifier associated with the first record; in response to detecting the previous identifier, searching for at least one other record that contains the previous identifier as a current identifier; in response to the searching indicating a gap, sending a message to a server to provide at least one missing record associated with the gap; in response to the searching indicating the gap is not present, flagging the first record as audited; and passing the first record to a first system.

Inventors

Oliver Grob

Assignees

SAP SE

Dates

Publication Date: 20260507
Application Date: 20241104

Claims (20)

1 . A computer-implemented method comprising: receiving one or more records; storing the received one or more records in a store further including a plurality of records; retrieving at least a first record; checking the first record for a unique identifier, wherein the unique identifier comprises a previous identifier associated with a previous record and a current identifier associated with the first record; in response to detecting the previous identifier, searching for at least one other record that contains the previous identifier as a current identifier; in response to the searching indicating a gap, sending a message to a server to provide at least one missing record associated with the gap; in response to the searching indicating the gap is not present, flagging the first record as audited; and passing the first record to a first system.
2 . The computer-implemented method of claim 1 , wherein the one or more records, the plurality of records, the first record, and the other record comprise point-of-service transaction records.
3 . The computer-implemented method of claim 1 , wherein the first system comprises an enterprise resource planning system.
4 . The computer-implemented method of claim 1 , wherein the one or more records are received by an audit system coupled to the first system, and wherein the one or more records are received from a point-of-service device.
5 . The computer-implemented method of claim 4 , wherein the store is located at the audit system, and wherein the store contains the plurality of records that have not been audited by the audit system.
6 . The computer-implemented method of claim 4 , wherein the audit system retrieves the first record from the store.
7 . The computer-implemented method of claim 1 further comprising: performing a duplicate check for at least the first record by at least searching for another record that contains the current identifier associated with the first record.
8 . The computer-implemented method of claim 7 further comprising: in response to the searching for the other record that contains the current identifier associated with the first record not detecting any duplication records, flagging first record as audited.
9 . The computer-implemented method of claim 1 , wherein the previous identifier and the current identifier each comprise a 128-bit value configured to provide a universally unique identifier.
10 . The computer-implemented method of claim 1 , wherein the previous identifier and the current identifier each comprise a date, a time, a media-access control (MAC) address, and/or a random value.
11 . A system comprising: at least one processor; and at least one memory including code which when executed by the at least one processor causes operations comprising: receiving one or more records; storing the received one or more records in a store further including a plurality of records; retrieving at least a first record; checking the first record for a unique identifier, wherein the unique identifier comprises a previous identifier associated with a previous record and a current identifier associated with the first record; in response to detecting the previous identifier, searching for at least one other record that contains the previous identifier as a current identifier; in response to the searching indicating a gap, sending a message to a server to provide at least one missing record associated with the gap; in response to the searching indicating the gap is not present, flagging the first record as audited; and passing the first record to a first system.
12 . The system of claim 11 , wherein the one or more records, the plurality of records, the first record, and the other record comprise point-of-service transaction records.
13 . The system of claim 11 , wherein the first system comprises an enterprise resource planning system.
14 . The system of claim 11 , wherein the one or more records are received by an audit system coupled to the first system, and wherein the one or more records are received from a point-of-service device.
15 . The system of claim 14 , wherein the store is located at the audit system, and wherein the store contains the plurality of records that have not been audited by the audit system.
16 . The system of claim 14 , wherein the audit system retrieves the first record from the store.
17 . The system of claim 11 further comprising: performing a duplicate check for at least the first record by at least searching for another record that contains the current identifier associated with the first record.
18 . The system of claim 17 further comprising: in response to the searching for the other record that contains the current identifier associated with the first record not detecting any duplication records, flagging first record as audited.
19 . The system of claim 11 , wherein the previous identifier and the current identifier each comprise a 128-bit value configured to provide a universally unique identifier.
20 . A non-transitory computer-readable storage medium code which when executed by at least one processor causes operations comprising: receiving one or more records; storing the received one or more records in a store further including a plurality of records; retrieving at least a first record; checking the first record for a unique identifier, wherein the unique identifier comprises a previous identifier associated with a previous record and a current identifier associated with the first record; in response to detecting the previous identifier, searching for at least one other record that contains the previous identifier as a current identifier; in response to the searching indicating a gap, sending a message to a server to provide at least one missing record associated with the gap; in response to the searching indicating the gap is not present, flagging the first record as audited; and passing the first record to a first system.

Description

BACKGROUND The phrase “Enterprise Resource Planning” or “ERP” refers to a system that integrates processes for an enterprise, such as a business or other type of organization. The ERP system enables the enterprise to manage enterprise functions, such as human resources, purchasing, supply chain management, travel, inventory management, financial control and/or reporting, customer relationship management, and the like. The ERP system may include a database, analytics, reporting, security, and/or other functions. For example, the database may be configured to store an organized collection of data for the enterprise. To illustrate further, data may be stored in a relational according to a schema defining one or more relations, each of which being a set of tuples sharing one or more common attributes. The tuples of a relation may occupy the rows of a database table while the columns of the database table may store the values of the common attributes shared by the tuples. Moreover, one or more attributes may serve as keys that establish and identify relationships between the relations occupying different database tables. The database may support a variety of database operations for accessing the data stored in the database. For instance, the database may support transactional processing (e.g., on-line transactional processing (OLTP)) that modifies the data stored in the database. Alternatively, and/or additionally, the database may support analytical processing (e.g., on-line analytical processing (OLAP)) that evaluates the data stored in the database. SUMMARY Systems, methods, and articles of manufacture, including computer program products, are provided including receiving one or more records; storing the received one or more records in a store further including a plurality of records; retrieving at least a first record; checking the first record for a unique identifier, wherein the unique identifier comprises a previous identifier associated with a previous record and a current identifier associated with the first record; in response to detecting the previous identifier, searching for at least one other record that contains the previous identifier as a current identifier; in response to the searching indicating a gap, sending a message to a server to provide at least one missing record associated with the gap; in response to the searching indicating the gap is not present, flagging the first record as audited; and passing the first record to a first system. In some variations, one or more features disclosed herein including one or more of the following features may be implemented as well. The one or more records, the plurality of records, the first record, and the other record comprise point-of-service transaction records. The first system comprises an enterprise resource planning system. The one or more records are received by an audit system coupled to the first system, and wherein the one or more records are received from a point-of-service device. The store is located at the audit system, and wherein the store contains the plurality of records that have not been audited by the audit system. The audit system retrieves the first record from the store. A duplicate check is performed for at least the first record by at least searching for another record that contains the current identifier associated with the first record. Moreover, in response to the searching for the other record that contains the current identifier associated with the first record not detecting any duplication records, flagging first record as audited. The previous identifier and the current identifier may each comprise a 128-bit value configured to provide a universally unique identifier. The previous identifier and the current identifier may each comprise a date, a time, a media-access control (MAC) address, and/or a random value. Implementations of the current subject matter can include methods consistent with the descriptions provided herein as well as articles that comprise a tangibly embodied machine-readable medium operable to cause one or more machines (e.g., computers, etc.) to result in operations implementing one or more of the described features. Similarly, computer systems are also described that may include one or more processors and one or more memories coupled to the one or more processors. A memory, which can include a non-transitory computer-readable storage medium or machine-readable storage medium, may include, encode, store, or the like one or more programs that cause one or more processors to perform one or more of the operations described herein. Computer implemented methods consistent with one or more implementations of the current subject matter can be implemented by one or more data processors residing in a single computing system or multiple computing systems. Such multiple computing systems can be connected and can exchange data and/or commands or other instructions or the like via one or more connections, inclu