jump to navigation

ORA-12571: TNS Packet writer failure August 28, 2007

Posted by Muhammad Habib in Oracle Developer.
add a comment

Strange error!

My developer was running fine . why I got this error.

I had tried many solutions provided on web by oracle experts but unable to connect my developer to database. I had tried to remove developer from C:\orant directory and also from registry. Then I re-installed it. But I got same error. I made parameter sqlnet authentication … to “None” in “SQLNET.ORA” file – but unable to solve this problem.

At last I analyzed that after which event I was getting this error. That was installation of a software – Download Manager.

Actually it was interrupting services. At last I removed this software and connected successfully developer to DB.

Hope it will be helpful.

Advertisements

Protected: Creating a New Menu August 22, 2007

Posted by Muhammad Habib in Oracle Applications, Oracle Developer, Oracle Financials, Oracle General.
Enter your password to view comments.

This content is password protected. To view it please enter your password below:

Oracle Applications Desktop Integrator – ADI August 21, 2007

Posted by Muhammad Habib in Oracle Applications, Oracle Financials.
18 comments

I was confused about what is ADI. At last i found one user guide of oracle “115csadiug.pdf”. Its quite helpful. I want to share overview of ADI.

Oracle ADI is a spreadsheet-based extension to Oracle Applications that offers full cycle accounting and asset management within the comfort and familiarity of a spreadsheet. Oracle ADI combines a spreadsheet’s ease of use with the power of Oracle Applications, to provide true desktop integration during every phase of your accounting cycle. You can create budgets, record transactions, add assets, reconcile inventory, and run financial statements and inventory reports all without leaving your spreadsheet.

You can run Oracle ADI as a stand-alone application, without installing the full client version of Oracle General Ledger (GL) or Oracle Assets on your PC. This gives you the ability to confirm and reconcile inventory, revise budgets, create journal entries, and define financial and asset reports from any location, without being connected to your server. You only need to connect when you want to transfer data to or from Oracle Applications.

Figure describes how ADI integrates with other applications.

ADI

Sample Stock Report August 16, 2007

Posted by Muhammad Habib in Oracle Developer, Oracle General.
add a comment

—————————————————————
SCRIPT TO CREATE TABLES (OPN, RCT, ISU)
—————————————————————
create table OPN
(
Q_ID NUMBER,
OPN_QTY NUMBER,
OPN_DT DATE
);

create table RCT
(
Q_ID NUMBER,
RCT_QTY NUMBER,
RCT_DT DATE
);

create table ISU
(
Q_ID NUMBER,
ISU_QTY NUMBER,
ISU_DT DATE
);
—————————————————————
SCRIPT TO CREATE VIEW STK_V
—————————————————————
CREATE OR REPLACE VIEW STK_V AS
(
SELECT Q_ID,
SUM(OPN_QTY) AS OPENING,
0 AS RECEIPT,
0 AS ISSUE,
OPN_DT AS T_DT
FROM OPN
GROUP BY Q_ID, OPN_DT
UNION
SELECT Q_ID,
0 AS OPENING,
SUM(RCT_QTY) AS RECEIPT,
0 AS ISSUE,
RCT_DT AS T_DT
FROM RCT
GROUP BY Q_ID, RCT_DT
UNION
SELECT Q_ID,
0 AS OPENING,
0 AS RECEIPT,
SUM(ISU_QTY) AS ISSUE,
ISU_DT AS T_DT
FROM ISU
GROUP BY Q_ID, ISU_DT
);

—————————————————————
REPORT QUERY
————————————————————— SELECT Q_ID,
SUM(OPENING) AS OPENING,
SUM(RECEIPT) AS RECEIPT,
SUM(ISSUE) AS ISSUE,
MAX(T_DT) as T_DT
FROM
(
SELECT Q_ID,
SUM(OPENING) AS OPENING,
SUM(RECEIPT) AS RECEIPT,
SUM(ISSUE) AS ISSUE,
T_DT
FROM STK_V
WHERE T_DT BETWEEN :FROM_DT AND :TO_DT
AND Q_ID = :QLTY_ID
GROUP BY Q_ID, T_DT
UNION ALL
SELECT Q_ID,
((SUM(OPENING)+SUM(RECEIPT))-SUM(ISSUANCE)) AS OPENING,
0 AS RECEIPT,
0 AS ISSUE,
T_DT
FROM STK_V
WHERE T_DT < :FROM_DT
AND Q_ID = :QLTY_ID
GROUP BY Q_ID, T_DT
)
GROUP BY Q_ID, T_DT
ORDER BY T_DT
—————————————————————
FORMULA COLUMN IN REPORT TO GET BALANCE
—————————————————————

function BALANCE return Number is
begin
RETURN :OPENING + :RECEIPT – :ISSUE;
end;
————————————————————————
MAKE A SUMMARY COLUMN ON BALANCE FORMULA AT SAME LEVEL
————————————————————————

Report columns are: Opening, Receipt, Issuance, Balance

Hope it will be helpful.

Protected: Changing Color Scheme / Look and feel In Oracle Applications August 15, 2007

Posted by Muhammad Habib in Oracle Applications, Oracle Financials.
Enter your password to view comments.

This content is password protected. To view it please enter your password below:

Protected: Registering New Forms In Oracle Applications August 13, 2007

Posted by Muhammad Habib in Oracle Applications, Oracle Financials.
Enter your password to view comments.

This content is password protected. To view it please enter your password below:

Protected: Transferring data using FNDLOAD August 10, 2007

Posted by Muhammad Habib in DBA, Oracle Applications.
Enter your password to view comments.

This content is password protected. To view it please enter your password below: