Concurrent request fails: ORACLE error 1722 in FDPSTP: SELECT R.Conc_Login_Id, R.Re

Error message:

ORACLE error 1722 in FDPSTP

Cause: FDPSTP failed due to ORA-01722: invalid number
ORA-06512: at "APPS.XX_CUSTOM_PKG", line 216
ORA-06512: at line 1
.

The SQL statement being executed at the time of the error was: SELECT R.Conc_Login_Id, R.Re

Solution:
This issue is usually because EBS user preference has a number format 10.000,00.
Use a user which has number 10,000.00. This works fine!

For solution details, please check Doc ID 2220885.1 where additional steps are provided to get rid of this issue.

Hiding Vacation Rules Tip and OAF Personalization

These are the steps to hide Vacation Rule Tip:

1. Make sure personalization profile options are enabled.
FND: Personalization Region Link Enabled = Yes
Personalize Self-Service Defn = Yes
2. Log in to the home page and click personalize page in upper right corner.
3. Select Complete View and Expand All.
4. Locate line for "Tip: (Notifications.vacationRulesTip)".
5. Click on pencil and change property Rendered at level you want (Site / Function / Resp) from Inherit to False.

I, by mistake, chose Admin Personalization to False at site level in step 5. This made the pencil (for changing property) disappear from personalization page. To get rid of such incorrect personalization, followed the following steps:

1) Login to Oracle Applications as SYSADMIN
2) Select Functional Administrator [resp] > Personalization [tab]
3) Fill in the criteria to locate the OA Framework page and press Go
    Tip: Check 'Personalized' checkbox to only query the pages having a personalization
    In my case, path = /oracle/apps/fnd/wf/worklist/webui/AdvancWorklistRG
4) Identify the correct page from the results returned
5) Deleted the site level personalization.

Reference:
How to Hide Vacation Rules Tip or Worklist Access Tip in Workflow Notifications Screen (Doc ID 972361.1)
How to Remove / Disable an OA Framework Personalization (Doc ID 304670.1)

J2SE issue in IE R12

1) In internet explorer 11 , navigate to Tools –> Compatibility View Settings . Then add Domain name in the URL (ex: orapps.com in erp.oraapps.com) using Add this website option.

2) Navigate to Tools –> Internet options –> Security . Select internet and click on Custom level. Scroll down till end of the options and change the option Enable XSS filter to  Disable.

Oracle Payables Most Frequently Used Knowledge Content of 2013

https://blogs.oracle.com/ebs/entry/the_10_most_frequently_used

Concatenated Index explained

I have very simple requirements of indexing Oracle GL base tables. So taking the opportunity to write this post.

Table: GL_JE_LINES

First of all, checking the exisiting indexes by running this query.
Select * From All_Ind_Columns Where Table_Name = 'GL_JE_LINES';

Attribute19 in the table is keeping the link to the journal import file. It is used heavily for queries. I considred few more comlumns and created indexes as follows.

EXECUTE IMMEDIATE
   'CREATE INDEX XXGL.XXGL_PERF_gl_je_lines_n1 '||
      'ON gl.gl_je_lines (attribute19, ledger_id) '||
      'TABLESPACE APPS_TS_TX_IDX';

Execute Immediate
   'CREATE INDEX xxgl.xxgl_perf_gl_je_lines_n2 '||
      'ON gl.gl_je_lines (ledger_id, period_name, effective_date, status, code_combination_id, je_header_id) '||
      'TABLESPACE APPS_TS_TX_IDX';

Execute Immediate
   'CREATE INDEX XXGL.XXGL_PERF_GL_JE_LINES_N3 '||
      'ON GL.GL_JE_LINES(attribute19) '||
      'TABLESPACE APPS_TS_TX_IDX ';

How to check which index is being used while running select statements?
Run the following commands in order to see the execution plan that shows what index is going to be used by the select.
Explain Plan For Select * From gl_je_lines Where ledger_id = 2021 and period_name = '2015-01';
select * from table(dbms_xplan.display);

In a concatenated index, the first column is the primary sort criterion and the second column determines the order only if two entries have the same value in the first column and so on.

So if a select query is written as follows, its not going to use xxgl_perf_gl_je_lines_n2 index, instead will do a full table scan:
select * from gl_je_lines Where effective_date = '15-05-2015';

