Basic SQLs – EBS DB Custom Object Backup

 

Business Need:

Backup DB object source codes (Tables, Functions, Packages, Triggers, etc.) from a development instance to local machine. Can be used before cloning to avoid loss of development work.

Note: This will back up only database objects. Any Unix (or other OS) files are not backed up by this, including:

• Ø Java Packages, sources
• Ø Shell Scripts
• Ø JSP Files, other middle tier files

They have to be backed up manually.

 

Tables:

All custom tables

 

SQLs:

Get Cloned date of current development instance:

 

-- get cloned date
SELECT resetlogs_time FROM v$database;
 
06/26/2016 9:44:39 PM

 

Get a list of all custom objects, created or changed after cloning date (substitute date from above SQL). Replace custom schema names:

-- all recent custom objects - change date
 
select *
from dba_objects
where LAST_DDL_TIME > TO_DATE('06/26/2016 9:44:39 PM', 'MM/DD/YYYY HH:MI:SS AM')
-- created > TO_DATE('06/26/2016 9:44:39 PM', 'MM/DD/YYYY HH:MI:SS AM')
and ((object_name like 'O%') OR (object_name like 'XXAAA%') OR (object_name like 'XXBBB%') OR (object_name like 'XXCCC%'))
and owner in ('APPS', 'XXAAA', 'XXBBB', 'XXCCC')
order by owner, object_type, object_name;
 
 
-- get source codes of all APPS-Owned objects
-- to remove Line Feed, replace \r\n"\r\n with "\r\n
select src.owner, src.name, src.type, src.line, src.text
from dba_source src
where owner in ('APPS', 'XXAAA', 'XXBBB', 'XXCCC')
and ((src.name like 'OXX%') OR (src.name like 'UHXX%') OR (src.name like 'KESX%') OR (src.name like 'SSXX%'))
and exists (select *
    from dba_objects obj
    where LAST_DDL_TIME > TO_DATE('7/29/2020 5:54:47 PM', 'MM/DD/YYYY HH:MI:SS AM')
    and ((object_name like 'O%') OR (object_name like 'XXAAA%') OR (object_name like 'XXCCC%') OR (object_name like 'XXBBB%'))
    and owner in ('APPS', 'XXAAA', 'XXBBB', 'XXCCC')
    and src.name = obj.object_name
    and src.owner = obj.owner)
order by src.owner, src.type, src.name, src.line asc;
 
 

 

Keywords:

Oracle EBS, R12, R12.2.8, Oracle Applications, Query, SQL, SQLPLUS

Oracle Internet Expenses (iExpenses): Tables and SQLs

 Introduction:

