Best Of

Re: What table stores the installation details in R12.2.13?

Hi Justin,

Installation details are part of CSI (Install Base) and are stored in the T tables.

You can use the following queries based on sales order line id

SELECT *
FROM csi_t_transaction_lines
WHERE source_transaction_id = :order_line_id;
SELECT *
FROM csi_t_txn_line_details
WHERE transaction_line_id IN
(
SELECT transaction_line_id
FROM csi_t_transaction_lines
WHERE source_transaction_id = :order_line_id);

Thank You !!

Piyush-Oracle

1

Re: Can we upload attachments (drawings, images, pictures for example) with WIP_EAM_WORKREQUEST_PUB publ

Hi,

No, Work Requests or any other entity is not using the product specific API but the generic FND Attachments APIs.

You can import any attachment to any entity using the fnd_webattch.add_attachment API. For EAM Work Requests you need to use parameters like:
category_id => &category_id,
entity_name => 'EAM_WORK_REQUESTS',
pk1_value => &Work_request_id
pk2_value => NULL
pk3_value => NULL
pk4_value => NULL
pk5_value => NULL

For category_id you need to get it based on the category you need to be used (but also enabled for the Work Request function). By default we have the Miscellaneous and the Work Request Attachments document categories associated to the Work Requests. To get the category_id for them you can use query:

select category_id, name, user_name from fnd_doc_categories_active_vl where user_name in ('Miscellaneous','Work Request Attachments');

See examples to use the API in document:

How To Import Item Attachments Via API or Interface? (Doc ID 1516752.1)

Please note that this API is not fully supported as it is designed to be used by product integration rather than external use. See:

Where to Find Documentation on Using API FND_WEBATTACH? (Doc ID 2779851.1)

Best regards,
Florin

Florin Stefan-Oracle

1

Re: Running a second multitenant CDB instance on the same server

Hi

For 19c, you do not need to set any special or version-specific parameter just because you are starting a second CDB instance for RMAN duplicate. Focus on unique ORACLE_SID, db_unique_name, and file paths.

Thanks
Swati A

Swati Aryasomayajula -Oracle

1

Re: Primavera P6 Standalone licensing

Hi @User_RMDHQ

Uninstall from the old machine

Install on the new machine

With standalone, it's that simple.

David

PMO

DavidCumming

1

Re: What does allowed transaction in material status define 'Staging transfer on a sales order ' mean

Hi @Ionut-Oracle ,

Thanks for the quick response , this helped understand the status definition.

User_29A0Y

1

Re: MessageBox with question using %MsgStyle_OKCancel makes my jsonarray empty ?!

Bart- When you use an OK/Cancel MessageBox, the PeopleCode runtime can destroy certain object references (like JsonArray). That’s why the array length looks reset after the dialog.

A reliable workaround is to wrap your array in a JSON object before showing the dialog, then re-parse it afterward. This preserves the contents.

Local JsonArray &jArray;

Local JsonObject &wrapper, &root;

Local JsonParser &parser;

Local number &length_before_question, &length_after_question, &Answer;

Local string &jsonStr;


&jArray = CreateJsonArray();

&jArray.AddElement("Name");

&jArray.AddElement("Name2");
&length_before_question = &jArray.Length();
/* Wrap array inside an object /

&wrapper = CreateJsonObject();

&wrapper.AddJsonArray("data", &jArray);

&jsonStr = &wrapper.ToString();

WinMessage(&jsonStr);

/ Prompt user */

&Answer = MessageBox(%MsgStyle_OKCancel, "", 0, 0, "Question?");

WinMessage(&Answer);
/* Rebuild after dialog /

&parser = CreateJsonParser();

If &parser.Parse(&jsonStr) Then

&root = &parser.GetRootObject();

&jArray = &root.GetJsonArray("data"); / <-- correct for your parser */

&length_after_question = &jArray.Length();

Else

&length_after_question = - 1;

End-If;
Warning "&length_before_question: " | &length_before_question | " - &length_after_question: " | &length_after_question;

Have tested and it does works/

-Velu

Velu Angusamy

1

Re: On Account Receipt Report

Please review the following:

Unapplied and Unresolved Receipts Register

Use the Unapplied and Unresolved Receipts Register to review detailed information
about your customers' on-account and unapplied payments for the date range that you
specify. Having an understanding of a customer's on-account and unapplied payments
more accurately indicates how much a customer actually owes you.
This report includes all receipts that are not fully applied to customer transactions. This
includes receipts with unapplied cash, in addition to receipts with applications that
require resolution, such as applications to:
• On Account
• Claim Investigation (for users of Oracle Trade Management only)

• Prepayment
This report excludes receipts applied to activities that do not affect the customer
balance, such as receipt write-offs, short-term debt, and credit card refunds. For
example, when you create a credit card refund, it is the credit memo associated with the
refund that affects the customer balance (and is reported in the Transaction Register).
This report also excludes miscellaneous receipts.
When reconciling, the Unapplied and Unresolved Receipts Register's total should match
the Unapplied Receipts Journal.
If the profile option AR: Sort Customer Reports by Alternate Fields is Yes, Receivables
will sort information using the value of the Alternate Name field in the Customers
window.
The Unapplied and Unresolved Receipts Register is an RXi report.

Thanks

Philip
AR CoE

Phil DeCoster - Support-Oracle

1

Re: Peoplesoft Schedule Query Reccurence field not enabled

Hello User,

Please perform this activity:-

Navigate to PeopleTools > Security > User Profiles > User Profiles and search for the user needing the rights.
Check for the permission set under "Process Profile".
Navigate to PeopleTools > Security > Permissions and Roles > Permission Lists and search for the permission listed in the "Process Profile".
Open the permission and navigate to the "Process" tab.
Click on "Process Profile Permissions".
Under "Allow Requestor To" enable "Enable Recurrence Selection" option.
Save and log-off.

Perform above task by Security Administrator and impacted user is not logged in it PeopleSoft application.

Thanks,
Akash

Akash A-Oracle

1

Re: NEW EBS Monitoring Analyzer

The Specific Diagnostic for Shipping Execution signals problems with Sales Order Lines Shipped but not Interfaced. The sql does take in to account that a sales order line can be linked to multiple delivery detail record where some can be cancelled. The Cancelled delivery details are not going to be marked as interfaced. They are then producing a false positive for the signal in the Diagnostic.

For instance the following sql could be used instead in order not to include where cancelled delivery details:

select
ORD.HEADER_ID,
LIN.LINE_ID,
DET.INV_INTERFACED_FLAG,
LIN.SHIPPED_QUANTITY,
LIN.FLOW_STATUS_CODE
from
OE_ORDER_HEADERS_ALL ORD,
OE_ORDER_LINES_ALL LIN,
WSH_DELIVERY_DETAILS DET
where
ORD.HEADER_ID = LIN.HEADER_ID
AND DET.SOURCE_LINE_ID = LIN.LINE_ID
AND DET.SOURCE_CODE = 'OE'
AND DET.INV_INTERFACED_FLAG = 'N'
AND LIN.SHIPPABLE_FLAG = 'Y'
AND nvl(LIN.SHIPPED_QUANTITY,0) > 0
AND LIN.FLOW_STATUS_CODE = 'CLOSED'
AND det.released_status <> 'D'
AND rownum < 1000

Please consider this a change request!

Regards
Niels LM

Niels LM

1

Re: One employee can have setup 2 PCARDS in two different Operating Units?

Thanks Hosana!

Accepted Answer

Mariana Ramirez

1

Welcome to the My Oracle Support Community

Best Of