More explanation is provided in the link below, a very good and simple article to read.

use-the-index-luke.com

Happy indexing!

Oracle EBS Videos

Oracle GL, Purchasing and Inventory Mandatory Setup (No Audio):

Oracle Inventory:
Oracle inventory menu explanation and organization structure overview

Inventory Organization Setup Parameters explained

Oracle EBS Organization Structure Explained:

Video 1

Video 2

Oracle Apps R12 Subledger Accounting Tables and joins

Coudn't stop myself from copying this post from:
http://www.oracleappsdeveloper.com/2014/02/oracle-apps-r12-subledger-accounting.html

:)

XLA Table joins
GL_JE_BATCHES (je_batch_id)                        => GL_JE_HEADERS (je_batch_id)
GL_JE_HEADERS (je_header_id)                      => GL_JE_LINES (je_header_id)
GL_JE_LINES (je_header_id,  je_line_num)        => GL_IMPORT_REFERENCES (je_header_id, je_line_num)
GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id)        => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id)
XLA_AE_LINES (application_id, ae_header_id)  => XLA_AE_HEADERS (application_id, ae_header_id)
XLA_AE_HEADERS (application_id, event_id)   => XLA_EVENTS (application_id, event_id)
XLA_EVENTS (application_id, entity_id)            => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id)

Transaction Entity Codes and ids
xte.entity_code =
'TRANSACTIONS' or
'RECEIPTS' or
'ADJUSTMENTS' or
'PURCHASE_ORDER' or
'AP_INVOICES' or
'AP_PAYMENTS' or
'MTL_ACCOUNTING_EVENTS' or
'WIP_ACCOUNTING_EVENTS'

xte.source_id_int_1 =
'INVOICE_ID' or
'CHECK_ID' or
'CUSTOMER_TRX_ID' or
'TRANSACTION_ID'

XLA_EVENTS:
SELECT *  FROM xla_events xe
WHERE xe.application_id = 222
AND xe.entity_id IN (
SELECT xte.entity_id
FROM xla.xla_transaction_entities xte
WHERE xte.application_id = 222
AND xte.entity_code = 'TRANSACTIONS'
AND xte.source_id_int_1 = 10066)

XLA_AE_HEADERS:
SELECT *  FROM xla_ae_headers xah  WHERE xah.application_id = 222
AND xah.entity_id IN (
SELECT xte.entity_id
FROM xla.xla_transaction_entities xte
WHERE xte.application_id = 222
AND xte.entity_code = 'TRANSACTIONS'
AND xte.source_id_int_1 = 10066)

XLA_AE_LINES:
SELECT xal.*  FROM xla_ae_lines xal, xla_ae_headers xah  WHERE xal.application_id = xah.application_id
AND xal.ae_header_id = xah.ae_header_id
AND xah.application_id = 222
AND xah.entity_id IN (
SELECT xte.entity_id
FROM xla.xla_transaction_entities xte
WHERE xte.application_id = 222
AND xte.entity_code = 'TRANSACTIONS'
AND xte.source_id_int_1 = 10066)

XLA_DISTRIBUTION_LINES:
SELECT xdl.*  FROM xla_distribution_links xdl, xla_ae_headers xah  WHERE xdl.application_id = xah.application_id
AND xdl.ae_header_id = xah.ae_header_id
AND xah.application_id = 222
AND xah.entity_id IN (
SELECT xte.entity_id
FROM xla.xla_transaction_entities xte
WHERE xte.application_id = 222
AND xte.entity_code = 'TRANSACTIONS'
AND xte.source_id_int_1 = 10066)


XLA_AE_HEADER status Columns
 Table stores important status Information
GL Transfer Status Code (GL_TRANSFER_STATUS_CODE)
The GL transfer status code of the sub-ledger journal entry has one of the following values:
Not transferred
Selected to transfer
Transferred
When a sub-ledger journal entry is created and completed, the value of this column is Not transferred. The Transfer to GL process updates this column when the subledger journal entry is transferred to General Ledger.

Subledger Journal Entry Status Code (ACCOUNTING_ENTRY_STATUS_CODE)
A subledger journal entry can have a status of Draft, Final, Incomplete, Invalid or Invalid Related Entry.
Draft: The entry status is set to Draft when the following conditions are met:
Final: The entry status is set to Final when the following conditions are met:
Incomplete: The entry status is set to Incomplete when the following condition is met:
Invalid Related Entry: The entry status is set to Invalid Related Entry when the following condition is met:

The subledger journal entry is valid, but one or more of the other subledger journal entries associated with the same accounting event are invalid.


XLA_DISTRIBUTION_LINKS table join based on Source Distribution Types
xdl.source_distribution_type = 'AP_PMT_DIST '
and xdl.source_distribution_id_num_1 = AP_PAYMENT_HIST_DISTS.payment_hist_dist_id
---------------
xdl.source_distribution_type = 'AP_INV_DIST'
and xdl.source_distribution_id_num_1 = AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id
---------------
xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
and xdl.source_distribution_id_num_1 = AR_DISTRIBUTIONS_ALL.line_id
and AR_DISTRIBUTIONS_ALL.source_id = AR_RECEIVABLE_APPLICATIONS_ALL.receivable_application_id
---------------
xdl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
and xdl.source_distribution_id_num_1 = RA_CUST_TRX_LINE_GL_DIST_ALL.cust_trx_line_gl_dist_id
---------------

xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
and xdl.source_distribution_id_num_1 = MTL_TRANSACTION_ACCOUNTS.inv_sub_ledger_id
---------------
xdl.source_distribution_type = 'WIP_TRANSACTION_ACCOUNTS'
and xdl.source_distribution_id_num_1 = WIP_TRANSACTION_ACCOUNTS.wip_sub_ledger_id
---------------
xdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'
and xdl.source_distribution_id_num_1 = RCV_RECEIVING_SUB_LEDGER.rcv_sub_ledger_id

Oracle EBS R12 WebADI: Make it work with MS Office 2010

In Excel 2010

Go to File > Options. Following screen will open

Select Trust center

Click on Trust center settings

Select ActiveX Settings and make sure setting match following screen

Then click on Macro Settings and make sure settings match as following

Click on Protected View and make sure setting match as following

Click on External Contents and make sure setting match as following

Press Ok. Then again Press OK.

Should work now.... !! If it doesn't, check your IE settings

Now in Internet explorer

Go to Tools > Internet Options

Click on Security

Select Internet and then on Custom Level

Scroll Down to Download portion and match settings with following

Then Scroll down to miscellaneous section and match setting with following

Then Scroll Down to Scripting section and match setting with following

Press OK. Then again press OK.

Cheers!

Credit: http://mhizbullah.blogspot.se/2012/05/r12-web-adi-make-it-work-with-ms-office.html

Delete Balance Level Reporting Currency from Accounting Setup Manager (Oracle GL)

Deletion of Balance Level Reporting Currency is not supported by Oracle EBS. Workaround is to stop running translation. But I needed to get rid of the reporting currency anyway. So I've tested the deletion from the oracle base table where it stores the Relationship of the ledger with the reporting currency. It worked!


delete from GL_LEDGER_RELATIONSHIPS where relationship_id = 1001;

Of course, I took a backup of the table before running the statement ;-)

Cheers!

Retained Earning Account vs Net Income Account

Very nicely described in this website:

The primary difference between retained earnings and net income is time. Net income is the bottom-line profit your business earns for a given period. Retained earnings is the accumulation of those earnings over time to reinvest in the business or to maintain as a safety net.

Details: http://smallbusiness.chron.com/difference-between-retained-earnings-net-income-60293.html

How to Calculate Net Income From Retained Earnings

http://smallbusiness.chron.com/calculate-net-income-retained-earnings-21182.html

Accounts in Ledger Setup R12

YEAR END PROCESSING

Retained Earnings Account:

This account is used during the year-end processing to record cumulative retained earnings.

Net Closing Balance flag: Yes or No?

You have two choices at close period of the year end:

A. Let the open new period close down all the income statement accounts and put the results in the retained earnings in the same way it has always done. This also rolls the balance sheet accounts into the first period of the new year like it does any other period.

B. Create a journal showing the movement of the income statement accounts into retained earnings or an account of your choice. You can also create a journal for the balance sheet accounts showing what will be used as opening balances next year. This is to fulfill a legal requirement in some countries specially France.

If you choose B then the option in the 'Net Closing Balance Journal' choice in the Accounting Setup Manager comes into effect. This will close the balances either as a net figure to the closing journal (when ticked) or as Cr and Dr figure to the closing journal (by default). The Net closing flag allow users to choose between closing balances by journaling out both the Dr and the Cr balance or just the net balance on a code combination [ Retained Earnings ].

CURRENCY TRANSLATION OPTIONS:

Cumulative Translation Adjustment Account:

This account is used to record the cumulative adjustment for translations. Once this account is used in a translation, it cannot be updated.

The CTA account is not filled through a calculation, it is simply a plug between the difference in the debits and credits after translation is run. Since the Assets/Liabilities, OE, and Revenue/Expenses typically use different translation rates, it is common for the translated balances not to equal. Therefore, the CTA will simply fill in the difference to make the debits equal the credits. There is no calculation for this account.

AVERAGE BALANCES

Net Income Account:

This account captures the net income on the average balances.

ROUNDING ACCOUNT & SUSPENSE ACCOUNT

When the rounding account is used and when the suspense account is used?

A. During Journal Import of a foreign currency journal
1.If the currency conversion type in GL_INTERFACE is not provided, and the accounted amounts are provided, then any imbalance in the accounted amounts will go to Suspense.
2.If the currency conversion type is provided in GL_INTERFACE for the  foreign currency journal, and the currency conversion type is User with a currency conversion rate of 1, then any imbalance in the accounted amounts will be posted to the Suspense account.
3.If the currency conversion type is provided for a foreign currency journal, and it is not User with a rate of 1,  then and only then will the imbalance go to the rounding account.
This is because when Journal Import and consequently Posting is presented  with user-defined accounted amounts, GL has no way of knowing the if the difference in the accounted amounts is due to suspense or rounding.
Currently, we are assuming that the difference should go to suspense.

B. In the Enter Journals form:

1. If the user manually overrides the    accounted amounts, the assumption is that the difference in the accounted  amounts is due to suspense and not rounding, since the user explicitly chose to override the accounted amounts.If you manually change the accounting amount the conversion_flag is set to  'N' in    the created headers, therefore, posting is rejecting the batch instead of balancing it by adding the rounding difference to a  journal lines.

Oracle doc Doc ID 340341.1

Install Oracle Workflow Builder on Windows 7/8 64Bit

Install Oracle Workflow Builder on Windows 7/8 64Bit