Some example SQLs (queries) related to EBS Module iExpenses (OIE – Oracle Internet Expenses. This is a part of AP (Account Payables) functionality within the Oracle Applications.

Notes: 

1. I am using EBS 12.2.3 version. But these SQLs will work with any EBS versions (At least from R12)

2. Oracle iExpenses can be used from an IOS or Android APP (Oracle Fusion Expenses) provided by Oracle. The data collected from the APP is also stored within the same tables.

 

SQLs:

Major Tables:

AP_EXPENSE_REPORT_HEADERS_ALL - iExpense header
AP_EXPENSE_REPORT_LINES_ALL - iExpense lines
 

Useful Base Query:

-- base query - major expense header and line items
-- reference_1 -  EBS_MOBILE is from APP (Oracle Fusion Expenses)
SELECT EXH.REPORT_HEADER_ID, EXH.CREATION_DATE, EXH.TOTAL HEADER_TOTAL, EXH.REFERENCE_1, EXH.SOURCE, EXH.EXPENSE_STATUS_CODE,
    EXL.ITEM_DESCRIPTION, EXL.AMOUNT AS LINE_AMOUNT, EXL.ATTRIBUTE_CATEGORY, EXL.ORG_ID, EXL.LOCATION --,  exh.*,  exl.*
FROM AP_EXPENSE_REPORT_HEADERS_ALL EXH, AP_EXPENSE_REPORT_LINES_ALL EXL
WHERE EXH.CREATION_DATE > SYSDATE-3.1
AND  EXH.REFERENCE_1 = 'EBS_MOBILE'
AND EXH.REPORT_HEADER_ID = EXL.REPORT_HEADER_ID;
 
 

 

Major Transaction Tables:

 

AP_EXPENSE_REPORT_HEADERS_ALL Expense report header information
AP_EXPENSE_REPORT_LINES_ALL   Expense report lines information
AP_EXP_REPORT_DISTS_ALL Expense report distribution information. It contains the accounts against each expense report line.
AP_CREDIT_CARD_TRXNS_ALL      Table to store the corporate credit card transactions that are sent by the banks. These lines are saved as expense lines when the user creates the expense lines for credit cards
AP_NOTES    Table to store the comments entered by approvers and auditors
 

 

iExpense Setup Tables:

AP_EXPENSE_REPORTS_ALL  This table contains the header level information about the expense templates
AP_EXPENSE_REPORT_PARAMS_ALL  This table contains the detail level information about the expense templates
AP_POL_CAT_OPTIONS_ALL  Table to store the policy options
AP_POL_CONTEXT    Table to store the policy context
 

 

iExpense Data tables  

AP_POL_LOCATIONS_TL     Table to store the locations for which policies have been defined.
AP_POL_VIOLATIONS_ALL   Table to store the lines for which the defined policies have been violated
AP_POL_ITEMIZATIONS    
AP_POL_SCHEDULE_PERIODS
AP_POL_EXRATE_OPTIONS_ALL     Table to store the exchange rate tolerance
AP_POL_HEADERS    Table to store all the policy headers
AP_POL_LINES      Table to store all the policy details
AP_CARDS_ALL      Table to store the corporate credit card details for the employees
AP_EXPENSE_REPORTS_ALL  Table to store the expense report templates that can be used by employees from different operating units
AP_WEB_DISC_HEADERS_GT 
AP_POL_SCHEDULE_OPTIONS Table to store the basis of the policy created, E.g. location, currency, etc.
AP_EXPENSE_REPORT_PARAMS_ALL  Table to store the expense template detailed information
 
 

iExpense Audit tables  

AP_AUD_AUDITORS   Table to store auditor id and security_profile_id
AP_AUD_AUDIT_REASONS    Table containing the expense report header id and audit reason id and code
AP_AUD_AUTO_AUDITS      Table to store the employees who are auditors. This table is updated through the seeded package,AP_WEB_AUDIT_PROCESS.add_to_audit_list
AP_AUD_QUEUES    
AP_AUD_RULE_ASSIGNMENTS_ALL   Table containing audit rule assignments
AP_AUD_RULE_SETS  Table containing audit rules
 

 

Keywords:

AP_EXPENSE_REPORT_HEADERS_ALL, AP_EXPENSE_REPORT_LINES_ALL, iExpenses, OIE, Oracle Internet Expenses, EBS, R12, Query, SQL, SQLPLUS

 

Oracle Application Framework (OAF): Random Scripts and SQLs

 

Introduction:

Some example SQLs (queries) to check and review Oracle Application Framework components within an Oracle database. These scripts/queries are useful to:

1. Ø Review custom and standard OA Objects
2. Ø Remove or disable personalizations
3. Ø Check for existing object for extension or modifications
4. Ø Compare current functionality of a UI with standard functionality

Note: Personalizations can be enabled/disabled at SITE, Responsibility and User levels within EBS.

SQLs:

All Personalizations: All OAF Personalizations within EBS – Both Custom and Standard personalizations are listed by this SQL:

-- all oaf object personalization - custom and standard
SELECT PATH.PATH_DOCID PERZ_DOC_ID,
jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
FROM JDR_PATHS PATH
WHERE PATH.PATH_DOCID IN
(SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS
WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
AND COMP_ID IS NULL)
ORDER BY PERZ_DOC_PATH;
 

Personalizations within a Module: All personalizations within an EBS Module. In this example, OIE (Oracle Internet Expenses à iExpenses) is used. Substitute with any EBS Standard module codes to get its customizations.

 

SELECT PATH.PATH_DOCID PERZ_DOC_ID,
jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
FROM JDR_PATHS PATH
WHERE PATH.PATH_DOCID IN
(SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS
WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
and jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) like '%oie%'            -- all from OIE - iExpenses
AND COMP_ID IS NULL)
ORDER BY PERZ_DOC_PATH;
 

 

All Objects within a Module: List of all OAF objects within a module. The module AP (Account Payables) is used here. Change module code accordingly (Eg: OE for Order Entry, ONT for Order management, PO for Purchasing, etc)

-- list all page, regions, customizations, personalizations
set serveroutput on;
set linesize 300;
 
DECLARE
BEGIN
jdr_utils.listdocuments('/oracle/apps/ap/', TRUE);
END;
/
 

  

