Oracle International Corporation

Qing Du

Chi Ken Yeung

Jason Aron Alonzo

Wansan Tam

Ravi Shankar

Amira A Morcos

David J Bell

Arjun Hegde

Hsiaowen Eddie Mou

Simran Sawhney

Sondhi

Eva Kifri

Kottresh Kogali

Dave Altendorf

Amarnath Molugu

A method of modeling a scenario for use with live data in a production database may include selecting the scenario. The live data can be stored in the production database on a first computing resource, and production scenarios can be stored and executed on the live data using the first computing resource. The method may also include identifying a subset of the live data that are affected by the scenario, copying the subset to a second computing resource to create modeling data, running the scenario on the modeling data using the second computing resource, causing a display device to provide an output comprising a result of the scenario on the modeling data, receiving an input indicating that the scenario is approved, and storing the scenario with the plurality of production scenarios for use on the first computing resource.

Efficiently modeling database scenarios for later use on live data

A web service for automatically determining accounting entries that are affected by the deletion of a journal, formulating reverse accounting entries, and sending the reverse entries back to the source system is described. The service can use transaction identification keys to map and track which accounting entries are affected by the deletion of the journal. The web service can use extensible markup language (XML) among other formats.

General ledger (GL) journal delete/accounting line reversal web service

A web-service for validating or invalidating accounts from a general ledger (GL) chart of accounts is described. Upon a request from an application for whether an account value corresponding to a department and a product is valid, the service indicates whether the combination of account value/department/product is valid for the chart of accounts. The system can be extensible markup language (XML)-based and can indicate validity down to the line level of a request.

General ledger chart of accounts combination editing request response

Growing community of inventors

Pleasanton, CA, United States of America

Qing Du