Oracle Applications Blog

Create and populate the following table to provide some JSON data to work with. DROP TABLE json_documents PURGE;   CREATE TABLE json_documents (   id    RAW(16) NOT NULL,   data  CLOB,   CONSTRAINT json_documents_pk PRIMARY KEY (id),   CONSTRAINT json_documents_json_chk CHECK (data IS JSON));   INSERT INTO json_documents (id, data) VALUES (SYS_GUID(),         '{           "FirstName"      : "John",           "LastName"       : "Doe",           "Job"            : "Clerk",           "Address"        : {          ...

Set up profiles for the User / Responsibility to be used to reproduce the issue Responsibility : System Administrator Navigation : Profile > System Query up the Application, Responsibility and User you will use to reproduce the issue you want to debug. For example: Application = Receivables Responsibility = Receivables Manager User = MYUSER1 Profile = FND%Debug% then set the profiles as shown below: Profile Name Suggested value Comments FND: Debug Log Enabled YES This turns the debugging feature on FND: Debug Log Filename  or FND: Debug Log Filename for Middle-Tier leave this blank/null at all levels Use when you want debug messages to get stored to a file. Note however, that the preferred method of downloading debug messages to a .xls file is provided in step 5 below. FND: Debug Log Level Statement Following are options listed from least to most detailed debugging : Unexpected, Error, Exception, Event, Procedure, Statement FND: Debug Log Module % Indicate what modules to d...

Refer  Reducing the Oracle E-Business Suite Data Footprint (Doc ID 752322.1)