How to remove spaces in RTF Based Excel Output in Oracle APPS(XML Publisher Report)

Standard Trial Balance report output is Text. So client wanted to convert this report output to Excel. After converting standard Trial Balance report to excel we found issue like amount columns having leading and trailing spaces.

With this user unable to do SUM and other mathematical calculations. 

To remove spaces use below xdo function.

<?xdoxslt:trim(DISP_BEGIN_BALANCE)?>

This will remove leading and trailing spaces in Excel Output File.

Query to get GL Account Description in Oracle APPS using GL_FLEXFIELDS _PKG

SELECT gcc.code_combination_id

  ,gcc.segment1

  ,apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,1,gcc.segment1) SEGMENT1_DESC

  ,gcc.segment2

  ,apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,2,gcc.segment2) SEGMENT2_DESC

  ,gcc.segment3

  ,apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,3,gcc.segment3) SEGMENT3_DESC

  ,gcc.segment4

  ,apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,4,gcc.segment4) SEGMENT4_DESC

  ,gcc.segment5

  ,apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,5,gcc.segment5) SEGMENT5_DESC

  ,gcc.segment6

  ,apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,6,gcc.segment6) SEGMENT6_DESC

FROM gl_code_combinations gcc

WHERE gcc.code_combination_id = 100000

Here gl_flexfields_pkg.get_description_sql has below parameters:

1. Chart of Account ID
2. Number of the Segment
3. Segment value for which we need Description

Dependent Values in DFF Enabled Fields in Oracle APPS

 We can use :$FLEX$.Previous_Value_Set_Name to get dependent Values in DFF Enabled Fields in Oracle APPS.

Functional Setup Manager in Oracle Fusion

• Functional Setup Manager is a web application that enables you to manage and perform functional configuration tasks for offerings. 
• FSM is installed and deployed as part of OTBI Enterprise for HCM Cloud Service. 
• FSM generates a list of configuration tasks specific to the offering and functional areas that were selected. These tasks can be assigned to different functional developers and the status of the implementation project can be monitored in FSM.
• Functional Setup Manager user interfaces guide functional developers through the performance of each task. 

Configuration Manager in Oracle Fusion

• Configuration Manager is a web application for setting up and maintaining an OTBI Enterprise for HCM Cloud Service environment. 
• It also provides a quick review of setup values, and is the tool for monitoring and troubleshooting load plan executions. 
• Configuration Manager works in conjunction with Functional Setup Manager to provide guided tasks to configure offerings and functional areas.
• Using Configuration Manager, migrate configuration data across environments, using the import and export options.
• Use Configuration Manager to Monitor and manage setup data also monitor and manage load plans.

Reconciled & Unreconciled Transactions Reports in Oracle Fusion

• Reconciled Transactions Report provides details of clearing account journal lines that have been successfully reconciled by both automatic and manual reconciliation processes.

• Unreconciled Transactions Report lists all unreconciled clearing account journal lines, specifically the unreconciled lines that weren't subjected to reconciliation yet, those lines rejected by previous automatic or manual reconciliation processes, and those lines that were marked as reviewed.

Journals Day Book Report in Oracle Fusion

• This report provides posted journal entries and journal details chronologically by accounting date for a specified range of dates, journal source, and journal category.
• Report sorts journal entries for each accounting date by document number.
• It prints the accounting date, document number, journal entry name, journal source and category, subledger document name and number, currency, and conversion rate.
• Report prints for each journal line, the line number, account segment value and description, functional debit and credit amounts, description, and cost center segment value.

Journals Details Report in Oracle Fusion

• This report provides information about manually entered journals prior to posting, including field by field, all data entered into the applications or data imported from external sources.

Journals Batch Summary Report in Oracle Fusion

• This report lists posted journal batches for a particular ledger, balancing segment value, currency, and date range. 
• It provides information about actual balances for your journal batches, source, batch, and posting dates, total entered debits and credits. 
• Report sorts the information by journal batch within each journal entry category.
• This report includes totals for each journal category and a grand total for each ledger and balancing segment value combination.
• It doesn't report on budget or encumbrance balances.

General Journals Report in Oracle Fusion

• This report provides journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

Journals Report in Oracle Fusion

• This report provides Journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.
• It also prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal.
• Report includes a total for each balancing segment and a grand total for all the activity. 

Average Balance Audit Account Analysis Report in Oracle Fusion

• This Report displays the detail account activity that created the aggregate balances and related average balances.
• It displays daily Average Balance information for the selected accounts for the specified range of dates.
• It contains parameters such as the As-Of reporting date, average balance type (period,quarter, or year average-to-date), and account ranges.

Account Analysis for Contra Account Report in Oracle Fusion

• This report Prints balances by account segment and a secondary segment.
• It lists the contra account for each journal entry and the subledger document number for transactions imported from subledgers.
• It prints by date range, accounting Flex Field range, contra account, and amount range.

General Ledger Account Details Report in Oracle Fusion

• Provides journal information to trace each transaction back to its original source.
• Prints a separate page for each balancing segment value.
• For each journal line it prints the account affected, the concatenated description, the journal line amount, and the beginning and ending account balance.
• It also prints Journal details including source, category, journal name, and effective date.
• Report lists accounts in ascending order by account segment value.
• It prints a CR next to credit amounts

Account Analysis Report in Oracle Fusion General Ledger

• Prints balances by account segment and a secondary segment for each journal entry.
• Lists the subledger document number for transactions imported from subledgers. 

API to End Date FND_USER in Oracle APPS

DECLARE

    l_user_name       VARCHAR2(100)  := 'SYSADMIN';

    l_user_end_date   DATE  := SYSDATE+1;

BEGIN

fnd_user_pkg.updateuser(x_user_name               => l_user_name

                           ,x_owner                   => NULL

                           ,x_unencrypted_password    => NULL

                           ,x_start_date              => NULL

                           ,x_end_date                => l_user_end_date

                           ,x_password_date           => NULL

                           ,x_password_lifespan_days  => NULL

                           ,x_employee_id             => NULL

                           ,x_email_address           => NULL

);

 COMMIT;

EXCEPTION

  WHEN OTHERS THEN

    ROLLBACK;

    DBMS_OUTPUT.PUT_LINE(SQLERRM);

END;