Download the installer package ( http://www.oracle.com/technetwork/database/options/winclient-101059.html)
Unzip it
Go to the install folder

Change the compatibility mode

Backup your OS path string under Advance settings and “SAVE” the information in a text file.
Remove all entries other than what referring to the %systemroot% and bring the string length less than 1000 characters.
Now go ahead with installing the wokflow builder

Follow the prompts until the installation completes successfully.

Run the “Oracle Workflow Builder” as Administrator. You may create a shortcut on the desktop and change the properties to run as administrator permenently. Without administrator rights, this legacy software will fail to read the registry values, thus end up producing the error mentioned with this thread
https://community.oracle.com/thread/2343986


Observe the additional entries added with the PATH environment string.
Amend your backed up PATH string with the new entries and replace the PATH string.

Hope you enjoyed yet another post from us!
Credit: http://windows7bugs.wordpress.com/2013/12/22/install-oracle-workflow-builder-on-windows-78-64bit/

R12 - What Is The Use Of "Net Closing Balance Flag" In Accounting Setup Manager [ID 1235283.1]

Please note this feature is only visible and usable in R12.1.2 and later.

You have two choices at close period of the year end:

A. Let the open new period close down all the income statement accounts and put the results in the retained earnings in the same way it has always done. This also rolls the balance sheet accounts into the first period of the new year like it does any other period.

B. Create a journal showing the movement of the income statement accounts into retained earnings or an account of your choice. You can also create a journal for the balance sheet accounts showing what will be used as opening balances next year. This is to fulfill a legal requirement in some countries notably France.

If you choose B then the option in the 'Net Closing Balance Journal' choice in the Accounting Setup Manager OA page comes into effect. This will close the balances either as a net figure to the closing journal (when ticked) or as Cr and Dr figure to the closing journal (by default).

Functionality before this fix closes the account by posting the debit sum in the credit and vice versa.

The Net closing flag was introduced in response to bug 7675261 to allow users to choose between closing balances by journalling out both the Dr and the Cr balance or just the net balance on a code combination.
The patch introduced the 'Net Closing Balance Journal' check box in the Accounting Setup Manager OA page. It also adds NET_CLOSING_BAL_FLAG to the GL_LEDGERS and GL_LEDGERS_V


This also impacts the following Close Process:
Create Balance Sheet Closing Journals program
Create Income Statement Closing Journals program.
Added validations for Net Closing Balance Journal check box in Accounting Setup Manager for each ledger

This feature was added in the following patch 8265487:R12.GL.A and unpublished R12.GL.B.delta.2 - Bug 8516733 - Note even though its added in GL.A the feature can only be used in 12.1.2 and later and the checkbox will not be visible before that time.

In unpublished bug 9693032, we have fixed the issue where the newly introduced check boxes information is not coming up in the review page. This was added to a completely different issue that made visible the Synchronize Reversals between Primary and Secondary Ledger under Journal Processing.

This patch is available in Patch 9776694 R12.GL.B and GL.A
GLASFlowLedgerReviewCO.java
GL_ASF_LEDGER_REVIEW_PG.xml


1. Select the GL Superuser Responsibility .
2. select Accounting Setup manager
3. Create Ledger
4. Set up Accounting Setup manager for the ledger
5. Check or leave Unchecked the Net Closing Balance check box depending on the user requirement
6. Run the Close Process: Create Income Statement Closing Journals program.
7. The Close Process: Create Income Statement Closing Journals program creates a journal balancing all income statement account balances to Retained earnings account/income offset account.
8. Post the above journal.
9. Run Close Process: Create Balance Sheet Closing Journals
program
10. Validate if accounting entries have been produced correctly.

Credit: http://oracleeze.blogspot.se/2013/02/r12-what-is-use-of-net-closing-balance.html

Oracle Apps General Ledger (GL) KEY Tables

GL_SETS_OF_BOOKS
GL_SETS_OF_BOOKS stores information about the sets of books you define in your Oracle General Ledger application. Each row includes the set of books name, description, functional currency, and other information. This table corresponds to the Set of Books form.
GL_IMPORT_REFERENCES
GL_IMPORT_REFERENCES stores individual transactions from subledgers that have been summarized into Oracle General Ledger journal entry lines through the Journal Import process. You can specify the journal entry sources for which you want to maintain your transaction’s origin by entering ’Yes’ in the Import Journal References field of the Journal Sources form. For each source that has Import Journal References set to ’Yes’, Oracle General Ledger will populate GL_IMPORT_REFERENCES with one record for each transaction in your feeder system.
GL_DAILY_RATES
GL_DAILY_RATES stores the daily conversion rates for foreign currency transactions. It replaces the GL_DAILY_CONVERSION_RATES table.
It stores the rate to use when converting between two currencies for a given conversion date and conversion type. Each row in this table has a corresponding inverse row in which the from and to currencies are switched. For example, if this table contains a row with a from_currency of YEN, a to_currency of CND, a conversion_type of Spot, and a conversion_date of January 1, 1997, it will also contain a row with a from_currency of CND, a to_currency of YEN, a conversion_type of Spot, and a conversion_date of January 1, 1997.
In general, this row will contain a rate that is the inverse of the matching row. One should never insert directly into this table. They should instead insert into the DAILY_RATES_INTERFACE table. Data inserted into the GL_DAILY_RATES_INTERFACE table will be automatically copied into this table
GL_PERIODS
GL_PERIODS stores information about the accounting periods you define using the Accounting Calendar form. Each row includes the start date and end date of the period, the period type, the fiscal year, the period number, and other information. There is a one–to–many relationship between a row in the GL_PERIOD_SETS table and rows in this table.
GL_JE_HEADERS
GL_JE_HEADERS stores journal entries. There is a one–to–many relationship between journal entry batches and journal entries. Each row in this table includes the associated batch ID, the journal entry name and description, and other information about the journal entry. This table corresponds to the Journals window of the Enter Journals form. STATUS is ’U’ for unposted, ’P’ for posted. Other statuses indicate that an error condition was found. CONVERSION_FLAG equal to ’N’ indicates that you manually changed a converted amount in the Journal Entry Lines zone of a foreign currency journal entry. In this case, the posting program does not re–convert your foreign amounts. This can happen only if your user profile option MULTIPLE_RATES_PER_JE is ’Yes’. BALANCING_SEGMENT_VALUE is null if there is only one balancing segment value in your journal entry. If there is more than one, BALANCING_SEGMENT_VALUE is the greatest balancing segment value in your journal entry.
GL_JE_LINES
GL_JE_LINES stores the journal entry lines that you enter in the Enter Journals form. There is a one–to–many relationship between journal entries and journal entry lines. Each row in this table stores the associated journal entry header ID, the line number, the associated code combination ID, and the debits or credits associated with the journal line. STATUS is ’U’ for unposted or ’P’ for posted.
GL_JE_BATCHES
GL_JE_BATCHES stores journal entry batches. Each row includes the batch name, description, status, running total debits and credits, and other information. This table corresponds to the Batch window of the Enter Journals form. STATUS is ’U’ for unposted, ’P’ for posted, ’S’ for selected, ’I’ for in the process of being posted. Other values of status indicate an error condition. STATUS_VERIFIED is ’N’ when you create or modify an unposted journal entry batch. The posting program changes STATUS_VERIFIED to ’I’ when posting is in process and ’Y’ after posting is complete.
GL_BALANCES
GL_BALANCES stores actual, budget, and encumbrance balances for detail and summary accounts. This table stores functional currency, foreign currency, and statistical balances for each accounting period that has ever been opened. ACTUAL_FLAG is either ’A’, ’B’, or ’E’ for actual, budget, or encumbrance balances, respectively. If ACTUAL_FLAG is ’B’, then BUDGET_VERSION_ID is required. If ACTUAL_FLAG is ’E’, then ENCUMBRANCE_TYPE_ID is required.
GL_BALANCES stores period activity for an account in the PERIOD_NET_DR and PERIOD_NET_CR columns. The table stores the period beginning balances in BEGIN_BALANCE_DR and BEGIN_BALANCE_CR.
An account’s year–to–date balance is calculated as BEGIN_BALANCE_DR – BEGIN_BALANCE_CR + PERIOD_NET_DR – PERIOD_NET_CR. Detail and summary foreign currency balances that are the result of posted foreign currency journal entries have TRANSLATED_FLAG set to ’R’, to indicate that the row is a candidate for revaluation.
For foreign currency rows, the begin balance and period net columns contain the foreign currency balance, while the begin balance and period net BEQ columns contain the converted functional currency balance.Detail foreign currency balances that are the result of foreign currency translation have TRANSLATED_FLAG set to ’Y’ or ’N’. ’N’ indicates that the translation is out of date (i.e., the account needs to be re–translated). ’Y’ indicates that the translation is current.
Summary foreign currency balances that are the result of foreign currency translation have TRANSLATED_FLAG set to NULL. All summary account balances have TEMPLATE_ID not NULL. The columns that end in ADB are not used. Also, the REVALUATION_STATUS column is not used.
GL_CODE_COMBINATIONS
GL_CODE_COMBINATIONS stores valid account combinations for each Accounting Flexfield structure within your Oracle General Ledger application. Associated with each account are certain codes and flags, including whether the account is enabled, whether detail posting or detail budgeting is allowed, and others.
Segment values are stored in the SEGMENT columns. Note that each Accounting Flexfield structure may use different SEGMENT columns within the table to store the flexfield value combination. Moreover, the SEGMENT columns that are used are not guaranteed to be in any order.
The Oracle Application Object Library table FND_ID_FLEX_SEGMENTS stores information about which column in this table is used for each segment of each Accounting Flexfield structure. Summary accounts have SUMMARY_FLAG = ’Y’ and TEMPLATE_ID not NULL. Detail accounts have SUMMARY_FLAG = ’N’ and TEMPLATE_ID NULL.

Change branding text as E-Business Suite on homepage in R12

1. Login as SYSTEM ADMINISTRATOR
2. Open Application > Function
3. Query the function FWK_HOMEPAGE_BRAND
4. Replace the User Function Name with the text you would like to appear
5. Query the function OAHOMEPAGE
6. Click on tab Web HTML and make sure it looks like this. If not, update it as follows

OA.jsp?page=/oracle/apps/fnd/framework/navigate/webui/HomePG&homePage=Y&OAPB=FWK_HOMEPAGE_BRAND

7. Save, logout and login. You should see the change now!!!

Balancing Entity in R12

A balancing entity is one for which you prepare a balance sheet as a balancing segment value in the Accounting Flexfield structure. In any OU, you can have multiple balancing entities and each of these must balance within itself.

http://www.oracleerpappsguide.com/2012/01/balancing-entity-in-r12.html?m=1

Concurrent Program: phase_code, status_code meanings

Very old but still useful stuff...

status_code and phase_code in FND_CONCURRENT_REQUESTS table

PHASE_CODE column
C - Completed
I - Inactive
P - Pending
R - Running

 

STATUS_CODE Column:

A - Waiting
B - Resuming
C - Normal
D - Cancelled
E - Error
F - Scheduled
G - Warning
H - On Hold
I - Normal
M - No Manager
Q - Standby
R - Normal
S - Suspended
T - Terminating
U - Disabled
W - Paused
X - Terminated
Z - Waiting

How to examine OPP logs

From the application:

- Login to System Administrator Responsibility
- Navigate to: Concurrent > Manager > Administer
- Select the Output Post Processor
- Click on the Processes button
- Select the process that was active when the request ran
- Click on the Manager Log button to open the OPP log file

From the file system:

SQL> SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
WHERE fcpp.processor_id = fcp.concurrent_process_id
AND fcpp.action_type = 6
AND fcpp.concurrent_request_id = <request_id>;

Credit goes to

Hussein Sawwan. Copied from his OTN post

https://kr.forums.oracle.com/forums/thread.jspa?threadID=646563

EBS CP Parameters - small but useful stuff :)