JDR_UTILS Functions: JDR_UTILS is a standard package that provide lot of utilities to manage OA Framework pages and files. Here are some major functions available for OAF Troubleshooting usage:

JDR_UTILS Functions:
listCustomizations
printDocument
deleteDocument
listDocuments

 

Example jdr_utils.listCustomizations:

 

jdr_utils.listCustomizations()
This procedure can be used to check whether any personalization exists for a particular page or  substitution exists for a particular EO/VO/AM.
 begin 
  jdr_utils.listCustomizations('/xxabc/oracle/apps/fnd/xxabc/webui/XxabcPG'); 
 end; 
 begin 
  jdr_utils.listCustomizations('/xxabc/oracle/apps/fnd/xxabc/server/XxabcVO'); 
 end; 
 

 

Example jdr_utils. printDocument:

 

jdr_utils.printDocument()
This procedure can be used to get the Page / Personalization / Substitution file. You can pass the output of the above procedure as a parameter to this procedure to get the details.
 begin 
  jdr_utils.printDocument('/xxabc/oracle/apps/fnd/xxabc/webui/XxabcPG'); 
 end; 
 begin 
  jdr_utils.printDocument('/xxabc/oracle/apps/fnd/xxabc/webui/customizations/site/0/XxabcPG'); 
 end; 
 begin 
  jdr_utils.printDocument('/xxabc/oracle/apps/fnd/xxabc/server/customizations/site/0/XxabcVO'); 
 end;
 

 

Example jdr_utils. deleteDocument:

 
 begin  
   jdr_utils.deleteDocument('/xxabc/oracle/apps/fnd/xxabc/webui/XxabcPG'); 
 end; 
 begin 
   jdr_utils.deleteDocument('/xxabc/oracle/apps/fnd/xxabc/webui/customizations/site/0/XxabcPG'); 
 end; 
 begin 
   jdr_utils.deleteDocument('/xxabc/oracle/apps/fnd/xxabc/server/customizations/site/0/XxabcVO'); 
 end; 
 

 

Example jdr_utils. listdocuments:

This procedure will print all the files under the specified path.
 begin 
   jdr_utils.listDocuments('/xxabc/oracle/apps/fnd/xxabc/webui'); 
 end; 
 
You can add an additional parameter to recursively print all the documents under the specified path
 begin 
   jdr_utils.listDocuments('/xxabc/oracle/apps/fnd/xxabc',true); 
 end; 
 
 

 

Keywords:

OAF, OA Framework, Oracle Application Framework, Oracle, UIX, Customization, Personalization, Application Module, PG.XML, Query, SQL, SQLPLUS

 

Useful SQL/Query - EBS Descriptive Flex Fields (DFF)

Here are a few SQLs to help working with Oracle EBS (E-Business Suite) Descriptive Flex Fields. You may have to make appropriate changes for your environment.

 

 

All custom DFFs - contexts, fields, values by module/application

 

SELECT APL.APPLICATION_ID, APL.APPLICATION_NAME,

 FDF.TITLE                             "DFF TITLE",

 FDF.CONTEXT_COLUMN_NAME               "CONTEXT COLUMN NAME",

 FDF.APPLICATION_TABLE_NAME            "APPLICATION TABLE",

 FUSG.DESCRIPTIVE_FLEX_CONTEXT_CODE   "DFF CONTEXT CODE",

 FUSG.COLUMN_SEQ_NUM                  "SEQUENCE",

 FUSG.END_USER_COLUMN_NAME            "SEGMENT NAME",

 FUSG.APPLICATION_COLUMN_NAME         "COLUMN NAME",

 FFV.FLEX_VALUE_SET_NAME               "VALUE SET NAME",

 FUSG.ENABLED_FLAG   -- , APL.*

FROM FND_DESCR_FLEX_COL_USAGE_VL FUSG, FND_DESCRIPTIVE_FLEXS_VL FDF, FND_FLEX_VALUE_SETS FFV, FND_APPLICATION_VL APL

WHERE FUSG.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID(+)

 -- AND FDF.TITLE = 'Employee Confirmation Date'  -- Replace this with Flex Field Title

 -- AND FUSG.DESCRIPTIVE_FLEX_CONTEXT_CODE = 'US'

 -- AND FUSG.ENABLED_FLAG = 'Y'

 AND FUSG.CREATED_BY >= 1000

 AND FDF.APPLICATION_ID = APL.APPLICATION_ID

 AND FUSG.DESCRIPTIVE_FLEXFIELD_NAME = FDF.DESCRIPTIVE_FLEXFIELD_NAME

 AND FUSG.APPLICATION_ID = FDF.APPLICATION_ID

ORDER BY APL.APPLICATION_NAME, FDF.TITLE, FUSG.DESCRIPTIVE_FLEXFIELD_NAME, FUSG.DESCRIPTIVE_FLEX_CONTEXT_CODE, FUSG.COLUMN_SEQ_NUM;

 

All DFF definitions in the system, includes lot of standard fields

This may be useful, if you are more comfortable to filter in Excel

 

SELECT FDF.APPLICATION_TABLE_NAME            "APPLICATION TABLE",

 FDF.TITLE                             "DFF TITLE",

 FDF.CONTEXT_COLUMN_NAME               "CONTEXT COLUMN NAME",

 FUSG.DESCRIPTIVE_FLEX_CONTEXT_CODE   "DFF CONTEXT CODE",

 FUSG.COLUMN_SEQ_NUM                  "SEQUENCE",

 FUSG.END_USER_COLUMN_NAME            "SEGMENT NAME",

 FUSG.APPLICATION_COLUMN_NAME         "COLUMN NAME",

 FFV.FLEX_VALUE_SET_NAME               "VALUE SET NAME",

 FUSG.ENABLED_FLAG

FROM FND_DESCR_FLEX_COL_USAGE_VL   FUSG, FND_DESCRIPTIVE_FLEXS_VL      FDF, FND_FLEX_VALUE_SETS           FFV

WHERE FUSG.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID(+)

-- AND FDF.TITLE = 'Employee Confirmation Date'  -- Replace this with Flex Field Title

-- AND FUSG.DESCRIPTIVE_FLEX_CONTEXT_CODE = 'US'

-- AND FUSG.ENABLED_FLAG = 'Y'

AND FUSG.DESCRIPTIVE_FLEXFIELD_NAME = FDF.DESCRIPTIVE_FLEXFIELD_NAME

AND FUSG.APPLICATION_ID = FDF.APPLICATION_ID

ORDER BY FDF.APPLICATION_TABLE_NAME, FDF.TITLE, FUSG.DESCRIPTIVE_FLEXFIELD_NAME, FUSG.DESCRIPTIVE_FLEX_CONTEXT_CODE, FUSG.COLUMN_SEQ_NUM;

 

 

 

 

Query to find DFF information

 

SELECT FDF.TITLE                             "DFF TITLE",

 FDF.APPLICATION_TABLE_NAME            "APPLICATION TABLE",

 FDF.CONTEXT_COLUMN_NAME               "CONTEXT COLUMN NAME",

 FUSG.DESCRIPTIVE_FLEX_CONTEXT_CODE   "DFF CONTEXT CODE",

 FUSG.COLUMN_SEQ_NUM                  "SEQUENCE",

 FUSG.END_USER_COLUMN_NAME            "SEGMENT NAME",

 FUSG.APPLICATION_COLUMN_NAME         "COLUMN NAME",

 FFV.FLEX_VALUE_SET_NAME               "VALUE SET NAME"

FROM FND_DESCR_FLEX_COL_USAGE_VL   FUSG,

 FND_DESCRIPTIVE_FLEXS_VL      FDF,

 FND_FLEX_VALUE_SETS           FFV

WHERE FDF.TITLE = 'Employee Confirmation Date'         -- Replace this with Flex Field Title

AND FUSG.DESCRIPTIVE_FLEX_CONTEXT_CODE = 'US' 

AND FUSG.ENABLED_FLAG = 'Y'

AND FUSG.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID

AND FUSG.DESCRIPTIVE_FLEXFIELD_NAME = FDF.DESCRIPTIVE_FLEXFIELD_NAME

AND FUSG.APPLICATION_ID = FDF.APPLICATION_ID

ORDER BY

 FUSG.DESCRIPTIVE_FLEXFIELD_NAME,

 FUSG.DESCRIPTIVE_FLEX_CONTEXT_CODE,

 FUSG.COLUMN_SEQ_NUM;

java.sql.SQLException: ORA-04068: existing state of packages has been discarded

 

Symptom/Problem/Error:

Three possible reasons for this error:

Cause 1: Object used within a session

If the error comes from the same Database session that created or altered the object, most likely this is due to incomplete transaction. To solve this issue COMMIT or ROLLBACK.

Cause 2: Another Session used Object

If the error comes from Oracle Client (SQL Plus, TOAD, SQL Developer, etc), another session either has incomplete transaction or current session has incomplete transaction.

Resolution Steps:

Commit session that has incomplete transaction

Make sure you disconnect each session that has used the package or have the session do a DBMS_SESSION.RESET_PACKAGE to reset the package state.

BEGIN

DBMS_SESSION.RESET_PACKAGE;

END;

/

Cause 3: The Object is used indirectly within Java Servlet

When a package is called from a Java Servlet, the same error may happen even if the proper steps are done

Resolution Steps:

Close current browsers & clients

Do steps mentioned in “Cause 2”

Abort and Restart OA Core Servers

{ echo <pwd> ; }| admanagedsrvctl.sh abort oacore_server1 @-nopromptmsg

{ echo <pwd> ; }| admanagedsrvctl.sh start oacore_server1 @-nopromptmsg

 

Keywords:

SQLException, ORA-04068, existing state of packages has been discarded, ASADMIN, Transaction, COMMIT, ROLLBACK

QA Check in Oracle Service Contracts (OKS) R12

QA Check in Oracle Service Contracts (OKS) R12

Quality Assurance Check (QA Check) is a standard functionality of Oracle Service Contracts (OKS). Whenever a new contract is getting activated or some updates happen to a contract, the system checks for certain validations to make sure that the contract meets is the required criteria. Typically the criteria can be business restrictions (PO Number Required, Term should be either monthly or quarterly) or integrity requirements (No overlapping billing schedules, no serial in multiple orders). Users can also add new custom PL/SQL Functions and add them to the QA Checklist.

QA Checklist is defined by the profile option value "OKS: Default QA Checklist". It can be setup at Site, Application and Responsibility levels. The default value for this profile is "Default Service Contracts Quality Assurance Check List".

Profile Option Name: OKS: Default QA Checklist (This is accessed by System Administrator responsibility)

Maintain (add and remove conditions) are done by:

Responsibility: Service Contracts Setup
Navigation Path: Functions > Quality Assurance

Here is an example of a QA Checklist Screenshot:
The Severity level can be STOP and WARNING. When STOP condition occurs, the QA will fail and the contract cannot be activated without fixing the root cause. WARNING allows contracts to be proceeded, even though user has to review the cause.

Even though contract is active, pressing UPDATE button will change the status to QA_HOLD. This can be reactivated only by successfully completing QA Check.

To add a new condition during the activation, add an additional line and link to the required function.

Customer Credit Snapshot - Receivables Manager Report

Customer Credit Snapshot - Receivables Manager Report

Few people know this. Oracle EBusiness Suite Release 12 (R12) has a built-in concurrent report is available to get all the credit amounts for a customer. This report fetches data from Order Entry, Service Contracts, Other service requests, etc. The output is divided into multiple ageing buckets for ease of analysis.


Responsibility: US Receivables Manager
Navigation Path: Control > Requests > Run
Report Name: Customer Credit Snapshot

Here is the screenshot with concurrent request submission and parameters:
 
 ... And here is a sample input. This report can either be run for a single customer (By the parameter Customer Account Number) or by Ageing Buckets or Books.

Report data is only for operating units per Responsibility and Preferences.


Casino Gaming US                                                                        Report Date: 29-MAR-2014 10:32
                                                    Customer Credit Snapshot


Collector Name              :                                  To

Customer Name               :                                  To

Customer Number             : 15770                            To   15770

Bucket Type                 : Credit SnapShot                  To   Credit SnapShot


Casino Gaming US                                        Customer Credit Snapshot                         Report Date: 29-MAR-2014 10:32
                                                                                                            Page:     1  of       3


Customer Name:  Ideal Gambling Services                                       Customer Age  2.4 Years
Customer Number:  15770                                                     Address Age:  2.4 Years
Billing Address:  3601 Las Vegas Blvd. South                                    Contact:
                 LAS VEGAS, , NV  89109                                          Phone:
                 United States
      Location:  Sales-LAS VEGAS



Currency:  USD

------------------ Current Aging ------------------          -------------------- Customer History -------------------
Bucket                              Amount  Percent          Indicator                              Amount   Date
-------------------- ---------------------  -------          ---------------------------- ----------------   ---------
Current                               0.00     0.0%          Largest Invoice                    519,104.00   29-DEC-12
1-30 Days Past Due               90,841.53    80.9%          Highest Credit Limit                 No Limit
31-60 Days Past Due              17,684.54    15.7%
61-90 Days Past Due                   0.00     0.0%          ----------------- Rolling 12-Month Summary --------------
91-180 Days Past Due                  0.00     0.0%          Indicator                              Amount       Count
181-360 Days Past Du              3,634.78     3.2%          ---------------------------- ----------------   ---------
361+ Days Past Due                    0.00     0.0%          Sales Gross                        915,299.73         471
                         ----------------                   Payments                          -767,867.86          72
