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)

Oracle EBTax Important Tables

EBTAX SETUP TABLES

Following are the main E-Business tax tables that will contain the setup information that will help support in troubleshooting E-Business tax information.

a. Tax Regimes: ZX_REGIMES_B

b. Taxes: ZX_TAXES_B

c. Tax Status: ZX_STATUS_B

d. Tax Rates: ZX_RATES_B

e. Tax Jurisdictions: ZX_JURISDICTIONS_B

f. Tax Rules: ZX_RULES_B

To get a dump of the eTax setups, you can use the following set of queries.

Please provide the tax regime code when prompted. If the issue is limited to a tax then provide the tax name when prompted else please leave it blank.

SELECT *

FROM zx_regimes_b

WHERE tax_regime_code = '&tax_regime_code';

SELECT *

FROM zx_taxes_b

WHERE DECODE('&tax_name',null,'xxx',tax) = nvl('&tax_name','xxx')

AND tax_regime_code = '&tax_regime_code';

SELECT *

FROM zx_status_b

WHERE tax = '&tax_name'

AND tax_regime_code = '&tax_regime_code';

SELECT *

FROM zx_rates_b

WHERE tax = '&tax_name'

AND tax_regime_code = '&tax_regime_code';

SELECT *

FROM zx_jurisdictions_b

WHERE DECODE('&tax_name',null,'xxx',tax) = nvl('&tax_name','xxx')

AND tax_regime_code = '&tax_regime_code';

SELECT *

FROM zx_rules_b

WHERE tax = '&tax_name'

AND tax_regime_code = '&tax_regime_code';

Source: More Important Tax tables

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 Performance Tips - cool videos

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

Error getting Cluster Config Set URLs for uri (JDeveloper 10.1.3)

The error Error getting Cluster Config Set URLs for uri appeared when I was created Application Server Connection from JDeveloper. Application Server version 10.x. Please note that, this is a clustered environment.

The following workaround solution worked for me.

I used the IP address instead of the server name in the Host Name filed. It's worth looking at /etc/host entries to for the IP address. Retested the connection and getting this. I ignored this error. As long as you can use this Application Server Connection to create an Integration Server connection, its ok to ignore... worked for me  :-)



I find these links very helpful. Mentions some other workaround...

http://www.thisisahmed.com/tia/bpel/sslhandshakefailed.html

https://forums.oracle.com/thread/368201

Connection issue: No route to host

A nice step by step investigation and solution on this problem from OTN. Wanted to share... :)

------------------------
Hi all,

I have a problem with my BPEL process (vers. 10.1.3.4).
I am trying to call an external web service and I get the following error (I can access the web service just using its URL):

exception on JaxRpc invoke: HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: No route to host

I have tried pinging the remote server with success, so I should be able to connect (no proxy issue or something like that).

I have tried looking in the BPEL logs found at:
<oracle home>/opmn/logs
<oracle home>/bpel/system/logs
<oracle home>/bpel/domains/default/logs
This did not give anything useful either.

I deploy using JDeveloper. I have checked the proxy settings here - and there are none set.

Does anybody have any ideas as to what can be wrong?
Any help or hints will be much appreciated.

Regards,
Aagaard

------------------------

Hi Aagaard,

Maybe some open doors to kick in, but you say that you're able to ping the host of the webservice and can access it using it's url. Did you test it on you development machine or on the machine that is running Application Server? Since these need not be the same (often they're not, of course) it might be that you're server might have other routes thatn your development machine.

If the remote webservice is running on http://<webserver>:<port>/webservice I would open a terminal session on the server that's running your soasuite and not only do a ping but also a:
prompt>telnet <webserver> <port>
Note there is a space in stead of a colon between webserver and port.
This way you particularly connect to the webserver using on the given port. If there is no service listening on that port you would get a connection refused error.

Regards,
Martien

------------------------
Hi Martien,

Thank you for the swift reply.

Yes, I tried pinging from both development machine and from application server. Both successful.

Tried the telnet approach and interestingly enough that failed.

[oracle@prima logs]$ telnet csc2835139 18111
Trying 172.19.205.69...
telnet: connect to address 172.19.205.69: No route to host
telnet: Unable to connect to remote host: No route to host

So I guess that means that I can access the remote machine, but that no service is listening on the given port?
Even though I can access the web service via a web browser?

Regards,
Aagaard
------------------------

Correct Answer by MartienvandenAkker  on Oct 6, 2008 10:49 AM

 

Well it could also mean that from the server which is running your applicationserver the port 18111 is blocked. So I would check with your network-managers if this port is open from your applicationserver. They should check the firewalls (if you have no control on that yourself).

Often the situation at a customer is that your development pc is at one LAN while your (development, test, acceptance, production) application server is in a datacenter on a different sub-lan. With another fire-wall. From your development PC you need to access internet-http and maybe other protocols. But these are usually forbidden on the datacenter lan. You'll have a separate route from your development lan to the datacenter. Probably the server has 2 NICs: one for the internal network and one connected to the Demilitarized Zone. Within the DMZ probably a proxy/reverseproxy configuration routes the requests from outside to your application server and visa versa. So the proxy should also be checked.

This should normally the case at a customer-site, even when its a development environment. Because you don't want to have intruders hacking into your systems, even on development. And although you might not care, the dev-env should reflect your prod-env. So it should also use a dmz with a proxy/reverseproxy setup. If it is a setup on your laptop or your home lan your setup might be simpeler. But then again you might have to cope with different firewalls. If it is all on your laptop (using VMWare for example) I would try when temporarly shutdown all Firewalls.

You told that you did not have a proxy. Does that count for both your dev-pc as well as the application server?

------------------------

Hi Martien,

You were right. I did not have access to the port from the BPEL server.
Getting access solved my problem.

Thank you very much for the assist.

Cheers,
Aagaard

 

Source: https://forums.oracle.com/thread/716347#2801592