Let's say you have 2 parameters in a EBS concurrent program (CP).

1 p_ledger_name
2. p_ledger_id

You want to set the value for the p_ledger_id based on the value choosen for p_ledger_name. You can do it this way.

SETP 1
=====
Set the p_ledger_name default parameter type = SQL Statement
SQL statement can be this which ensures the users get to choose only the ledgers they have access to.
select name from gl_ledgers where ledger_id = gl_access_set_security_pkg.get_default_ledger_id(:$PROFILES$.GL_ACCESS_SET_ID, 'R')

STEP 2
=====
p_ledger_id parameter should also be set as SQL Type and SQL can be as follows,
select gl_ledger_utils_pkg.get_ledger_id_of_short_name(:$FLEX$.GL_SRS_LEDGER_WITH_SETS_AND_ALCS_STORE_SHORT_NAME) FROM DUAL

Here GL_SRS_LEDGER_WITH_SETS_AND_ALCS_STORE_SHORT_NAME is the value set name of the p_ledger_name parameter (my first parameter). Now lets have a look at this Value Set.

This value set is a character type value set. Validation Type = Table. You can check the value set details by clicking Edit Information button.

STEP 3
=====
Save your CP and Test it. When you choose the ledger name in the first parameter, you will get the ledger id in the second parameter automatically. Cool!!

Program - Inherit Segment Value Attributes

The Segment Value Inheritance program automatically propagates the attributes of a segment value to all account combinations that contain that segment value.
To protect account combinations from changes when you run the Segment Value Inheritance program, check the Preserve check box in the GL Accounts window. You can assign attributes at two levels:

• The individual segment value in the Segment Values window.
• The account combination in the GL Accounts window.

For example, you can disable the 200 cost center segment in the Segment Values window, but retain existing account combinations using cost center 200 by marking the Preserve check box for each combination in the GL Accounts window. Then, when you run the Segment Value Inheritance program, all account combinations that contain the 200 cost center will be disabled except for those you preserved and no new combinations will be created during data entry.
You can view the account code combinations that have been changed in either the GL Accounts window or the Segment Value Inheritance Execution Report.
Warning: Individual segment value attributes override account combination attributes.

Source: http://www.oracleug.com/user-guide/general-ledger/segment-value-inheritance