Outstanding Balance:            112,160.85  100.00%          Credits                           -120,825.09           9
                                                            Finance Charges                          0.00           0
On Account Credit:             -1,253.22                   Amount Written Off                       7.03
    Unapplied Cash:                  0.00                   Earned Discounts Taken                   0.00
   On Account Cash:             -1,364.49                   Unearned Discounts Taken                 0.00
                         ----------------                   NSF/Stop Payments                        0.00           0
  Adjusted Balance:            109,543.14                   Average Payment Days                                   34
                                                            Average Days Late                                      24
     ( In Collection                 0.00       )           Number Of Late Payments                               435
                                                            Number Of On Time Payments                             38


----Customer Level Credit Summary---
----------------------- Credit Summary ----------------------
Indicator                                                Value
-------------------------------------------------  -----------
Credit Tolerance                                            0%
Credit Rating                                              N/A
Risk Code                                                  N/A
Credit Hold                                                 No
Account Status                                             N/A
Standard Terms                                            None
Exempt From Dunning                                         No
Collector                                         Doctor Smith


Indicator                                   Amount       Value
--------------------------------  ----------------  ----------
Currency                                                  USD
Credit Limit                            25,000.00
Order Credit Limit
Available Credit                             0.00
Exceeded Credit Amount                 -85,796.36


Casino Gaming US                                        Customer Credit Snapshot                         Report Date: 29-MAR-2014 10:32
                                                                                                            Page:     2  of       3





----------------------------------------------------- Last Transaction Summary -----------------------------------------------------
Transaction       Number          Type            Related Invoice Currency           Amount  Date      Days Since Next Trx Date
----------------- --------------- --------------- --------------- -------- ----------------  --------- ---------- ------------------
Invoice           1703583         WAP-INV         N/A             USD              3,812.53  07-JAN-15         22
Credit Memo       323151          Capital Lease-C 323107          USD            -68,620.00  04-DEC-14         56
Guarantee         None
Deposit           None
Debit Memo        None
Chargeback        None
Payment           89913           Cash                            USD              6,349.47  30-DEC-14         30
Adjustment        None
Writeoff          N/A                             1699209         USD                 -0.02  02-JAN-15         27
Statement         None
Dunning           None
NSF/Stop Payment  None
Telephone Contact None
Credit Hold       None


Casino Gaming US                                        Customer Credit Snapshot                         Report Date: 29-MAR-2014 10:32
                                                                                                            Page:     3  of       3


Customer Name:  Ideal Gambling Services                                       Customer Age  2.4 Years
Customer Number:  15770                                                     Address Age:  2.4 Years
Billing Address:  Attention: Accounts Payable                                   Contact:
                 P.O. Box 98786                                                  Phone:
                 LAS VEGAS, , NV  89193-8786
                 United States
      Location:  Parts-LAS VEGAS




----Customer Level Credit Summary---
----------------------- Credit Summary ----------------------
Indicator                                                Value
-------------------------------------------------  -----------
Credit Tolerance                                            0%
Credit Rating                                              N/A
Risk Code                                                  N/A
Credit Hold                                                 No
Account Status                                             N/A
Standard Terms                                            None
Exempt From Dunning                                         No
Collector                                         Doctor Smith


Indicator                                   Amount       Value
--------------------------------  ----------------  ----------
Currency                                                  USD
Credit Limit                            25,000.00
Order Credit Limit
Available Credit                        25,000.00
Exceeded Credit Amount                       0.00


----------------------------------------------------- Last Transaction Summary -----------------------------------------------------
Transaction       Number          Type            Related Invoice Currency           Amount  Date      Days Since Next Trx Date
----------------- --------------- --------------- --------------- -------- ----------------  --------- ---------- ------------------
Invoice           None
Credit Memo       None
Guarantee         None
Deposit           None
Debit Memo        None
Chargeback        None
Payment           None
Adjustment        None
Writeoff          None
Statement         None
Dunning           None
NSF/Stop Payment  None
Telephone Contact None
Credit Hold       None


This is a standard functionality in Oracle Release 12 (R12). No customizations or setups required for this to work.

NJoy :)